Monitor Google Search rankings with SerpApi and Google Sheets

Google Keyword SEO Monitoring

What this is about

This workflow enables SEO monitoring by checking Google rank positions for a list of keywords and domains. It uses SerpApi's Google Search API, but can be customized to use any of SerpApi's APIs.

How it works

The workflow accepts Google Sheet with a list of keywords and domains to identify their rank in Google search results.

The results are synced to two sheets in a Google Sheet. The first is a log of all past runs. The second is an overview list showing the results from the latest run.

The workflow includes a Wait node that delays between each keyword to avoid Google Sheets API rate limiting. Adjust this if you have a custom rate limit.

Setup

Create a free SerpApi account here: https://serpapi.com/ Add SerpApi credentials to n8n. Your SerpApi API key is here: https://serpapi.com/manage-api-key Connect your Google Sheets accounts to n8n. Help available here: https://n8n.io/integrations/google-sheets/ Copy this Google Sheet to your own Google account: https://docs.google.com/spreadsheets/d/148gjSSqSY5x9Gz5JWE_FDXHOuB7ASTomSyxkZjrjuNc/edit?gid=1750873622#gid=1750873622 Set your list of keywords and domains in the 'Latest Run' sheet. Connect your Google Sheet in the 'Get Keywords and Domains to Match' node Connect your Google Sheet in the 'Update Rank Log' node Connect your Google Sheet again in the 'Update Latest Run' node (Optional) Customize the schedule to your needs (Optional) Set a custom page limit and match type in 'Set Page Limit & Match Type'

Documentation

SerpApi Google Search API SerpApi n8n Node Intro Guide