Quick Overview
Quick Overview This workflow runs daily to test whether Fairy Frills appears in AI shopping recommendations by querying OpenAI with 10 brand-focused questions (with and without web search), extracting mention and competitor data, generating a GEO gap analysis, and emailing a consolidated HTML report via Gmail. How it works Runs every 24 hours on a schedule. Generates 10 predefined shopping queries for Fairy Frills and includes the brand URL and a competitor list with each query. Sends each query to OpenAI twice in parallel, once to gpt-4o-mini (no search) and once to gpt-4o-search-preview (web search enabled). Combines the two model responses per query and uses OpenAI to extract structured metrics such as whether Fairy Frills is mentioned, mention count and position, competitor mentions, sentiment, and a key snippet. Uses OpenAI again to perform a GEO (Generative Engine Optimization) gap analysis that explains why competitors ranked, why the target brand missed, and which content actions and exact phrases to add. Deduplicates and aggregates insights across all checks, builds an HTML summary, and sends the daily GEO report email via Gmail. Sends a Slack message when the workflow encounters an execution error. Setup Add an OpenAI API credential for the OpenAI nodes used for answering, mention extraction, and GEO gap analysis. Connect Gmail OAuth2 credentials and set the recipient email address in the Gmail send node. Connect Slack OAuth2 credentials and replace YOUR_SLACK_CHANNEL_ID with the channel to receive workflow error alerts. Review and edit the brand name, brand URL, competitor list, and the 10 queries in the query-builder code to match your business. Activate the schedule trigger (or change the interval) to control how often the report is generated. An n8n automation workflow template by Rahul Joshi.
Rahul Joshi
web
free
Others in the same category, ranked by how often they are opened.
