Step 2: Connect Google Sheets

Pull seed domains from a Google Sheet and prepare the destination sheet for results.

1. Open Fetch Seed Entries and set Document to [YOUR_ID] and Sheet to 1232412.
2. Credential Required: Connect your googleSheetsOAuth2Api credentials in Fetch Seed Entries.
3. Open Append Results to Sheet and set Operation to append.
4. Set Document to [YOUR_ID] and Sheet to [YOUR_ID] in Append Results to Sheet.
5. Credential Required: Connect your googleSheetsOAuth2Api credentials in Append Results to Sheet.

⚠️ Common Pitfall: Ensure the destination sheet contains the exact column names mapped in Append Results to Sheet, such as keywords, Search Volume, and Keyword Difficulty.

Step 3: Set Up Keyword Retrieval and Parallel API Calls

Split the seed list into batches, call the keyword API, and run difficulty scoring in parallel.

1. Open Iterate Domain List and keep default batch options, then connect it to Pull Site Keywords and Append Results to Sheet.
2. In Pull Site Keywords, set URL to https://api.dataforseo.com/v3/dataforseo_labs/google/keywords_for_site/live and Method to POST.
3. Set JSON Body in Pull Site Keywords to =[{ "target": "{{ $json.seed }}", "location_name": "{{ $json.location_name }}", "language_name": "{{ $json.language_name }}", "limit": {{ $json.limit }} }].
4. Pull Site Keywords outputs to both Retrieve Difficulty Scores and Combine Data Streams in parallel.
5. In Retrieve Difficulty Scores, set URL to https://api.dataforseo.com/v3/dataforseo_labs/google/bulk_keyword_difficulty/live and Method to POST.
6. Set JSON Body in Retrieve Difficulty Scores to ={{ JSON.stringify([ { "keywords": $json.tasks[0].result[0].items.map(i => i.keyword), "location_name": $('Iterate Domain List').item.json.location_name, "language_name": $('Iterate Domain List').item.json.language_name } ]) }}.

⚠️ Common Pitfall: The DataForSEO endpoints require authentication headers—add your API credentials in the Headers section of both Pull Site Keywords and Retrieve Difficulty Scores.

Step 4: Set Up Data Merging and Transformation

Combine the keyword and difficulty streams, then reshape the data into rows for Google Sheets.

1. Open Combine Data Streams and set Mode to combine and Combine By to combineByPosition.
2. Connect Retrieve Difficulty Scores to input 2 of Combine Data Streams, and Pull Site Keywords to input 1.
3. In Transform Keyword Rows, keep the provided JavaScript Code to map keyword metrics and difficulty into row objects.
4. Connect Combine Data Streams to Transform Keyword Rows, then to Aggregate Output Items.
5. In Aggregate Output Items, set Aggregate to aggregateAllItemData.
6. Open Flatten Aggregated Rows and keep the provided JavaScript Code to output individual row items.

Step 5: Configure Output Mapping to Google Sheets

Map the transformed fields to the destination sheet columns and complete the loop for each batch.

1. Connect Flatten Aggregated Rows to Iterate Domain List so the loop continues until all domains are processed.
2. In Append Results to Sheet, confirm column mappings such as keywords → ={{ $json.keywords }} and Keyword Difficulty → ={{ $json['Keyword Difficulty'] }}.
3. Verify additional mappings like Search Volume → ={{ $json['Search Volume'] }} and SE Type → ={{ $json['SE Type'] }}.

Step 6: Test and Activate Your Workflow

Validate the workflow with a manual run, then enable it for scheduled execution.

1. Click Execute Workflow to run Scheduled Run Trigger manually.
2. Check that Fetch Seed Entries returns seed data and that Append Results to Sheet appends rows to your Google Sheet.
3. Confirm that Pull Site Keywords and Retrieve Difficulty Scores both return valid API responses and merge correctly in Combine Data Streams.
4. Once validated, toggle the workflow to Active to enable scheduled runs.