See llms.txt for all machine-readable content.

Back to Templates

Create weekly content briefs in Notion with MentionBird.ai and OpenAI

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

  1. Runs every Monday at 10:00 on a schedule.
  2. Calculates the last N complete days (ending yesterday, in UTC) and queries MentionBird.ai to determine how many prompt pages to fetch.
  3. 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.
  4. 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.
  5. For each selected prompt, pulls supporting evidence from MentionBird.ai: top alternative brands mentioned, top citation domains, and top web searches used while answering.
  6. Sends the prompt and evidence to OpenAI to generate a structured content brief in Markdown.
  7. 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

  1. 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.
  2. 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.
  3. 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.
  4. 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