Track weekly AI search visibility for your brand with Apify and Google Sheets

Description

Quick Overview
This workflow runs weekly to measure how often your brand and competitors are mentioned across selected AI engines using Apify’s AI Share of Voice Actor, then appends per-engine visibility metrics (mention rate, share of voice, rank, citations) to Google Sheets.

How it works
Runs every Monday at 08:00 (or manually) and loads your brand, competitors, prompts, and target engines from a configured JSON payload.
Starts an Apify Actor run (touchrock/ai-share-of-voice) with a maximum charge limit to check the prompts against the selected engines.
Polls the Apify run status every two minutes until it succeeds or exits the workflow with an error if the run ends in a non-success status.
Fetches the Actor OUTPUT report from the Apify key-value store once the run succeeds.
Converts the report into one row per brand and engine with metrics like mention rate, share of voice, average list rank, and citation rate.
Appends the generated rows to a Google Sheets worksheet for ongoing weekly tracking.

Setup
Create an Apify account, generate an API token, and add an n8n HTTP Header Auth credential that sends Authorization: Bearer for the Apify HTTP requests.
Edit the brand/competitor list, prompts, engines, country, language, and runs-per-prompt settings in the workflow’s input JSON.
Connect Google Sheets OAuth credentials and select the target spreadsheet and worksheet in the append step.
Ensure your sheet has columns matching the appended fields (for example: date, engine, brand, yourBrand, answers, mentionedIn, mentionRatePct, shareOfVoicePct, avgListRank, citationRatePct, runUrl).