{"product_id":"weekly-google-business-profile-post-drafts-claude-sheets","title":"Weekly Google Business Profile Post Drafts (Claude + Sheets)","description":"\u003ch3\u003eTurn Google Business Profile ideas into ready-to-paste post drafts every week—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls queued post ideas from your Google Sheets, generates a Google Business Profile draft using Anthropic Claude, validates it for safety and the GBP character limit, then emails staff a polished draft (or flags items for review).\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e Executes every Monday at \u003cstrong\u003e9am\u003c\/strong\u003e (server timezone).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your queue:\u003c\/strong\u003e Loads rows from the Google Sheets \u003cstrong\u003e“Content Queue”\u003c\/strong\u003e tab and selects the first row where \u003cstrong\u003estatus\u003c\/strong\u003e is blank or \u003cstrong\u003eQueued\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles empty queues:\u003c\/strong\u003e If nothing is queued, it emails staff an alert that the queue is empty.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a GBP post draft:\u003c\/strong\u003e Builds a prompt from the row content and variables, calls the \u003cstrong\u003eAnthropic Claude Messages API\u003c\/strong\u003e, and expects JSON output for the proposed Google Business Profile post.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSafety + compliance safeguards:\u003c\/strong\u003e Parses Claude’s response, runs a second \u003cstrong\u003ekeyword-based safety scan\u003c\/strong\u003e, and enforces Google Business Profile’s \u003cstrong\u003e1,500-character limit\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates status and logs outcomes:\u003c\/strong\u003e\n    \u003cul\u003e\n      \u003cli\u003eIf safe: updates the row to \u003cstrong\u003eDrafted\u003c\/strong\u003e, calls a separate n8n compliance workflow for logging, and emails staff the ready-to-paste draft.\u003c\/li\u003e\n      \u003cli\u003eIf not safe: updates the row to \u003cstrong\u003eNeeds Review\u003c\/strong\u003e, calls the compliance workflow, and emails staff the \u003cstrong\u003eflag reason\u003c\/strong\u003e 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 GBP content production from a centralized \u003cstrong\u003eGoogle Sheets queue\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eTeams that want \u003cstrong\u003ehuman review\u003c\/strong\u003e when content fails keyword checks.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators using n8n to streamline approval workflows and \u003cstrong\u003eaudit logging\u003c\/strong\u003e through a compliance workflow.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes:\u003c\/strong\u003e if, code, email send, sticky note, http request, and Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets (OAuth2) + \u003cstrong\u003eAnthropic Claude Messages API\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfiguration:\u003c\/strong\u003e Set \u003cstrong\u003eGBP_CONTENT_QUEUE_SHEET_ID\u003c\/strong\u003e; ensure your sheet includes a \u003cstrong\u003eContent Queue\u003c\/strong\u003e tab with a \u003cstrong\u003estatus\u003c\/strong\u003e column (and content fields used to form the prompt).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45869896990899,"sku":"N8N-18419","price":51.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/fE8YYog529ZrPLBZdzkhz_M2aYCQuk.png?v=1787130950","url":"https:\/\/buyflowscripts.com\/products\/weekly-google-business-profile-post-drafts-claude-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}