{"product_id":"weekly-seo-content-plan-apify-openai-google-sheets-n8n","title":"Weekly SEO Content Plan: Apify + OpenAI + Google Sheets (n8n)","description":"\u003ch3\u003eTurn Google Trends into a weekly SEO content calendar—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every Monday (or on demand) to pull rising Google Trends searches and related Google News via Apify, generates structured SEO content ideas with OpenAI, appends them to your Google Sheets calendar, and emails you a ranked digest via Gmail.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eSchedules or triggers:\u003c\/b\u003e Executes weekly at \u003cb\u003e8:00 every Monday\u003c\/b\u003e, or you can run it anytime by submitting the \u003cb\u003en8n form\u003c\/b\u003e with topics, a country, and an optional email recipient.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFetches rising queries:\u003c\/b\u003e Uses \u003cb\u003eApify’s Google Trends API\u003c\/b\u003e to retrieve related rising searches for your topics, filters irrelevant breakouts, and \u003cb\u003eskips searches already used\u003c\/b\u003e in previous executions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSelects this week’s best targets:\u003c\/b\u003e Chooses a balanced set across topics and stops early if there are \u003cb\u003eno new trends\u003c\/b\u003e to cover.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eScrapes supporting news:\u003c\/b\u003e Calls \u003cb\u003eApify’s Google News Scraper\u003c\/b\u003e for each selected search and computes a \u003cb\u003epriority score\u003c\/b\u003e based on growth, press coverage, and topic momentum.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eBriefs OpenAI for structured outputs:\u003c\/b\u003e Sends a \u003cb\u003efact-only brief\u003c\/b\u003e to \u003cb\u003eOpenAI (gpt-5-mini)\u003c\/b\u003e and parses the structured response into one content idea per search (title, format, target search, why now, plus a 3-point outline).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003ePublishes to your system:\u003c\/b\u003e Appends ranked ideas, sources, and tracking fields to \u003cb\u003eGoogle Sheets\u003c\/b\u003e, then emails an \u003cb\u003eHTML digest\u003c\/b\u003e via Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS SEO teams that need consistent weekly content planning tied to \u003cb\u003erising Google Trends\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building an end-to-end \u003cb\u003eSEO content pipeline\u003c\/b\u003e with Apify + OpenAI + Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eOperators who want a prioritized, source-backed weekly digest sent straight to their inbox.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eApify\u003c\/b\u003e HTTP requests with \u003cb\u003eBearer Auth\u003c\/b\u003e using your Apify API token (used for both Trends API and Google News Scraper).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eOpenAI\u003c\/b\u003e Chat Model using \u003cb\u003egpt-5-mini\u003c\/b\u003e and structured response parsing.\u003c\/li\u003e\n  \u003cli\u003en8n nodes\/logic including: \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, \u003cb\u003eno op\u003c\/b\u003e, \u003cb\u003egmail\u003c\/b\u003e, \u003cb\u003esplit out\u003c\/b\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46217909928115,"sku":"N8N-20847","price":3.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/4d1Bf2OVsJ9qIuFJavuFc_3JGJmaXS.png?v=1791882595","url":"https:\/\/buyflowscripts.com\/products\/weekly-seo-content-plan-apify-openai-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}