Quick overview
This workflow runs every Monday to pull “never-mentioned” prompts from MentionBird.ai for the last 30 days, generates a Markdown content brief with OpenAI using supporting evidence, and creates one new page per prompt in a Notion database.
How it works
- Runs every Monday at 10:00 on a schedule.
- Calculates the last N complete days (ending yesterday, in UTC) and queries MentionBird.ai to determine how many prompt pages to fetch.
- Retrieves all prompt visibility results from MentionBird.ai, stops with an error if the API refuses the request, and also loads your currently tracked prompts.
- Reads existing pages from your Notion database and selects up to the configured number of tracked prompts where your brand was never mentioned, skipping prompts that already have a matching Notion page and prioritizing higher search volume.
- For each selected prompt, pulls supporting evidence from MentionBird.ai: top alternative brands mentioned, top citation domains, and top web searches used while answering.
- Sends the prompt and evidence to OpenAI to generate a structured content brief in Markdown.
- Removes any code fences, skips empty model responses, and creates a new Notion database page titled with the prompt (and country when not Global) containing the brief.
Setup
- Create a read-only MentionBird.ai API key (your plan needs API access) and add it to n8n as an HTTP Bearer Auth credential used by all MentionBird.ai MCP requests.
- In the Report settings node, set the
brand value to match your brand name exactly as it appears in MentionBird.ai and adjust days and briefs_per_run as needed.
- Create a Notion database, connect Notion credentials in n8n (OAuth2 or API key for self-hosted), and select the target database in the Notion read and create steps.
- In OpenAI Chat Model, choose an OpenAI credential, or Gateway credits on n8n Cloud.
Requirements
- A MentionBird.ai plan with API access
- A Notion database
- An OpenAI API key, or Gateway credits on n8n Cloud
- n8n 2.31.0 or later