Templates / Analyze SEO visibility and opportunities with TalorData, GPT-4o, Google Sheets, and Gmail

Analyze SEO visibility and opportunities with TalorData, GPT-4o, Google Sheets, and Gmail

Unknown

by Talordata · 40 views · created 2026-07-31 · Market Research, AI RAG

Unknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.

Community nodes

These come from third-party npm packages. In n8n 3.0 unverified community packages are off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).

Nodes used (11)

AI AgentOpenAI Chat ModelStructured Output ParserGoogle SheetsGmail

What it does

Quick overview This workflow accepts an SEO brief and uses TalorData Google Search results plus OpenAI to produce evidence-backed visibility insights for a target domain and competitors, then logs structured records to Google Sheets and emails a client-ready HTML report via Gmail. How it works 1. Receives an SEO brief via a POST webhook (or optionally via a manual run or weekly schedule after connecting the default brief). 2. Validates and normalizes the target domain, keywords, competitors, locale settings, and search depth, then creates one Google Search task per keyword. 3. Queries Google Search through the TalorData SERP community node for each keyword using the configured country, language, and region. 4. Extracts and normalizes organic results, determines the target domain’s rank and competitor presence, and derives deterministic opportunity signals from SERP evidence. 5. Sends the evidence-only dataset to OpenAI (gpt-4o) to generate a structured SEO analysis, then filters the model output to allowed keywords and evidence links. 6. Appends unified visibility, competitor, and opportunity rows into Google Sheets for tracking. 7. Generates a concise HTML report from the validated results and emails it to the configured recipient using Gmail. Setup 1. Install the community node package n8n-nodes-talordata-serp (v0.1.9+) and create a TalorData SERP API credential for the TalorData Google Search node. 2. Add an OpenAI credential for both language model nodes (gpt-4o) used for analysis and HTML report generation. 3. Connect Google Sheets OAuth, then select the target spreadsheet document and worksheet in the Google Sheets append step and ensure the sheet has matching columns for the mapped fields. 4. Connect Gmail OAuth and set the recipient email address in the Gmail send step. 5. If you want manual or scheduled runs, connect “Set Default SEO Brief” to the SEO brief validation step and adjust the default domain, keywords, locale, and search depth as needed.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.