Step 2: Connect the SERP Data Source

Configure the HTTP request that retrieves Google SERP data for each keyword.

1. Add Primary SERP Request and set URL to https://api.scrapingrobot.com.
2. Set Method to POST and Specify Body to JSON.
3. Set JSON Body to { "url": "https://www.google.com", "module": "GoogleScraper", "params": { "query": "{{ $json["Keyword"] }}" } }.
4. Enable Send Body and Send Headers.
5. Add a header parameter with Name accept and Value application/json.
6. Credential Required: Connect your httpQueryAuth credentials (used by Primary SERP Request).
7. Credential Required: Connect your httpHeaderAuth credentials (also configured on Primary SERP Request).

⚠️ Common Pitfall: If the SERP API returns errors, verify the authentication type is set to genericCredentialType with httpQueryAuth and that your header auth matches the provider’s requirements.

Step 3: Define and Expand Keywords

Create the keyword array and split it into individual requests.

1. In Define Keyword List, add an assignment with Name Keyword, Type array, and Value ["constant contact email automation", "business worfklow software", "n8n automation"].
2. Connect Database Placeholder Step to Define Keyword List.
3. In Expand Keyword Items, set Field To Split Out to Keyword.
4. Connect Define Keyword List to Expand Keyword Items, then to Primary SERP Request.

Step 4: Map, Filter, and Enrich SERP Results

Transform the API response, split out organic results, and attach the query term for ranking.

1. In Map SERP Output, set organicResults to {{ $json.result.organicResults }}.
2. Set peopleAlsoAsk to {{ $json.result.peopleAlsoAsk }}, searchQuery to {{ $json.result.searchQuery.term }}, and paidAds to {{ $json.result.paidResults }}.
3. Connect Primary SERP Request to Map SERP Output, then to Split Organic Results.
4. In Split Organic Results, set Field To Split Out to organicResults.
5. In Filter Nonempty Titles, configure the condition as String → notEmpty with Left Value {{ $json.title }}.
6. In Attach Query Term, enable Include Other Fields and set searchQuery to {{ $('Map SERP Output').item.json.searchQuery }}.
7. Connect Filter Nonempty Titles to Attach Query Term.

Step 5: Compute SERP Rank and Prepare Output

Assign ranking positions and send results to the output stub.

1. In Compute SERP Rank, use the provided JavaScript to group by searchQuery and add position based on index.
2. Connect Attach Query Term to Compute SERP Rank.
3. Connect Compute SERP Rank to Database Output Stub to hold results for a future database write.

⚠️ Common Pitfall: If ranking positions are off, ensure Attach Query Term includes the correct searchQuery value before it reaches Compute SERP Rank.

Step 6: Test and Activate Your Workflow

Run a manual test to confirm the SERP requests and ranking logic work end-to-end.

1. Click Execute Workflow from Manual Execution Start to run the full sequence.
2. Confirm Primary SERP Request returns data and Map SERP Output produces organicResults and searchQuery.
3. Verify Compute SERP Rank outputs items with a numeric position field.
4. Once verified, activate the workflow for production use and replace Database Output Stub with your actual data storage node.