See llms.txt for all machine-readable content.

Back to Templates

Run GEO website audits from Google Sheets with GEO Search Leads

Created by

Created by: GEO Search Leads || teamgsl
GEO Search Leads

Last update

Last update 9 hours ago

Categories

Quick overview

This workflow runs manually to read Pending website URLs from Google Sheets, scan each site with GEO Search Leads (Lite GEO Scan), and write back the GEO score, scan ID, and dashboard link while marking each row as Completed or Failed.

How it works

  1. Runs when you manually execute the workflow in n8n.
  2. Reads rows from Google Sheets where the Status column equals Pending.
  3. Processes the sheet rows one at a time and confirms each item is still marked Pending.
  4. Sends the Website URL to GEO Search Leads to run a Lite GEO Scan.
  5. Updates the matching Google Sheets row with Completed status, GEO Score, Scan ID, and a GEO Search Leads dashboard URL, or marks the row as Failed if the scan errors.
  6. Waits 5 seconds between scans and continues until all pending rows are processed.

Setup

  1. Connect Google Sheets credentials in all Google Sheets steps and select your spreadsheet and sheet tab (document ID and sheet name).
  2. Connect your GEO Search Leads credentials for the Lite GEO Scan step.
  3. Create a Google Sheet with the headers Website URL, Status, GEO Score, Scan ID, and Dashboard Scan URL, and set new rows to Status = Pending.

Requirements

  • Google Sheets account with API access.
  • Free GEO Search Leads account.
  • n8n instance with the GEO Search Leads integration available.

Customization

  • Adjust the delay between GEO scans
  • Customize Google Sheets columns and mappings
  • Extend the workflow with automated email notifications

Additional info

⁠Create a free GEO Search Leads account