Run content blog on autopilot using OpenAI GPT3 & Airtbale & Webflow.

Greg Vonf @ Business Automated
7 min readJan 27, 2023

Hypercharge your content marketing using technology behind ChatGPT, Airtable, Make automations and Webflow.

📢Now templates updated to use with GPT4! Use updated chat completion templates with GPT3.5 Turbo if you do not have access to GPT4.

Introduction

In this tutorial, we’ll teach you how to use Airtable, OpenAI GPT-3, Make.com and Webflow to automate the process of creating and publishing content for your blog or website.

We’ll start by demonstrating the setup of Airtable as a content management system. You’ll learn how to create tables and fields to store your content, as well as advanced features like kanban views, calendar views, and automations to make content creation a breeze.

Next, we’ll integrate OpenAI GPT-3, a state-of-the-art language model, to generate text for your blog. To simplify accessing OpenAI we will be using Make.com. We’ll show you how to use GPT-3’s API to generate text based on a given prompt and how to use Airtable to trigger GPT-3 to generate text automatically.

Make.com (formerly Integromat) is a automation software that enables you to link various apps and services to automate repetitive tasks and workflows. It allows businesses and individuals to simplify their processes by building custom automations, known as “scenarios,” that can be activated by events or scheduled to run at specific intervals. It’s a user-friendly platform that provides the ability to create complex automations, thus saving time and effort.

Lastly, we’ll guide you through the process of connecting and publishing your blog using Webflow. This platform allows for easy creation and publishing of responsive websites, we’ll show you how to connect Webflow’s to your Airtable data using Make. We also explain how to improve the default SEO settins on Webflow blog pages.

By the end of this tutorial, you’ll have a fully automated content blog that is easy to update and manage, saving you time and effort. Whether you’re a blogger, marketer, or small business owner, this tutorial will help you create and publish high-quality content. Don’t forget to subscribe and follow us on Youtube or Twitter.

Building blocks

The system consists out of:

  1. Airtable base
  2. Airtable automations
  3. Make.com scenario to interact with OpenAI
  4. Make.com scenario to publish content to Webflow

Get the Airtable base and blueprints:

https://businessautomated.gumroad.com/l/automated-content-blog-airtable-gpt3-webflow

Airtable base

If you have not used Airtable before you can create a free account here. However you will need paid account to use scripts inside of the Automations.

The bases contains key columns for our Webflow blog:

  • Blog Title
  • Content Theme / Vertical
  • Hero Image
  • Status ( a single select field that doubles as action trigger)
  • Idea description
  • Blog content (Rich text field using Markdown for better formatting in Webflow)
  • Editing Notes ( for use with Open AI GPT helping us edit the content, feels a bit like ChatGPT 😉)
  • slug (Airtable formula that generates slug for Webflow articles)
  • SEO Summary
  • Publishing date
  • Webflow Id
  • Link to page (where we can see the Webflow page after publishing)

We also have some helpful additional views there:

View content by vertical

Content by vertical

Kanban board with stages

See and manage stages of your content

Content publishing calendar

See on calendar when your content gets published

Sidebar with overview

Airtable extensions give you quick overview of content count per stage

Editing experience

Having used ChatGPT you must have realized that AI makes some funny mistake and omissions, so the text will clearly need to be edited. The single record view in Airtable and the rich text field for content, provide best experience for it.

Single record view in Airtable

Get the ready made Airtable base for here: https://businessautomated.gumroad.com/l/automated-content-blog-airtable-gpt3-webflow

Airtable Automations

There are 3 crucial Airtable automations that help to streamline the process of operating the base.

  1. Sending Airtable data to Make and OpenAI
  2. Sending Airtable data to Make and Webflow
  3. Changing Status to “Scheduled”

Due to Airtable limitations — when cloning the master base — the automations are not cloned. You will have to add them by your self. Below is the walkthrough.

Sending Airtable data to Make and OpenAI

Trigger:

“When record matches conditions” and conditions are following:

Status needs to be equal to any of the 4 actions above for which we want to have action from OpenAI

Action

Run a script. Important you need to add “Airtable record ID” as variable recordId. The code of the script is available below.


//Replace this with URL for your own webhook
const webhookUrl ="https://hook.us1.make.com/YourWebhookURL"

const {recordId} = input.config();


const response = await fetch(`${webhookUrl}?recordId=${recordId}`)

console.log(response.status)

Make sure to turn ON the automation at the end.

Sending Airtable data to Make and Webflow

Trigger:

“When record enters view” and conditions are following:

Important, if you are setting up base from the scratch make sure that the “Content to be published view” contanins the correct filter selection:

The only items that should show up in the view, should be items, that are Scheduled with date for today or earlier.

Action

Run a script. Important you need to add “Airtable record ID” as variable recordId. The code of the script is available below and it is exactly the same as the previous script.

//Replace this with URL for your own webhook
const webhookUrl ="https://hook.us1.make.com/YourWebhookURL"

const {recordId} = input.config();

const response = await fetch(`${webhookUrl}?recordId=${recordId}`)
console.log(response.status)

Changing Status to “Scheduled”

Trigger

“When record matches conditions” and conditions are set as below

Status needs to be equal to Approved and Publishing date needs to exist

Action

The action is just to update the record by changing the Status to “Scheduled”

Make sure you turn it on, so that any approved post with that can be automatically scheduled to be published on Webflow.

This concludes all automations that need to be added to the base.

Make.com scenario to interact with OpenAI

If you have not done so already you can register for Make.com. You should be fine with free plan to at least start this scenario.

Here is a diagram of the scenario you need:

Make scenario to create ideas, blog posts and images with OpenAI

It will be necessary to register with Open AI for access to their API and to get API keys. You can do so here.

For details of Make setup — you can follow the video at the end of this article.

Make.com scenario to publish content to Webflow

You will need to have a website on Webflow and CMS plan if you want to be editing custom fields and adding a better SEO optimization.

Publishing content from Airtable to Webflow with Make

Above scenario allows you to publish content, store the necessary item ID and update the Webflow articles later. Use of Airtable Rich Text Field and Markdown to HTML element assures that we keep nice formatting created in Airtable also on Webflow blog pages.

You can get the ready made Make blueprints here or you can follow the video below for the full instruction how to set it up.

Watch the full tutorial on YouTube:

Get the Airtable base and blueprints of Make scenarios:

https://businessautomated.gumroad.com/l/automated-content-blog-airtable-gpt3-webflow

Business Automated is an independent automation consultancy. If you would like to request custom automation for your business, visit us at https://www.business-automated.com

If you like our tutorials — buy us a coffee☕: https://www.buymeacoffee.com/business

Follow us on Twitter🐦: https://twitter.com/BAutomated

Watch more on Youtube ️📺: https://www.youtube.com/c/BusinessAutomatedTutorials

--

--

Greg Vonf @ Business Automated

Greg is the founder of Business Automated, an agency helping small businesses streamline and simplify their processes. For more visit www.business-automated.com