How to Automate Blog Creation from Google Sheets Using OpenAI

How to Automate Blog Creation from Google Sheets Using OpenAI
By Wenddy Dias ·
6/26/2025
·
8 min. read

In this article

Managing content production can be time-consuming and repetitive, but it doesn’t have to be. With the right automation, the entire process—from topic ideation to Slack notification—can be triggered simply by filling out a Google Sheet.

In this case study, we’ll show how to build a powerful automation using OpenAI in Albato. With this setup, every new row in a designated Google Sheet triggers a series of actions to create SEO-friendly blog content, generate images, and notify your team—without writing a single line of code.

Note: You’ll need to connect your Google Sheets, OpenAI, Google Drive, Google Docs, and Slack accounts.

To get detailed setup instructions or access a ready-to-use automation template, keep reading.

 

Task: Automate blog creation with OpenAI from a Google Sheet

Our goal was to let team members initiate content creation simply by adding a row in Google Sheets. The process needed to:

  1. Identify when a team member adds a new entry to a content management spreadsheet, specifying the blog topic (e.g., "Top 10 SEO Tips") and keywords (e.g., "SEO", "digital marketing", "Google ranking").
  2. Automatically generate a blog post draft using AI.
  3. Generate the instructions for producing the image to accompany the post.
  4. Create an image optimized for web use using AI.
  5. Create a Google Drive folder to store the image.
  6. Get the URL of the generated images via HTTP Request/Outgoing webhook so they can be stored.
  7. Add the images to Google Drive.
  8. Move the file to the created Google Drive folder.
  9. Uploaded the text to a Google Docs file, with image links from Google Drive.
  10. Update the sheet status accordingly.
  11. Notify the team in Slack.

Automation.png

 

Instructions: How to set up the Solution in Albato

Step 1

Follow the link to install the solution in Albato. Click Grant Access to add the template to your personal account.

Solution1.png

Step 2

With the Blog Automation scenario activated, click Continue.

Solution2.png

Step 3

Set up connections to services.

Some apps also require additional parameters to be filled in:

  • In the Google Sheets step, choose the Spreadsheet you'd like to use for this automation. In the Spreadsheet sheet field, select the worksheet containing your data.
  • In the Google Docs step, choose the Docs with the template you want to use to upload the AI-generated content.

Solution3.png

Step 4

In Field settings, click Continue.

Solution4.png

Step 5

After clicking Let’s go, you can make the necessary edits in the automation through the gear icon.

Once everything is properly configured, simply click the Start button.

Solution5.png

The installed solution will be available in the section Solutions → My installations.

 

Technical nuances

  • You can change the Automation timing at the top of the page. You can find out what Albato's Automation timing is all about in these instructions.

Timing.png

  • The Google Sheets variables you use should correspond to the respective columns you are using in your spreadsheet. In our template, we are using columns for Topic, Keywords, Status, Google Docs Link, and Notes.

Template.png

  • In the OpenAI: Create chat completion steps, you can edit the Message field with your own prompt, using another text and variables. You can also change the Role and the Model - ID if you want. The other fields are optional.

  • You can add an extra step to refine the text for readability and brand alignment using a custom AI prompt. Humanizing the language enhances tone and avoids Google penalties for AI-generated content.

  • In the OpenAI: Image Generation step, you can edit the text description of the desired image (prompt) and select the size of the generated image according to your specifications.

  • Repeater tool can be used to generate multiple images from a single row. Define the Start value as 0 and set the desired Number of repetitions. In this case, you will also need to add a Router tool to the automation, with the following settings:

Template (2).png

  • In Google Drive steps, feel free to edit the folder and file names.

  • In the Google Docs step, use a template with the indication of {{content}} in the section where you want to customize the text. Then, fill in the automation's custom fields with the variable Create chat completion: Response content, obtained from the second step. You can also add the link to the folder created in Google Drive.

Template (1).png

  • In the Slack step, update the Channels in Slack - ID from the drop-down list. You can also edit the Text message with another text and variables. If you prefer, you can use the Markdown-formatted text message field instead of Unformatted text message (not both).

  • You can expand this scenario with publishing steps (e.g., WordPress, Webflow, Medium).

 

Results: Content created in minutes, not hours

This automation significantly reduces the manual work of content production. Writers can now focus on refining and publishing, not starting from scratch.

 

Summing up

By connecting Google Sheets with OpenAI through Albato, you can automate blog creation from idea to delivery.

If you're interested in setting up a similar flow or exploring more automation ideas, check out these articles:


Wenddy Dias
Wenddy Dias
LinkedIn
Marketing Manager at Albato
All articles by the author
Marketing professional with experience across product marketing, community management, partnerships, inbound strategy, and content.

Join our newsletter

Hand-picked content and zero spam!

Related articles

Show more
Best AI Automations with Albato: ChatGPT, Claude, Gemini
10 min. read

Best AI Automations with Albato: ChatGPT, Claude, Gemini

In this article, you will find some examples of powerful AI automations with ChatGPT, Claude, and other LLMs you can set up with Albato to boost productivity and streamline your business processes effortlessly.

Grok 4, GPT-5, Gemini, and Claude Opus 4.1―All the Recent Updates
13 min. read

Grok 4, GPT-5, Gemini, and Claude Opus 4.1―All the Recent Updates

In this article, you will find an in-depth comparison of Grok, ChatGPT, Gemini, and Claude. Discover their strengths, weaknesses, and which AI chatbot fits your business needs best.

Best Sales Automation Apps for Faster Growth
10 min. read

Best Sales Automation Apps for Faster Growth

In this article, you will learn about the best sales automation apps to save time, close more deals, and boost team productivity. Compare features, pricing, and integrations.

What Tools To Connect to OpenAI with Albato
3 min. read

What Tools To Connect to OpenAI with Albato

In this article, you will learn what tools you can connect to ChatGPT(Open AI) with Albato to set up automated workflows for different use cases.

How AI Is Transforming SaaS: Webinar Insights
7 min. read

How AI Is Transforming SaaS: Webinar Insights

In this post, you will learn about the top 5 ways how artificial intelligence (AI), agents, and MCP are transforming the SaaS industry.

Choosing the Right Tool: A Comparison of Top GenAI Models
21 min. read

Choosing the Right Tool: A Comparison of Top GenAI Models

In this article, you will find the comparison of top genAI models, including ChatGPT, Gemini, Claude, and others with pros, cons, and use cases.

Best AI Tools 2025: Top Artificial Intelligence Apps for Work & Productivity
Frase
50 min. read

Best AI Tools 2025: Top Artificial Intelligence Apps for Work & Productivity

In this article, you will learn about the best AI tools in 2025 for business, meetings, SEO, writing, and more to boost productivity and save time.

What Are the Leading Apps for Improving Remote Team Collaboration
3 min. read

What Are the Leading Apps for Improving Remote Team Collaboration

In this article, you will learn about the leading apps that help remote teams collaborate effectively, stay productive, and maintain seamless communication.

How Can Automation Software Reduce Costs and Improve Operations in Small Businesses
3 min. read

How Can Automation Software Reduce Costs and Improve Operations in Small Businesses

In this article, you will learn how automation software can help small businesses save costs, improve operations, and create scalable workflows without increasing headcount.

 What’s the Step-by-Step Way to Sync Facebook Ads Leads with Google Sheets Using Albato?
3 min. read

What’s the Step-by-Step Way to Sync Facebook Ads Leads with Google Sheets Using Albato?

In this article, you’ll learn how to set up an automation that syncs Facebook Ads leads with Google Sheets step-by-step using Albato.

How to Document All Your Automations with AI
3 min. read

How to Document All Your Automations with AI

In this article, you’ll learn how to document your workflow automations using AI easily, and how a platform like Albato helps simplify the process from end to end.

Best AI Prompts To Generate Albato Integration Ideas
3 min. read

Best AI Prompts To Generate Albato Integration Ideas

In this article, you’ll learn how to craft effective AI prompts that generate useful Albato integration ideas—and how to turn those ideas into real workflows without writing a line of code.