{"product_id":"n8n-google-sheets-openai-blog-generator-workflow-html-docs","title":"n8n Google Sheets + OpenAI Blog Generator Workflow (HTML → Docs)","description":"\u003ch3\u003eGenerate SEO blog topics and publish-ready HTML articles to Google Docs—directly from your Google Sheets, using OpenAI (GPT-4o) and Anthropic (Claude 4 Sonnet).\u003c\/h3\u003e\n\n\u003cp\u003eThis n8n workflow connects \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eOpenAI\u003c\/strong\u003e, and \u003cstrong\u003eAnthropic\u003c\/strong\u003e to turn client keywords and instructions into structured content topics for human QC, then converts approved topics into \u003cstrong\u003e1500+ word SEO blog posts\u003c\/strong\u003e in \u003cstrong\u003eplain HTML\u003c\/strong\u003e that are automatically created as \u003cstrong\u003eGoogle Docs\u003c\/strong\u003e and linked back to the sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers\u003c\/strong\u003e when a client row changes in Google Sheets or on a monthly schedule to start processing clients from the \u003cem\u003eClient Details\u003c\/em\u003e sheet.\u003c\/li\u003e\n  \u003cli\u003eFor each client, uses \u003cstrong\u003eOpenAI (GPT-4o)\u003c\/strong\u003e to generate a batch of blog title ideas using the client’s keywords, homepage content, competitor URLs, and project instructions.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eOpenAI (GPT-4o)\u003c\/strong\u003e again to review, rewrite, and standardize the title list, then parses results into a structured topic array.\u003c\/li\u003e\n  \u003cli\u003eWrites each topic as a row into the \u003cem\u003eContent Topics\u003c\/em\u003e tab with the associated \u003cstrong\u003eClient ID\u003c\/strong\u003e for human QC.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily\u003c\/strong\u003e to find \u003cem\u003eContent Topics\u003c\/em\u003e rows marked \u003cstrong\u003eQC = Good\u003c\/strong\u003e that don’t yet have a \u003cstrong\u003eContent URL\u003c\/strong\u003e, then processes topics one by one.\u003c\/li\u003e\n  \u003cli\u003eLoads the matching client details from Google Sheets and uses \u003cstrong\u003eAnthropic (Claude 4 Sonnet)\u003c\/strong\u003e to generate a \u003cstrong\u003e1500+ word\u003c\/strong\u003e SEO article in \u003cstrong\u003eplain HTML\u003c\/strong\u003e, including the extracted \u003cstrong\u003eH1\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSends the HTML + H1 title to a \u003cstrong\u003eGoogle Apps Script web app\u003c\/strong\u003e to create a \u003cstrong\u003eGoogle Doc\u003c\/strong\u003e, then updates the \u003cem\u003eContent Topics\u003c\/em\u003e row with the returned document URL.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams who manage multiple clients in Google Sheets and want an automated \u003cstrong\u003eSEO blog production pipeline\u003c\/strong\u003e with human approval gates.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building content workflows that create \u003cstrong\u003eGoogle Docs\u003c\/strong\u003e from AI-generated \u003cstrong\u003eHTML\u003c\/strong\u003e and track progress in-sheet.\u003c\/li\u003e\n  \u003cli\u003eMarketing operations that need consistent topic generation, QC, and publishing links per Client ID.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets, OpenAI (GPT-4o), Anthropic (Claude 4 Sonnet), Google Apps Script (web app).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n flow elements:\u003c\/strong\u003e code, sticky note, HTTP Request, Google Sheets, split in batches, and \u003cem\u003en8n-nodes-langchainagent\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup:\u003c\/strong\u003e add credentials for Google Sheets, OpenAI, and Anthropic in n8n; replace placeholders like \u003cem\u003eYOUR_GOOGLE_SHEET_ID\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45938169610419,"sku":"N8N-19047","price":28.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/C_e1DMnc6vIwsg7H3McY1_FOm5Gcoz.png?v=1788339864","url":"https:\/\/buyflowscripts.com\/products\/n8n-google-sheets-openai-blog-generator-workflow-html-docs","provider":"N8N Commerce","version":"1.0","type":"link"}