# How to Automate Blog Creation from Google Sheets Using OpenAI — Albato Help Center

Source: https://albato.com/wiki/articles/how-to-automate-blog-creation-from-google-sheets-using-openai

Welcome to Albato Help

Search articles

# How to Automate Blog Creation from Google Sheets Using OpenAI

Last update:  
22/5/2026 · 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](https://albato.com/blog/publications/connecting-google-sheets-to-albato), [OpenAI](https://albato.com/blog/publications/openai-automate-with-albato), [Google Drive](https://albato.com/blog/publications/google-drive-connection-instructions), [Google Docs](https://albato.com/blog/publications/google-docs-automation-for-online-document-editor), and [Slack](https://albato.com/blog/publications/connecting-slack-to-albato) 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](https://albato.com/app/share/confirmation/solution/nEz43x42m9lOylmOrd2wFQ) 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](https://albato.com/blog/publications/albato-automation-operation-mode) 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:

-   [Building a Winning Enterprise AI Strategy](https://albato.com/blog/publications/enterprise-ai-strategy)
-   [Best Tools for Automating Content Delivery in 2025](https://albato.com/blog/publications/best-toolfor-automating-content-delivery-2024)
-   [Artificial Intelligence Automation: How to Use It to Work Smarter](https://albato.com/blog/publications/artificial-intelligence-automation-a-2025-guide)

Did this answer your question?