Find competitor-citing publishers using HasData and Google Sheets

Quick overview Find pages cited by Google AI Mode that mention your competitors, then review them as potential publisher opportunities. The workflow reads shortlisted pages and saves matching passages, brand evidence and citing prompts to Google Sheets so SEO and PR teams can decide which sources deserve further research. How it works 1. Read customer research questions from the Prompts tab. Validate your brand settings and input limits, rejecting duplicate prompts and oversized batches before making paid requests. 2. Read the existing Results tab and check for duplicate saved keys. Every input prompt is searched again on each run; the saved rows are not a cache that skips previously processed queries. 3. Use HasData to retrieve Google AI Mode citations for each prompt. Combine repeated source URLs and retain all the prompts that cited each page. 4. Prioritize pages cited across several prompts. Exclude your own domain, configured competitor domains and selected social platforms before reading pages. Select up to maxpages for the whole run. 5. Fetch a limited shortlist with HasData Web Scraping and extract page text, titles, headings and links. Keep the source URL attached to each response. Failed reads, excluded sources and sources beyond the page budget remain visible in the results. 6. Look for named competitors and your brand aliases in the extracted text, retaining the actual matching passages. Check returned links for your domain too. Mark pages with competitor mentions and no observed brand match as reviewpublisherfit; mark pages with existing brand evidence separately. 7. Save both the prompt-level citation inventory and the page-level research queue to Google Sheets. Filter status to reviewpublisherfit and inspect competitorsobserved, citingprompts and sourceurl before deciding whether a publisher is relevant. Matching saved keys are updated while optional reviewstatus and editornotes columns are left untouched. Setup 1. Install the verified HasData community node. Connect HasData credentials to Fetch search evidence and Read source pages, and Google Sheets credentials to Read input, Read Results and Save review queue. No OpenAI or other model account is required. 2. Create a Prompts tab with the header query and one question per row. Create a Results tab with these headers: resultkey, checkedat, topic, status, summary, citingprompts, competitorsobserved, brandevidence, sourceurl, evidencejson. You can add reviewstatus and editornotes for your own decisions. 3. In Settings, enter spreadsheetid and replace the example owndomain, brandaliases, competitornames and excludeddomains with your business and competitors. Use one entry per line for list settings. Add competitor-owned publications to excludeddomains when you identify them. 4. Start with one prompt and maxpages set to 2. Run manually and inspect the resulting source pages and matching excerpts. If page text is missing, adjust contentselector or enable jsrendering for sites that need it. Run only one execution at a time. Requirements - An n8n instance with the verified HasData community node installed. A HasData account with credits for Google AI Mode and Web Scraping requests. A Google account with read and write access to the selected spreadsheet. Customization - Use commercial research questions for your own category, such as best web scraping APIs for small teams, and configure your brand and competitor names to match. Adjust maxitems and maxpages within the supported 1-10 ranges. The default is five prompts and up to five source-page reads per run. Optional location and country settings can narrow the search context. Keep jsrendering disabled for readable HTML pages. Enable it only when needed; rendering can increase request costs. Export the results before refreshing if you need a historical archive. Additional info Designed for SEO and PR research, not automatic outreach. A citation does not prove endorsement, publisher independence or a brand mention. No m