ChaptGPT-4 AirTable Extension Step-by-Step Installation Guide

Here is a step-by-step guide for installing the ChatGPT-4 AirTable extension. If you have any questions, please don’t hesitate to contact us and we can help with installation or customization.

Following this guide will result in a fully working ChatGPT-4 / OpenAI automated extension that can generate prompts in bulk. There isn’t any need for you to edit the code as all of the necessary information can be entered in by clicking or typing the needed information.

You need your own OpenAI API key to use this extension.

On your AirTable base click on “Extensions” in the top right corner of the table.

chatgpt to airtable 1

Then click the “Add an extension” button

chatgpt to airtable 2

You will then search for “scripting” and click “Add” on the Scripting AirTable extension.

chatgpt to airtable 3

This will load their code editor where you can paste in the ChatGPT-4 AirTable Extension script. They do have a default script that is included upon installation of the extension and you will to overwrite their code, as pictured below.

chatgpt to airtable 4

From here you can click on “<> Finish Editing”

And then exit out of the extension window.

chaptgpt to airtable 5

Clicking on the “Run” button in the extension window will run the extension which will show user input prompts below the Scripting box to ask for things like your OpenAI key and your prompt.

chatgpt to airtable 7

Your first course of action will be to choose the AirTable Table that you want the script to run on. The extension will give you a choice between the Tables that you have in the AirTable Base.

Once you’ve chosen the Table, it will pull up the available Views and you can click on which one you want the extension to run on.

You will now choose the column that you want to use in your prompt. You can use this field as your entire prompt or it can be used as a variable within your prompt. With this example it will be used as a variable in the prompt. When you type in your prompt your chosen column will be used at the very end of the prompt. For example, writing “Write a funny tweet about” in the prompt input box will result in the prompt sent to the API being “Write a funny tweet about Christmas” and then it will go down the rows one-by-one, swapping the variable in the Name column with each prompt.

You will then choose the column that you want the response from ChatGPT / OpenAI to be input into. If there is content already within the record, it will be overwritten when the response is returned from ChatGPT / OpenAI.

Next you will paste your OpenAI key into the box and click “Next.” If you need to create an API key, please visit your account settings on the OpenAI website.

chatgpt to airtable 8

Then you will choose which OpenAI or ChatGPT model you want to use by clicking on it.

chatgpt to airtable 9

Now you’ll choose the maximum amount of tokens you want to use for your prompt. The max amount of tokens that can be used for each model and additional info about tokens can be found here: OpenAI Models.

Your last step will be to write your prompt. The code is setup to use a value from your AirTable record with each row. In our examples that we’ve used that would mean “Christmas” or “Halloween” would be included at the end of your prompt. So in a situation where you want to generate tweets about the values in the Name column you would write your prompt like this:

Write a funny tweet about

This will get sent to the API as “Write a funny tweet about Christmas.”

And you can then click next. It will automatically see the value in the “Name” column and go line by line to generate a ChatGPT-4 or OpenAI response.

The extension will now send your prompt to the OpenAI / ChatGPT API and will return the response in the chosen column for each row.

chatgpt to airtable 12