Weekly Google Business Profile Post Drafts (Claude + Sheets)

Turn Google Business Profile ideas into ready-to-paste post drafts every week—automatically

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

What this workflow does

• Runs on a schedule: Executes every Monday at 9am (server timezone).
• Reads your queue: Loads rows from the Google Sheets “Content Queue” tab and selects the first row where status is blank or Queued.
• Handles empty queues: If nothing is queued, it emails staff an alert that the queue is empty.
• Generates a GBP post draft: Builds a prompt from the row content and variables, calls the Anthropic Claude Messages API, and expects JSON output for the proposed Google Business Profile post.
• Safety + compliance safeguards: Parses Claude’s response, runs a second keyword-based safety scan, and enforces Google Business Profile’s 1,500-character limit.
• Updates status and logs outcomes:
  • If safe: updates the row to Drafted, calls a separate n8n compliance workflow for logging, and emails staff the ready-to-paste draft.
  • If not safe: updates the row to Needs Review, calls the compliance workflow, and emails staff the flag reason plus the original content.

Use cases

• Weekly GBP content production from a centralized Google Sheets queue.
• Teams that want human review when content fails keyword checks.
• SaaS operators using n8n to streamline approval workflows and audit logging through a compliance workflow.

Technical details

• n8n nodes: if, code, email send, sticky note, http request, and Google Sheets.
• Integrations: Google Sheets (OAuth2) + Anthropic Claude Messages API.
• Configuration: Set GBP_CONTENT_QUEUE_SHEET_ID; ensure your sheet includes a Content Queue tab with a status column (and content fields used to form the prompt).