{"product_id":"n8n-workflow-auto-write-weekly-gbp-posts-from-google-sheets","title":"n8n Workflow: Auto-Write Weekly GBP Posts from Google Sheets","description":"\u003ch3\u003eAuto-write compliant weekly GBP posts—directly from your Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically turns queued content in your Google Sheets into a Google Business Profile (GBP) post using Anthropic Claude—then emails staff a ready-to-paste draft or triggers a review alert if anything looks unsafe or non-compliant.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eRuns on a schedule:\u003c\/b\u003e executes every Monday at \u003cb\u003e9am\u003c\/b\u003e via a schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003ePulls the next queued item:\u003c\/b\u003e reads all rows from your Google Sheets \u003cb\u003eContent Queue\u003c\/b\u003e and selects the next row with a blank status or \u003cb\u003e“Queued”\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eHandles empty queues:\u003c\/b\u003e if no queued content exists, it emails staff that the posting queue is empty.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eGenerates a GBP post with Claude:\u003c\/b\u003e builds a prompt and calls the \u003cb\u003eAnthropic Claude API\u003c\/b\u003e to generate a marketing-safe GBP post in \u003cb\u003eJSON\u003c\/b\u003e format.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eValidates for safety and formatting:\u003c\/b\u003e parses and checks the response using:\n    \u003cul\u003e\n      \u003cli\u003ea self-reported safety flag,\u003c\/li\u003e\n      \u003cli\u003ean independent keyword scan,\u003c\/li\u003e\n      \u003cli\u003ea \u003cb\u003e1,500-character length\u003c\/b\u003e check for GBP.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eDraft vs. review workflow:\u003c\/b\u003e\n    \u003cul\u003e\n      \u003cli\u003eIf safe: updates the row to \u003cb\u003e“Drafted”\u003c\/b\u003e, logs via a separate compliance workflow, and emails staff the ready-to-paste post.\u003c\/li\u003e\n      \u003cli\u003eIf flagged: updates the row to \u003cb\u003e“Needs Review”\u003c\/b\u003e, logs the exception via a separate workflow, and emails staff the reason plus the original content.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWeekly content ops: staff queue topics in Google Sheets and receive GBP drafts automatically.\u003c\/li\u003e\n  \u003cli\u003eCompliance-first publishing: catch risky wording with Claude safety signals and keyword scanning before posting.\u003c\/li\u003e\n  \u003cli\u003eScalable GBP marketing: standardize post length and formatting while keeping a human review path.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n nodes: \u003cb\u003eschedule\u003c\/b\u003e, \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, \u003cb\u003ehttp request\u003c\/b\u003e, \u003cb\u003egoogle sheets\u003c\/b\u003e, and \u003cb\u003eemail send\u003c\/b\u003e (includes notification messaging).\u003c\/li\u003e\n  \u003cli\u003eIntegrations\/setup:\n    \u003cul\u003e\n      \u003cli\u003eConnect \u003cb\u003eGoogle Sheets OAuth\u003c\/b\u003e and set \u003cb\u003eGBP_CONTENT_QUEUE_SHEET_ID\u003c\/b\u003e to your Content Queue spreadsheet.\u003c\/li\u003e\n      \u003cli\u003eAdd \u003cb\u003eAnthropic API key\u003c\/b\u003e using \u003cb\u003ex-api-key\u003c\/b\u003e header auth for the Claude request.\u003c\/li\u003e\n      \u003cli\u003eConfigure \u003cb\u003eSMTP\u003c\/b\u003e for staff email notifications.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45869872021683,"sku":"N8N-18456","price":25.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/oYoTt2U_Rwfa0-cneyT1__qz71SP3s.png?v=1787130041","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-auto-write-weekly-gbp-posts-from-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}