Automate Google Business Profile posts with GPT-4 & Google Sheets

Name: Automate Google Business Profile posts with GPT-4 & Google Sheets
Availability: InStock
Rating: 4.5 (38 reviews)
Author: Muhammad Qaisar Mehmood

$20/month : Unlimited workflows

2500 executions/month

Try free

THE #1 IN WEB SCRAPING

Scrape any website without limits

Try free

HOSTINGER 🎉 Early Black Friday Deal
DISCOUNT 20%

Self-hosted n8n

Unlimited workflows - from $4.99/mo

Try free

#1 hub for scraping, AI & automation

6000+ actors - $5 credits/mo

Try free

This powerful n8n workflow automatically generates and publishes Google Business Profile (GMB) posts using topics listed in a Google Sheet.
It uses OpenAI to write SEO-optimized post descriptions and generate AI images based on the topic — then posts them directly to your GMB profile and marks them as published in the sheet.

🎯 Use Case

Perfect for:

Digital marketers managing local SEO
Agencies automating content for clients
Businesses regularly posting to GMB
Teams managing editorial calendars via Google Sheets

⚙️ Workflow Overview

🧩 Node	🔧 Purpose
🕘 Schedule Trigger	Runs daily at 9AM (configurable)
📄 Get Unpublished Row	Reads a row from Google Sheet where Status is not marked "Published"
✍️ Generate Post Text	Uses OpenAI (GPT-4) to write a compelling, local-business optimized post
🖼 Generate Post Image	Uses DALL·E or similar to create an image matching the topic
📬 Post to GMB	Publishes the generated content to your Google Business Profile
✅ Update Sheet	Marks the status as "Published" in the Google Sheet

📄 Google Sheet Format

Column Name	Description
Topic	The subject or idea for the GMB post
Status	Should be blank or "Unpublished" to trigger the flow
Date	(Optional) Posting schedule or note
Notes	(Optional) Internal info — not used in the automation

🔐 Google My Business API Setup

1. Google Cloud Configuration

Go to Google Cloud Console
Enable the Google My Business API
Create OAuth2 Client ID and Client Secret
Add this required scope:

2. Request for GMB Quota

You need to request for GMB (Google Business Profile) API Quota from here, beacuse by deafult it sets to zero: https://support.google.com/business/contact/api_default

3. n8n Credential Setup

In n8n, go to Credentials > Google OAuth2
Use your Client ID and Client Secret
Use this credential in GMB-related nodes

🧠 OpenAI Prompt Customization

Modify the prompt in the OpenAI node to match your brand’s voice:

Example Prompt

Write a short, engaging Google Business Post about: "{{ $json.topic }}".  
Make it suitable for a local audience and include a subtle call to action.

🧪 Optional Enhancements

Add If node to delay publishing on certain days
Use Slack or Email notifications to alert before/after posting
Use Multiple Businesses by adding a Router or Switch node per GMB account

✅ Benefits

🔁 Fully automated GMB posting
✍️ SEO-optimized, AI-written content
🖼 Matching images for visual engagement
📊 Maintains a content log via Google Sheets
🧠 Easily customizable prompt logic and schedule

Muhammad Qaisar Mehmood

0 workflows

Nodes

set gmail telegram agent google-gemini

Complexity

intermediate

Published 19 Jul 2025

Likes 0

View on n8n.io Download Workflow

✨

Share Your Workflow

Have a great workflow to share? Join the n8n Creator Hub and help the community!

Submit Your Template How to Submit

Related Workflows

Create and schedule LinkedIn posts from Google Sheets with Gemini and DALL·E

## Overview This n8n automation is a complete LinkedIn Content Engine that turns simple topic ideas into fully written, visual, and scheduled posts. It features a "Human-in-the-Loop" design, meaning AI handles the heavy lifting of writing and image creation, but nothing goes live until you manually approve it in Google Sheets. ## How It Works The system runs two separate workflows in parallel: ### 1. The "Creator" Workflow **Input:** Detects when you add a new topic to your "Content Calendar" Google Sheet. **Brand Alignment:** Pulls your specific "Brand Voice" guidelines from a separate tab to ensure the AI sounds like you. **Creation:** Uses Gemini Flash 1.5 to write the post and DALL-E 3 to generate a matching professional image. **Drafting:** Uploads the image to ImgBB and saves the full draft back to your sheet with a status of "Draft." ### 2. The "Publisher" Workflow **Daily Scan:** Wakes up every morning to check your Content Calendar. **Verification:** Looks for posts that match two criteria: * Date Scheduled matches today's date. * Status is marked as "Approved" (by you). **Publishing:** If both match, it automatically uploads the text and image to LinkedIn and updates the sheet status to "Posted." **Tools Used:** n8n, Google Sheets, OpenRouter (Gemini / OpenAI), ImgBB. ## Connect & Learn More **YouTube Channel:** **[Simon Scrapes](https://www.youtube.com/@simonscrapes)** – More tutorials on AI & Automation. **Community:** **[Skool Community](https://www.skool.com/scrapes/about)** – Master AI & Automation with us. **Full Video Tutorial:** [Watch the step-by-step build here](https://youtu.be/eiIRSUhPgOI?si=lgZTrPZPMqWF4uqz&t=4276)

View

Curate and post AI news to X, Bluesky, Threads and more with GPT-5 mini and Cue

# Curate & post AI news to X, Bluesky, Threads & more via GPT-5 mini & Cue This n8n template automatically curates AI news from RSS feeds and generates platform-tailored social media posts using GPT-5 mini. Posts are saved as drafts in Cue for review before publishing to X, Bluesky, Threads, Mastodon, and Facebook. Use cases include: * Daily automated AI/tech news curation * Multi-platform social media content creation * Building thought leadership with consistent posting * Staying on top of industry news without manual effort ## Who is this for? This workflow is ideal for: * Tech content creators who want to share AI news across multiple platforms * Social media managers handling multiple accounts * Anyone building an audience around AI/tech topics * Teams who want consistent daily content without manual curation ## What problem does this workflow solve? Manually curating news, writing platform-specific posts, and publishing across 5 different social networks is time-consuming. This workflow automates the entire process: * **Curation** - Pulls from 4 trusted AI/tech RSS feeds daily * **Deduplication** - Tracks posted articles in Google Sheets so you never share the same story twice * **Content creation** - GPT-5 mini writes posts tailored to each platform's style and character limits * **Review workflow** - Creates drafts in Cue so you can review before publishing ## How it works 1. **Schedule Trigger** - Runs daily at 9am (configurable) 2. **RSS Feeds** - Fetches articles from TechCrunch AI, Ars Technica AI, The Verge AI, and MIT Tech Review 3. **Filter & Merge** - Combines all feeds and filters to articles from the last 7 days 4. **Deduplication** - Compares against Google Sheets to find unposted articles 5. **Random Selection** - Picks one random article from available stories 6. **AI Generation** - GPT-5 mini generates 5 platform-specific posts with appropriate tone and length 7. **Save to Cue** - Creates a draft post with all 5 platform variations 8. **Log to Sheet** - Records the article URL to prevent future duplicates ## Setup ### Requirements * [Cue account](https://oncue.so) with connected social accounts * OpenAI API key * Google account for Sheets ### Step 1: Install the Cue community node 1. Go to **Settings** → **Community Nodes** 2. Click **Install** 3. Enter `@cuehq/n8n-nodes-cue` ### Step 2: Create tracking spreadsheet 1. Create a new Google Sheet named "AI News Tracker" 2. Add these column headers in row 1: * `article_url` * `title` * `source` * `processed_at` ### Step 3: Configure credentials 1. **Google Sheets** - Add OAuth2 credentials and connect to the "Get Recent Posts" node 2. **OpenAI** - Add your API key and connect to the "GPT-5 mini" node 3. **Cue** - Add your API key from [Cue Settings](https://app.oncue.so/settings/api) ### Step 4: Configure the Cue node 1. Open the **Create Draft in Cue** node 2. Select your **Profile** 3. For each platform slot, select your social account: * Slot 1 → X/Twitter * Slot 2 → Bluesky * Slot 3 → Threads * Slot 4 → Mastodon * Slot 5 → Facebook Don't have all 5 platforms? Simply delete the unused slots. ### Step 5: Publish Save and click **Publish** to activate the workflow. ## Customizing this workflow ### Change the schedule Edit the **Daily 9am Trigger** node to run at a different time or frequency. ### Use different RSS feeds Replace the feed URLs with sources relevant to your niche. The workflow handles any standard RSS feed. Keep 3-6 feeds for best results. ### Auto-publish instead of drafts To publish immediately instead of creating drafts, enable **Publish Immediately** in the Cue node settings. ### Adjust the AI tone Modify the system prompt in the **Write Social Posts** node to match your brand voice or adjust platform-specific guidelines. ## Good to know * **Cost** - Each run uses one OpenAI API call. With GPT-5 mini, this costs approximately $0.01-0.02 per execution. * **Draft review** - Posts are created as drafts in Cue, giving you a chance to review and edit before publishing. * **Deduplication** - The Google Sheet tracks all posted URLs, so the same article is never shared twice. ## About Cue [Cue](https://oncue.so) is a social media scheduling platform that lets you manage and publish content across X, Bluesky, Threads, Mastodon, Facebook, LinkedIn, TikTok, and Instagram from a single dashboard. Key features: * **Multi-platform publishing** - Schedule once, publish everywhere * **Platform-specific content** - Tailor each post for different audiences * **Draft workflow** - Review and edit before publishing * **API & integrations** - Connect with n8n, Zapier, Make, and custom apps [Get started free](https://oncue.so) · [Documentation](https://docs.oncue.so) · [n8n Community Node](https://www.npmjs.com/package/@cuehq/n8n-nodes-cue)

View

Create and post social media image captions with GPT-4.1-mini and Google Sheets

# Social Media Posting Automation with Image and Caption ## How it works This AI-powered workflow streamlines your social media posting process, transforming hours of manual caption writing, image uploading, and scheduling into a fully automated system. You define the topic and image once, and the workflow handles caption generation, review, approval, and posting to your selected platforms. ### Automated Flow 1. **Generate Caption** Trigger the workflow manually and set your post topic and image URL in the Set node. The AI (GPT-4.1-mini) generates a high-quality, engaging social media caption tailored to your audience, platform, and content goals. 2. **Store in Google Sheet** The generated caption, along with your image URL and post metadata, is automatically appended to your Google Sheet. This creates a central location to review and manage all your social media content. 3. **Review and Approve** You review the generated caption in the sheet, make any edits if needed, and update the status to **Approved**. You can also select the platform(s) where you want to post. 4. **Automatic Posting** Once the status is updated to Approved, the next workflow is triggered automatically. It posts your caption and image to the selected social media platform(s) without any further manual effort. **The result?** A seamless, end-to-end social media posting process where captions are AI-generated, stored, reviewed, and posted automatically. Focus on strategy and engagement instead of repetitive manual posting. --- ## Setup Steps **Setup time:** ~10–15 minutes **What you’ll need:** OpenAI API key, Google account, access to your social media platform(s) 1. **Connect Your Google Account** - Click on the Google Sheets node in your workflow. - Select the Credential dropdown and choose **+ Create New Credential**. - Authenticate your Google account and grant the necessary permissions. 2. **Initialize Your Spreadsheet** - Run the workflow once by clicking the play button on the start node. - This will automatically create a Google Sheet with all the required columns for caption tracking and approval. 3. **Add Your OpenAI API Key** - Navigate to the AI Agent node. - Click the Credential dropdown and select **+ Create New Credential**. - Paste your OpenAI API key and save. - Get your API key from [platform.openai.com/api-keys](https://platform.openai.com/api-keys). 4. **Set Post Topic and Image** - Update the title in the Set node with the topic you want to post. - Add the image URL associated with your post. 5. **Review Captions and Approve** - Open your Google Sheet, review the generated captions, and update the status to **Approved**. - Select the platform(s) where the post should go live. 6. **Go Live** - Once the status is updated, the workflow will automatically post your content to the selected social media platform(s). - Sit back and watch your AI-generated captions and images go live automatically. **Ready to automate your social media?** Activate your workflow and start posting smarter today! 🚀💡✅

View

👨‍💻

Need Custom Automation?

N8N Automation Expert

Specialized in N8N automation, I design custom workflows that connect your tools and automate your processes.