Skip to content
FlowHubFluxonLab
C
Gmailfree

Get new ranked Google AI Overview keywords via email with DataForSEO

by DataForSEOadapted from n8n official workflow galleryUpdated Aug 2026
RequiresCCodeGmailGmailGoogle SheetsGoogle Sheets
Share Post Share
AgAggregateDFGet ranked keywordsGet ranked keyw…Get previous keywordsGet previous ke…Get targetsAppend keyword in sheetAppend keyword …ScRun every MondayAgAggregate1Clear sheetSend a messageSeInitialize "items" fieldInitialize "ite…SeSet "items" fieldSet "items" fie…SeMerge "items" with DFS responseMerge "items" w…IfHas more pages?SeMerge "items" with last responseMerge "items" w…FiFilter (has new AIO keywords)Filter (has new…CoFind new AIO keywordsFind new AIO ke…SOSplit out (items)Split out (item…SILoop over targetsLoop over targe…12345678910111213141516171819
1/5
STEPS · 19
Runs on a schedule

Once a week, this workflow automatically detects newly ranked keywords in Google AI Overview across your domains using DataForSEO API. It pulls the latest data for every target, stores a new snapshot in Google Sheets, and compares it with the previous run. Any new keywords and related info is automatically appended to a dedicated log sheet, and a short email recap is sent to your chosen recipients, so your team can easily review updates without manual monitoring. Who’s it for SEO specialists and marketers who want a hands-off way to track newly ranked keywords in Google’s AIO for specific domains and get weekly updates without manual checks. What it does This workflow automatically discovers new keywords your domains started ranking for in Google AI Overview (AIO), logs them in Google Sheets, and emails you a weekly summary of what’s changed. How it works Triggers on a chosen schedule (default: once a week). Reads your keywords and domains from Google Sheets. Pulls the latest data from Google AI Overview via DataForSEO API. Compares the results with the previous snapshot. Appends newly ranked keywords to a dedicated Google Sheet. Sends a weekly summary email.

Tags

n8nreference-onlygmailgoogle-sheets
Connects
CCodegmailGmailsheetsGoogle Sheets
CategoryGmail
Triggermanual
Complexitycomplex
Nodes18
AddedFeb 16, 2026

Related workflows

See all Gmail
CgmailsheetsW
free

Sync HubSpot Contacts with LinkedIn URLs, Detect Changes & Send Gmail Alerts

Automate CSV imports into HubSpot without the mess. Powered by n8n. Supercharged by Pollup AI. Who’s this for? This workflow is perfect for Ops-minded folks in Customer Success, Marketing, and Sales – especially if you’re juggling CSV lists, CRM updates, and team-wide reporting. Whether you're a CS ops lead syncing product usage, or a RevOps manager updating contact records, this will save you hours. 🧠 Why it matters Manually importing CSVs into HubSpot is a headache: ❌ Copy-paste errors ❌ Mismatched fields ❌ Wasted time formatting every upload This workflow does the heavy lifting for you: ✅ Pulls fields dynamically from your HubSpot instance ✅ Preps and maps CSV data in minutes ✅ Syncs with Google Sheets to keep your source of truth aligned 🔄 What the workflow actually does Pulls live field names from HubSpot’s API (no guesswork) Indexes and organizes your CSV for import Processes & transforms raw data (optional filters, cleanup, etc.) Dynamically maps CSV fields to HubSpot fields Executes the upload and logs results ⚙️ How to get started Prerequisites: HubSpot private app token Google Sheets API credentials Access to an n8n instance (cloud or self-hosted) Setup in 3 steps: Impo

by PollupAI
Cgmailsheetssupabase
free

Raw Materials Inventory Management with Google Sheets, Supabase and Approvals

Automated Raw Materials Inventory Management with Google Sheets, Supabase, and Gmail using n8n Webhooks Description What Problem Does This Solve? 🛠️ This workflow automates raw materials inventory management for businesses, eliminating manual stock updates, delayed material issue approvals, and missed low stock alerts. It ensures real-time stock tracking, streamlined approvals, and timely notifications. Target audience: Small to medium-sized businesses, inventory managers, and n8n users familiar with Google Sheets, Supabase, and Gmail integrations. What Does It Do? 🌟 Receives raw material data and issue requests via form submissions. Updates stock levels in Google Sheets and Supabase. Manages approvals for material issue requests with email notifications. Detects low stock levels and sends alerts via Gmail. Maintains data consistency across Google Sheets and Supabase. Key Features Real-time stock updates from form submissions. Automated approval process for material issuance. Low stock detection with Gmail notifications. Dual storage in Google Sheets and Supabase for redundancy. Error handling for robust data validation. Setup Instructions Prerequisites n8n Instance**: Self-hoste

by Immanuel
gmailsheetsW
free

Move data between JSON and spreadsheets

This workflow illustrates how to convert data from JSON to binary format and import JSON data or files into Google Sheets or local spreadsheets.

by Lorena