{"product_id":"weekly-google-trends-keyword-tracker-with-apify-sheets-n8n","title":"Weekly Google Trends Keyword Tracker with Apify \u0026 Sheets (n8n)","description":"\u003ch3\u003eWeekly Google Trends keyword insights in Google Sheets—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every Monday and pulls weekly Google Trends data for your chosen keywords via \u003cstrong\u003eApify\u003c\/strong\u003e, then summarizes the key metrics and \u003cstrong\u003eappends one row per keyword\u003c\/strong\u003e to your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e spreadsheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled run:\u003c\/strong\u003e Uses an n8n \u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e to run every Monday at \u003cstrong\u003e8am\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetch Google Trends data with Apify:\u003c\/strong\u003e Calls \u003cstrong\u003eApify’s Google Keyword Trends actor\u003c\/strong\u003e using the keyword list and parameters you provide (including \u003cem\u003elocation\u003c\/em\u003e, \u003cem\u003etime range\u003c\/em\u003e, \u003cem\u003ecategory\u003c\/em\u003e, and \u003cem\u003esearch type\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSummarize results per keyword:\u003c\/strong\u003e Transforms the dataset into \u003cstrong\u003eone summary row per keyword\u003c\/strong\u003e, including:\n    \u003cul\u003e\n      \u003cli\u003erun date\u003c\/li\u003e\n      \u003cli\u003einterest average\u003c\/li\u003e\n      \u003cli\u003etop queries\u003c\/li\u003e\n      \u003cli\u003ebreakout rising queries\u003c\/li\u003e\n      \u003cli\u003e(plus relevant configured fields such as location\/window as available)\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppend to Google Sheets:\u003c\/strong\u003e Writes the summarized rows into your selected worksheet by adding \u003cstrong\u003enew rows\u003c\/strong\u003e with auto-mapping based on matching column names.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSEO and content planning:\u003c\/strong\u003e Track weekly interest and rising search terms for target keywords and share updates with your team in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS marketing operations:\u003c\/strong\u003e Monitor demand signals by location and category over time, then use the sheet as your reporting source of truth.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers:\u003c\/strong\u003e Deploy a repeatable “trends-to-spreadsheet” workflow for keyword research pipelines.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e \u003cem\u003eSchedule Trigger\u003c\/em\u003e, \u003cem\u003eApify\u003c\/em\u003e (via \u003cstrong\u003eapifyn8n-nodes-apify\u003c\/strong\u003e), \u003cem\u003eCode\u003c\/em\u003e, and a \u003cem\u003eGoogle Sheets\u003c\/em\u003e append step.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify setup:\u003c\/strong\u003e Provide an \u003cstrong\u003eApify API token\u003c\/strong\u003e plus the actor input JSON (keywords + location\/time range\/category\/search type).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets setup:\u003c\/strong\u003e Ensure your sheet has matching columns (e.g., \u003cstrong\u003erun_date\u003c\/strong\u003e, \u003cstrong\u003ekeyword\u003c\/strong\u003e, \u003cstrong\u003elocation\u003c\/strong\u003e, \u003cstrong\u003ewindow\u003c\/strong\u003e, \u003cstrong\u003eresolution\u003c\/strong\u003e, \u003cstrong\u003einterest_average\u003c\/strong\u003e, \u003cstrong\u003etop_queries\u003c\/strong\u003e, \u003cstrong\u003ebreakout_rising_queries\u003c\/strong\u003e) so data appends correctly.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45812011991219,"sku":"N8N-17961","price":59.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/R4OrVS5BQmx913YIV_ln2_4pmlAgGM.png?v=1786353042","url":"https:\/\/buyflowscripts.com\/products\/weekly-google-trends-keyword-tracker-with-apify-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}