{"product_id":"n8n-workflow-find-competitor-citing-publishers-hasdata-google-sheets","title":"n8n Workflow: Find Competitor-Citing Publishers (HasData + Google Sheets)","description":"\u003ch3\u003eFind competitor-citing publishers automatically—using HasData (AI Mode) + Google Sheets in n8n\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n Workflow: Find Competitor-Citing Publishers (HasData + Google Sheets)\u003c\/strong\u003e manually pulls Google AI Mode citation sources from \u003cstrong\u003eHasData\u003c\/strong\u003e, scrapes the most relevant cited pages, detects \u003cstrong\u003ecompetitor\u003c\/strong\u003e and \u003cstrong\u003ebrand\u003c\/strong\u003e mentions, and writes an evidence-ready review queue back to your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns manually\u003c\/strong\u003e and loads configuration including your \u003cstrong\u003eGoogle Sheets spreadsheet ID\u003c\/strong\u003e, \u003cstrong\u003ebrand aliases\u003c\/strong\u003e, \u003cstrong\u003ecompetitor names\u003c\/strong\u003e, excluded domains, and sampling limits.\u003c\/li\u003e\n  \u003cli\u003eReads prompt queries from the \u003cstrong\u003ePrompts\u003c\/strong\u003e tab, validating batch size and required headers.\u003c\/li\u003e\n  \u003cli\u003eChecks existing entries in the \u003cstrong\u003eResults\u003c\/strong\u003e tab to prevent duplicate result keys and inconsistent updates.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eHasData Google SERP AI Mode\u003c\/strong\u003e to fetch citation references for each prompt, then normalizes cited URLs.\u003c\/li\u003e\n  \u003cli\u003eAggregates and prioritizes cited source URLs across prompts, excludes your own domain and other blocked domains, and selects up to the configured number of pages to scrape.\u003c\/li\u003e\n  \u003cli\u003eCalls the \u003cstrong\u003eHasData web scraping\u003c\/strong\u003e endpoint for each selected page to extract main content, titles, headings, and links.\u003c\/li\u003e\n  \u003cli\u003eSearches the scraped text for \u003cstrong\u003ebrand\u003c\/strong\u003e and \u003cstrong\u003ecompetitor\u003c\/strong\u003e mentions, then appends or updates rows in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e with status, prompt citations, competitor excerpts, brand evidence, and the full evidence JSON for review.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCompetitive backlink\/reputation research by identifying \u003cem\u003epublishers that cite competitors\u003c\/em\u003e in Google AI Mode.\u003c\/li\u003e\n  \u003cli\u003eContent and PR teams building a review queue with on-page evidence for outreach decisions.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators validating whether competitor narratives or brand mentions appear in cited sources.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDesigned for n8n automations with nodes such as \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ehttp request\u003c\/strong\u003e, \u003cstrong\u003ehtml\u003c\/strong\u003e, and `sticky note`.\u003c\/li\u003e\n  \u003cli\u003eRequires the \u003cstrong\u003eHasData community node\u003c\/strong\u003e with API credentials for both the \u003cstrong\u003eHasData SERP (AI Mode)\u003c\/strong\u003e request and the \u003cstrong\u003eHasData web scraping\u003c\/strong\u003e endpoint.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46153927229619,"sku":"N8N-20329","price":43.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Ab-yS0XI4r0HRdAxoghdw_a2jhjZ7M.png?v=1790931651","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-find-competitor-citing-publishers-hasdata-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}