Step-by-Step Implementation Guide

Configure the Schedule Trigger

Set the workflow to run on a weekly cadence using the built-in scheduler.

1. Add and open Weekly Schedule Trigger.
2. Set the schedule rule to a weekly interval (the node uses Rule → weeks).
3. Connect Weekly Schedule Trigger to Set Workflow Config to start the pipeline.

Connect Google Sheets

Configure your input and output spreadsheets so the workflow can read URLs and write audit results.

1. Open Set Workflow Config and set sheet_id to your spreadsheet ID (replace change me! with the real ID).
2. In Retrieve URL List Sheet, set Document ID to {{ $json.sheet_id }} and Sheet Name to Input (gid 0).
3. In Append Summary to Sheets, set Operation to append, Sheet Name to Output, and Document ID to {{ $('Set Workflow Config').item.json.sheet_id }}.
4. In Append Issues to Sheets, set Operation to append, Sheet Name to All Issues, and Document ID to {{ $('Set Workflow Config').item.json.sheet_id }}.
5. Credential Required: Connect your Google Sheets credentials in Retrieve URL List Sheet, Append Summary to Sheets, and Append Issues to Sheets.

Set Up URL Batching and Page Fetch

Iterate through each URL and fetch page content for analysis.

1. Open Batch URL Iterator and keep the default settings to process incoming rows in batches.
2. In Decodo Page Fetch, set URL to {{ $json.URL_list }}.
3. Credential Required: Connect your Decodo credentials in Decodo Page Fetch.
4. Verify the flow: Retrieve URL List Sheet → Batch URL Iterator → Decodo Page Fetch.

Set Up Build SEO Audit

Use the Gemini model and structured output parser to generate a strict JSON audit from the fetched page content.

1. Open Build SEO Audit and keep Prompt Type set to define with the provided system/user prompt text.
2. Ensure the prompt uses the expressions {{ $('Batch URL Iterator').item.json.URL_list }}, {{ $json.data.results[0].status_code }}, {{ $json.data.results[0].updated_at }}, and {{ $json.data.results[0].content }}.
3. Connect Gemini Chat Model as the language model for Build SEO Audit.
4. Credential Required: Connect your Google Gemini credentials in Gemini Chat Model.
5. Attach Structured JSON Parser as the output parser for Build SEO Audit and keep the manual schema as provided.
6. Credential Required: Add any AI credentials to the parent Build SEO Audit node (the Structured JSON Parser uses the parent’s configuration).

Configure Output Processing and Parallel Writes

Split the AI output into summary and issue-level rows, then append both to Google Sheets.

1. Build SEO Audit outputs to both Compose Summary Row and Expand Issue Records in parallel.
2. In Compose Summary Row, keep the JavaScript that maps output[0] into a single summary row.
3. In Append Summary to Sheets, confirm column mappings use expressions like {{ $json.url }}, {{ $json.decodo_score }}, and {{ $json.recommended_actions }}.
4. In Expand Issue Records, keep the JavaScript that expands all_issues into multiple rows.
5. In Append Issues to Sheets, confirm column mappings include {{ $json.title }}, {{ $json.severity }}, and {{ $json.score_delta }}.
6. Connect both append nodes to Merge Summary and Issues, then route to Batch URL Iterator to continue processing.

Test and Activate Your Workflow

Run a manual test to validate the weekly audit pipeline before enabling production mode.

1. Click Execute Workflow and verify Retrieve URL List Sheet reads your input URLs.
2. Check that Decodo Page Fetch returns content and Build SEO Audit outputs a JSON object matching the Structured JSON Parser schema.
3. Confirm new rows appear in the Output and All Issues sheets from Append Summary to Sheets and Append Issues to Sheets.
4. Ensure Completion Marker is reached after all URLs are processed.
5. When successful, toggle the workflow to Active so Weekly Schedule Trigger runs on schedule.