n8n Workflow: Auto-Write Weekly GBP Posts from Google Sheets

Auto-write compliant weekly GBP posts—directly from your Google Sheets

This 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.

What this workflow does

• Runs on a schedule: executes every Monday at 9am via a schedule trigger.
• Pulls the next queued item: reads all rows from your Google Sheets Content Queue and selects the next row with a blank status or “Queued”.
• Handles empty queues: if no queued content exists, it emails staff that the posting queue is empty.
• Generates a GBP post with Claude: builds a prompt and calls the Anthropic Claude API to generate a marketing-safe GBP post in JSON format.
• Validates for safety and formatting: parses and checks the response using:
  • a self-reported safety flag,
  • an independent keyword scan,
  • a 1,500-character length check for GBP.
• Draft vs. review workflow:
  • If safe: updates the row to “Drafted”, logs via a separate compliance workflow, and emails staff the ready-to-paste post.
  • If flagged: updates the row to “Needs Review”, logs the exception via a separate workflow, and emails staff the reason plus the original content.

Use cases

• Weekly content ops: staff queue topics in Google Sheets and receive GBP drafts automatically.
• Compliance-first publishing: catch risky wording with Claude safety signals and keyword scanning before posting.
• Scalable GBP marketing: standardize post length and formatting while keeping a human review path.

Technical details

• n8n nodes: schedule, if, code, http request, google sheets, and email send (includes notification messaging).
• Integrations/setup:
  • Connect Google Sheets OAuth and set GBP_CONTENT_QUEUE_SHEET_ID to your Content Queue spreadsheet.
  • Add Anthropic API key using x-api-key header auth for the Claude request.
  • Configure SMTP for staff email notifications.