Latenode
Google sheets
OpenAI GPT Assistants
Google Business Profile

Streamline Google Business Profile posting with AI-generated content

This n8n workflow automates the generation and publication of Google Business Profile posts using GPT-4 and Google Sheets.

It pulls post topics from a Google Sheet, generates SEO-optimized descriptions and AI-powered visuals using OpenAI, then publishes the content directly to the Google Business Profile and marks the posts as published in the sheet. This solution is ideal for digital marketers, agencies, and businesses looking to streamline their GMB content creation and posting processes while maintaining a content log. It integrates with Google Sheets, Google Business Profile, and OpenAI to provide a fully automated, visually engaging GMB posting workflow.

Updated Apr 2, 2026Est. run: 20sEst. cost: $0.0012
How Latenode estimates time and cost

Latenode bills workflow runs in credits: 1 credit = 30 seconds of processing. Minimum charge per run depends on your plan. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how credits work →
Social media

Workflow preview

What this template does

  • Pulls post topics from a Google Sheet
  • Generates SEO-optimized descriptions using GPT-4
  • Creates AI-powered visuals using OpenAI
  • Publishes content directly to Google Business Profile
  • Marks published posts in the Google Sheet

How it works

1
Trigger

Read unposted rows from Google Sheets

The workflow starts by reading unposted rows from a Google Sheets spreadsheet. This spreadsheet contains the topics and parameters for the Google Business Profile posts that need to be generated and published.

2
AI

Generate SEO-optimized post description using GPT-4

For each unposted row, the workflow uses OpenAI's GPT-4 model to generate an SEO-optimized description for the Google Business Profile post based on the topic and parameters provided in the spreadsheet.

3
Action

Publish post to Google Business Profile

The workflow then publishes the generated post directly to the Google Business Profile for the associated business, making the content live on the Google Business Profile.

4
Action

Mark row as published in Google Sheets

After successfully publishing the post, the workflow marks the corresponding row in the Google Sheets spreadsheet as published, creating a content log and avoiding duplicate posts.

Setup guide

1

Add Google Sheets Credentials

In the Latenode Credentials panel, add your Google Sheets OAuth2 credentials. This will allow the workflow to access and update your Google Sheet.

2

Add OpenAI API Key

In the Latenode Credentials panel, add your OpenAI API key. This will enable the workflow to use the GPT-4 language model for generating post content.

3

Configure Google Business Profile Credentials

In the Latenode Credentials panel, add your Google Business Profile OAuth2 credentials. This will allow the workflow to publish posts directly to your Google Business Profile.

4

Map Google Sheets Data

In the Google Sheets node settings, map the relevant columns from your Google Sheet (e.g., post topic, status, dates) to the workflow data structure.

5

Customize OpenAI Prompt

In the OpenAI Chat Model node settings, customize the prompt to match your brand's voice and tone for the generated post content.

Requirements

Access to a Google Sheets spreadsheet to store post topics and details
API credentials for the OpenAI API to generate post descriptions and visuals
Access to a Google Business Profile account to publish the generated posts
Latenode workspace set up with the 'Google Sheets', 'OpenAI ChatGPT', and 'Google Business Profile' nodes

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work.
Contact support →

More templates

You might also like

Browse all templates →
Social media

Automate and schedule recurring Instagram post liking

This automated workflow allows Instagram users to schedule recurring post liking on a 2-hourly schedule. It uses Phantombuster to scrape recent posts under AI-generated hashtags, GPT-4o for intelligent hashtag selection, and a rotating set of Instagram session cookies to distribute likes across multiple accounts while staying within platform limits. The workflow uploads the posts to be liked to a SharePoint repository, then triggers the Phantombuster 'Auto-like Agent' to interact with the selected content. This streamlined approach helps Instagram users boost engagement and growth on their accounts without manual effort.

28s$0.0018
Social media

Streamline cold calling with automated prospect scraping, AI scripts, and WhatsApp outreach

This workflow automates the entire cold calling pipeline, from prospect identification and research to personalized message creation and delivery. It leverages Apify for web scraping, GPT-4o for intelligent content generation, and WhatsApp integration for automated outreach, transforming raw prospect data into high-converting, personalized cold calling campaigns. The workflow can be triggered manually or via a Google Drive Trigger, and it stores prospect data in a Supabase vector database, processes the data using OpenAI's language models, and sends the personalized messages through the WhatsApp Business API. This solution aims to help sales teams streamline their cold calling efforts, increase reach and response rates, and improve message effectiveness through continuous AI-powered optimization.

22s$0.0014
Social media

Automatically sync LinkedIn Ads lead data to Google Sheets

This automation enables users to seamlessly capture new lead generation form responses from LinkedIn Ads and automatically add them as rows in a designated Google Sheets spreadsheet. This helps consolidate and centralize all LinkedIn Ads lead data in one organized location for further analysis and processing. The automation triggers whenever a new lead form response is received from LinkedIn Ads, and it then creates a new row in the connected Google Sheets spreadsheet, ensuring that users have a comprehensive view of their lead data. This integration streamlines the lead management workflow, saving users time and effort by automating the data transfer process between LinkedIn Ads and Google Sheets.

8s$0.0005