{"product_id":"track-weekly-google-trends-rising-searches-to-sheets-with-n8n","title":"Track Weekly Google Trends \u0026 Rising Searches to Sheets with n8n","description":"\u003ch3\u003eTrack Google search momentum every week—automatically append it to Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls weekly Google Trends interest and \u003cstrong\u003erising searches\u003c\/strong\u003e for your chosen keywords using \u003cstrong\u003eApify’s Google Trends API\u003c\/strong\u003e, then \u003cstrong\u003ewrites one summarized row per keyword\u003c\/strong\u003e into Google Sheets—so you can monitor trend direction without manual research.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every Monday at 08:00\u003c\/strong\u003e via a scheduled trigger.\u003c\/li\u003e\n  \u003cli\u003eUses a configurable \u003cstrong\u003ekeyword list\u003c\/strong\u003e, \u003cstrong\u003elocation\u003c\/strong\u003e, and \u003cstrong\u003etimeRange\u003c\/strong\u003e to define what to query.\u003c\/li\u003e\n  \u003cli\u003eCalls \u003cstrong\u003eApify’s Google Trends API\u003c\/strong\u003e to retrieve metrics for each keyword, including interest values and related \u003cstrong\u003erising searches\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eTransforms the response into \u003cstrong\u003eone row per keyword\u003c\/strong\u003e, capturing:\n    \u003cul\u003e\n      \u003cli\u003eaverage and latest interest\u003c\/li\u003e\n      \u003cli\u003epeak date\u003c\/li\u003e\n      \u003cli\u003ea rising\/falling flag\u003c\/li\u003e\n      \u003cli\u003ethe top rising searches\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends the rows\u003c\/strong\u003e to a specified Google Sheets worksheet to build a weekly trend log.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonitor SEO and content opportunities by tracking weekly shifts in Google interest for target keywords.\u003c\/li\u003e\n  \u003cli\u003eSupport SaaS product marketing research: detect rising search themes tied to features, competitors, or topics.\u003c\/li\u003e\n  \u003cli\u003eCompetitive research: compare multiple keywords and see which ones are trending up each week.\u003c\/li\u003e\n  \u003cli\u003eSales\/ops planning: spot early demand signals for high-interest or newly rising queries.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e: runs weekly (Monday 08:00).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHTTP Request\u003c\/strong\u003e: calls \u003cstrong\u003eApify Google Trends API\u003c\/strong\u003e using \u003cstrong\u003eHTTP Bearer Auth\u003c\/strong\u003e with an Apify API token.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCode\u003c\/strong\u003e: reshapes the API response into rows per keyword and formats the rising searches summary.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: appends results to your selected spreadsheet (document ID) and worksheet (sheet name).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup\u003c\/strong\u003e includes configuring keywords, location, and timeRange in the Settings step.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eCost note:\u003c\/strong\u003e Apify pricing applies per use (e.g., about \u003cem\u003e$0.025 per comparison up to 5 keywords\u003c\/em\u003e plus \u003cem\u003e$0.03 per keyword for rising searches\u003c\/em\u003e).\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46105958940851,"sku":"N8N-19975","price":45.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Bjhtl9-HoqhVoRM2GI3RP_nMIbxBR9.png?v=1790499806","url":"https:\/\/buyflowscripts.com\/products\/track-weekly-google-trends-rising-searches-to-sheets-with-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}