AutomationMart
Home/Browse/Track Google search rankings with Bright Data, Google Sheets & Gmail
n8n

Track Google search rankings with Bright Data, Google Sheets & Gmail

n8nn8n10 modulesv1.0
GmailGoogle Sheets

This workflow automates daily or manual keyword rank tracking on Google Search for your target domain. Results are logged in Google Sheets and sent via email using Bright Data's SERP API. Requirements: - n8n (local or cloud) with Google Sheets and Gmail nodes enabled - Bright Data API credentials --- Main Use Cases - Track Google search rankings for multiple keywords and domains automatically - Maintain historical rank logs in Google Sheets for SEO analysis - Receive scheduled or on-demand HT

At a glance

Track Google search rankings with Bright Data, Google Sheets & Gmail is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, Google Sheets
Modules
10
Price
Free
Version
v1.0
Track Google search rankings with Bright Data, Google Sheets & Gmail workflow diagram

About this workflow

This workflow automates daily or manual keyword rank tracking on Google Search for your target domain. Results are logged in Google Sheets and sent via email using Bright Data's SERP API. Requirements: - n8n (local or cloud) with Google Sheets and Gmail nodes enabled - Bright Data API credentials --- Main Use Cases - Track Google search rankings for multiple keywords and domains automatically - Maintain historical rank logs in Google Sheets for SEO analysis - Receive scheduled or on-demand HTML email reports with ranking summaries - Customize or extend for advanced SEO monitoring and reporting --- How it works The workflow is divided into several logical steps: 1. Workflow Triggers - Manual: Start by clicking 'Test workflow' in n8n. - Scheduled: Automatically triggers every 24 hours via Schedule Trigger. 2. Read Keywords and Target Domains - Fetches keywords and domains from a specified Google Sheets document. - The sheet must have columns: Keyword and Domain. 3. Transform Keywords - Formats each keyword for URL querying (spaces become +, e.g., seo expert → seo+expert). 4. Batch Processing - Processes keywords in batches so each is checked individually. 5. Get Google Search Results via Bright Data - Sends a request to Bright Data's SERP API for each keyword with location (default: US). - Receives the raw HTML of the search results. 6. Parse and Find Ranking - Extracts all non-Google links from HTML. - Searches for the target domain among the results. - Captures the rank (position), URL, and total number of results checked. Saves timestamp. 7. Save Results to Google Sheets - Appends the findings (keyword, domain, rank, found URL, check time) to a “Results” sheet for history. 8. Generate HTML Report and Send Email - Builds an HTML table with current rankings. - Emails the formatted table to the specified recipient(s) with Gmail. --- Setup Steps 1. Google Sheets: - Create a sheet named “Results”, and another with Keyword and Domain columns. - Update document ID and sheet names in the workflow’s config. 2. Bright Data API: - Acquire your Bright Data API token. - Enter it in the Authorization header of the 'Getting Ranks' HTTP Request node. 3. Gmail: - Connect your Gmail account via OAuth2 in n8n. - Set your destination email in the 'Sending Email Message' node. 4. Location Customization: - Modify the gl= parameter in the SERP API URL to change country/location (e.g., gl=GB for the UK). --- Notes - This workflow is designed for n8n local or cloud environments with suitable connector credentials. - Customize batch size, recipient list, or ranking extraction logic per your needs. - Use sticky notes in n8n for further setup guidance and workflow tips. --- With this workflow, you have an automated, repeatable process to monitor, log, and report Google search rankings for your domains—ideal for SEO, digital marketing, and reporting to clients or stakeholders.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Centralize your forms and reply automatically with Tally + Airtable + Gmail

Still manually copy-pasting your Tally form responses? What if every submission went straight into Airtable — and the user got an automatic email right after? That’s exactly what this workflow does. No code, no headache — just a simple and fast automation: Tally → Airtable → Gmail. STEP 1 — Capture Tally Form Responses Goal Trigger the workflow automatically every time someone submits your Tally form. What we're setting up A webhook that catches form responses and kicks off the rest of the flow.

Free

Validate e-mail addresses by IPQualityScore and create new customers in WooCommerce for new Google Sheets rows

Every time a new row is added to a Google Sheet, Make will automatically validate the email address by IPQualityScore and create new customer in WooCommerce. The example uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1Dy6ojlUqe5BX8p754tzkpCahaJ8zuQmem3l77gLR-T8/edit?usp=sharing).

Free

Automatic Topic & Sentiment Extraction from Jotform Responses with Google Gemini

Who this is for This workflow is designed for teams that collect feedback or survey responses via Jotform and want to automatically: - Analyze sentiment (positive, neutral, negative) of each response. - Extract key topics and keywords from qualitative text. - Generate AI summaries and structured insights. - Store results in Google Sheets and n8n DataTables for easy reporting and analysis. Use Cases - Customer experience analysis - Market research & survey analysis - Product feedback cluste

Free

Track SEO keyword position in Google SERP (Google Sheets + SerpAPI integration)

This n8n workflow automates scheduled checks for your target keywords’ positions in Google’s organic search results using SerpAPI. It logs new positions in Google Sheets, compares them to previous rankings, and sends notifications via WhatsApp and/or email based on the movement. --- Problem Statement & Target Audience Who is this for? This workflow is ideal for: - SEO specialists monitoring keyword rankings. - Website owners tracking performance. - Agencies managing multiple client campaigns.

Free

Send updates from Telegram to Google Sheets and generate parsed responses with ChatGPT

Automatically send Telegram updates to Google Sheets and generate responses using OpenAI GPT-3. Streamline communication and data management with this powerful integration.

Free

Update Google Sheets rows with weather forecast for places along your route

Every time this scenario is run, Make will automatically update selected Google Sheets rows with the weather forecast for specified locations. The template uses this [example spreadsheet](https://goo.gl/TZa0Q9).

Free

Automate email responses with GPT-4o-mini and human review in Gmail

This n8n template demonstrates a “Human-in-the-Loop” workflow where AI automatically drafts replies to inbound emails, which are then reviewed and approved by a human before being sent. This powerful pattern ensures both the efficiency of AI and the quality assurance of human oversight. Use cases are many: Streamline sales inquiry responses, manage first-level customer support, handle initial recruitment communications, or any business process that requires personalized yet consistent email repl

Free

Automate employee onboarding with Slack, Jira, and Google Workspace integration

Who is this for? This template is ideal for HR teams, startup founders, operations leads, remote-first companies, and freelancers managing onboarding manually or across multiple tools. Whether you’re hiring your first intern or streamlining onboarding for dozens of new team members, this workflow automates the entire trigger → task creation → onboarding delivery process using no-code tools connected via n8n. --- What problem does this solve? Employee onboarding is often fragmented and error-pron

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free