SEO ranking tracker

Automatically track your website's position in Google search results for key queries.

Google Gemini

Google Sheets

Use this template

Created by

Relay.app Team

Relay.app screenshot of: SEO ranking tracker

Steps in this workflow

Trigger

Search Google

Analyze results

Update row

Use this template

Monitor your website's SEO performance by automatically tracking search rankings for important keywords. The workflow runs on a schedule, searching Google for queries stored in your spreadsheet and analyzing the results. An AI assistant identifies the top 10 ranking URLs and determines your website's position among them. Results are automatically written back to your Google Sheet, giving you ongoing visibility into your SEO performance without manual searches.

Trigger

Activates the workflow on a predetermined schedule to automatically run your SEO tracking. The schedule can be configured based on how frequently you want to monitor your rankings.

Search Google

Performs a Google search using the query from your spreadsheet row. This step retrieves up to 50 search results that will be analyzed in the next step.

Analyze results

Analyzes the Google search results using AI to identify the top 10 ranking URLs. The AI creates a formatted list of these URLs and determines the position of your website within the search results.

Prompt used

You are an SEO analyst. Please review the search results that were returned for this query: [data]. Please list out the URLs of the top 10 items in a nicely formatted rich text summary. Example of the list of URLs below. Please make sure to include the rank as a number for the numbered list. 1. https://relay.app/test 2. https://zapier.com/test ... Also output the rank of the first page that includes the URL of my domain (counting from 1, so matching the numbering of the list).

Relay.app screenshot of: Analyze results

Update row

Updates your Google Sheets row with the formatted list of top 10 URLs from the search results. This ensures your spreadsheet is automatically kept up-to-date with the latest ranking information.