{"product_id":"apify-n8n-weekly-google-news-brand-mentions-to-google-sheets","title":"Apify + n8n: Weekly Google News Brand Mentions to Google Sheets","description":"\u003ch3\u003eGet a weekly stream of Google News mentions in Google Sheets—no PR retainer or media monitoring subscription\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically searches Google News every week for the brands and topics you choose, then appends one row per article to Google Sheets—complete with headline, source, publication date, snippet, and a link.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly:\u003c\/strong\u003e Scheduled for every Monday at \u003cstrong\u003e8:00 AM\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDefines watch terms:\u003c\/strong\u003e Uses your configured brands\/topics plus a \u003cstrong\u003etarget country and language\u003c\/strong\u003e for Google News coverage.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePerforms one search per watch term:\u003c\/strong\u003e For each watch term, it runs a Google News search via the Apify actor \u003cstrong\u003ejohnvc~GoogleNewsAPI\u003c\/strong\u003e (one search = one set of results).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSkips empty results:\u003c\/strong\u003e If a watch term returns no articles, that term is skipped.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFormats results into rows:\u003c\/strong\u003e For each article, it generates rows including \u003cem\u003eweek\u003c\/em\u003e, \u003cem\u003ewatch term\u003c\/em\u003e, \u003cem\u003erank\u003c\/em\u003e, \u003cem\u003eheadline\u003c\/em\u003e, \u003cem\u003esource\u003c\/em\u003e, \u003cem\u003epublished text\u003c\/em\u003e, \u003cem\u003esnippet\u003c\/em\u003e, and \u003cem\u003elink\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends to Google Sheets:\u003c\/strong\u003e Adds the generated rows to your selected spreadsheet and worksheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack \u003cstrong\u003eweekly brand mentions\u003c\/strong\u003e for a marketing or PR team without expensive subscriptions.\u003c\/li\u003e\n  \u003cli\u003eMonitor competitors and industry topics in a specific \u003cstrong\u003ecountry\/language\u003c\/strong\u003e for SaaS go-to-market reporting.\u003c\/li\u003e\n  \u003cli\u003eBuild an always-updating \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e newsroom for founder-led updates or investor decks.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration:\u003c\/strong\u003e Requires an Apify API token credential and access to \u003cstrong\u003ejohnvc~GoogleNewsAPI\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration:\u003c\/strong\u003e Uses Google OAuth to append rows to the chosen spreadsheet\/worksheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used:\u003c\/strong\u003e set, code, filter, split out, sticky note, and a Google Sheets append step.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCustomization:\u003c\/strong\u003e Add\/remove watch terms in the config node; each term becomes its own Google News search and produces its own article rows.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eNote: This workflow includes no AI model and no media monitoring subscription—results come directly from Google News via Apify.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45785692471475,"sku":"N8N-17906","price":33.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/98Y5IDTSPBD0qQUm0cktN_7Yr5jZ0R.png?v=1786180298","url":"https:\/\/buyflowscripts.com\/products\/apify-n8n-weekly-google-news-brand-mentions-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}