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.