See llms.txt for all machine-readable content.

Back to Templates

Find unlinked brand mentions with Brave Search, OpenAI and Google Sheets

Created by

Created by: Miguel Cantu | De Marketing || migueldemarketing
Miguel Cantu | De Marketing

Last update

Last update 9 hours ago

Categories

Quick overview

This workflow runs every Monday (or manually) to find new web pages that mention your brand without linking to your site using Brave Search, reviews promising mentions with an OpenAI-powered agent, logs results in Google Sheets, and emails you a scored outreach digest via Gmail.

How it works

  1. Runs on a weekly schedule (or manual start) and loads your brand settings like domain, query, skip list, scoring threshold, and notification email.
  2. Searches the web with the Brave Search API, cleans and deduplicates results, and removes your own domain and any skipped domains.
  3. Reads your Google Sheets log and drops any URLs that were already checked, then limits processing to the configured maximum pages per run.
  4. Downloads each remaining page and inspects the HTML to determine whether it already links to your domain and whether the brand name appears in the readable page text.
  5. For pages with an unlinked mention, uses an OpenAI agent (optionally fetching a contact/about page) to confirm it’s about your brand, score relevance, find contact details, and draft a short outreach note in the page’s language.
  6. Appends one row per checked page to Google Sheets with a status (for example unlinked, linked, not_about_brand, brand_not_found, unreachable, or needs_review) and any AI outputs.
  7. Builds an HTML digest of high-scoring opportunities and pages needing manual review, and sends it to you via Gmail only when there is something to report.

Setup

  1. Create a Google Sheet with columns for checked_at, url, page_title, domain, status, relevance, mention_context, contact, outreach_draft, and notes, then select the spreadsheet and sheet in both Google Sheets nodes.
  2. Add a Brave Search API key and configure the HTTP header auth for the Brave Search request using the X-Subscription-Token header.
  3. Add OpenAI credentials for the chat model used by the AI agent and confirm the model selection meets your account’s access.
  4. Add Gmail OAuth2 credentials and set the notification email address in the workflow settings so the digest can be sent.
  5. Update the editable settings (brand name/context, own domain, search query, skip domains, max pages per run, and minimum relevance score) to match your brand and outreach criteria.