Scrape Google search rankings into Google Sheets with ScrapeUnblocker

Quick Overview

This workflow manually runs a Google SERP scraper that reads keywords from Google Sheets, fetches Google search result pages via ScrapeUnblocker, extracts the top organic results, and writes the parsed ranks, titles, and snippets back to Google Sheets.

How it works

1. Starts when you manually trigger the workflow.
2. Reads the list of keywords from a Google Sheets worksheet.
3. Processes the keywords in batches and builds a Google Search URL (with num=10) for each keyword.
4. Uses ScrapeUnblocker to fetch the HTML for each Google search results page.
5. Parses the HTML to extract organic result rank, title, URL, meta description snippet, an optional published date, and the scrape date.
6. Updates the Google Sheets worksheet with the extracted SERP data and continues until all keywords are processed.

Setup

1. Add a Google Sheets credential and update the spreadsheet ID, worksheet/tab, and input column name (expects a Keyword field) to match your sheet.
2. Add your ScrapeUnblocker credentials and confirm the workflow can access https://www.google.com/search from your environment.
3. Ensure the target Google Sheet has columns that match the fields being written (at least Keyword, Rank, Title, Meta Description, and Date, and optionally URL).