{"product_id":"n8n-workflow-groq-blog-drafts-from-google-sheets-to-wordpress","title":"n8n Workflow: Groq Blog Drafts from Google Sheets to WordPress","description":"\u003ch3\u003eTurn Google Sheets blog ideas into Groq-written drafts, LinkedIn posts, and scheduled WordPress articles—with Slack approval\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically pulls queued blog topics from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, generates a full draft with \u003cstrong\u003eGroq (Llama 3.3)\u003c\/strong\u003e, creates a Google Doc for review, schedules a matching \u003cstrong\u003eLinkedIn\u003c\/strong\u003e post via \u003cstrong\u003eBuffer\u003c\/strong\u003e, and—after \u003cstrong\u003eSlack\u003c\/strong\u003e approval—publishes the post in \u003cstrong\u003eWordPress\u003c\/strong\u003e and updates the sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every Friday at 09:00\u003c\/strong\u003e and processes up to \u003cstrong\u003etwo\u003c\/strong\u003e queued topics per run.\u003c\/li\u003e\n  \u003cli\u003eReads the Google Sheets queue and keeps only rows where a \u003cstrong\u003eunique angle\u003c\/strong\u003e is filled in.\u003c\/li\u003e\n  \u003cli\u003eUses Groq to generate:\n    \u003cul\u003e\n      \u003cli\u003eAn \u003cstrong\u003eoutline\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003eA \u003cstrong\u003efull draft\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003ea \u003cstrong\u003ecritique + edit\u003c\/strong\u003e pass to produce the final \u003cstrong\u003emarkdown\u003c\/strong\u003e article\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eCalculates publish timing for \u003cstrong\u003enext Monday or Thursday at 08:00\u003c\/strong\u003e, then generates SEO metadata (title, description, slug, excerpt) with Groq and validates the SEO JSON.\u003c\/li\u003e\n  \u003cli\u003eConverts markdown into a document, uploads it to \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e as a \u003cstrong\u003eGoogle Doc\u003c\/strong\u003e, and creates\/schedules a \u003cstrong\u003eLinkedIn\u003c\/strong\u003e post via \u003cstrong\u003eBuffer\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSends a \u003cstrong\u003eSlack approval request\u003c\/strong\u003e including the publish date and Google Doc link; on approval, exports the Google Doc to \u003cstrong\u003eHTML\u003c\/strong\u003e and creates a \u003cstrong\u003escheduled WordPress\u003c\/strong\u003e post.\u003c\/li\u003e\n  \u003cli\u003eUpdates the Google Sheets row to mark the item as \u003cstrong\u003escheduled\u003c\/strong\u003e and stores the \u003cstrong\u003eWordPress post ID\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS teams that plan weekly content in Google Sheets and want consistent drafts + SEO metadata.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers coordinating multi-step publishing with human review via Slack.\u003c\/li\u003e\n  \u003cli\u003eOperations workflows that publish on a set cadence (Mon\/Thu 08:00) with LinkedIn scheduling support.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n schedule trigger: \u003cstrong\u003eFridays at 09:00\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eNodes\/stack: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eSlack\u003c\/strong\u003e, \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, and \u003cstrong\u003eHTTP Request\u003c\/strong\u003e (for \u003cstrong\u003eGroq\u003c\/strong\u003e and other API calls)\u003c\/li\u003e\n  \u003cli\u003eIntegrations: \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eGroq (Llama 3.3)\u003c\/strong\u003e, \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e (Google Doc export), \u003cstrong\u003eSlack\u003c\/strong\u003e, \u003cstrong\u003eBuffer\u003c\/strong\u003e, and \u003cstrong\u003eWordPress\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45761005519027,"sku":"N8N-17828","price":9.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/GN0L_-QHfIBN6Zn3vSGNs_pPoYM3Cy.png?v=1785921012","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-groq-blog-drafts-from-google-sheets-to-wordpress","provider":"N8N Commerce","version":"1.0","type":"link"}