When a record is created in Airtable, summarize its content with ChatGPT and add it to Google Sheets

■Overview

Reviewing and summarizing customer inquiries, survey responses, and other information accumulated in Airtable one by one can be time-consuming. Even if you want to streamline the process with ChatGPT, manual integrations may not reduce the workload. With this workflow, whenever a new record is added to Airtable, ChatGPT automatically summarizes its contents and records the result in Google Sheets, helping resolve these data organization challenges.

‍

■Who Should Use This Template

• Anyone who wants to connect Airtable and ChatGPT to automate information gathering and summarization
• Anyone who manually transfers information registered in Airtable to Google Sheets
• Anyone who wants to reduce the burden of routine data organization and focus on higher-value tasks

‍

■Benefits of This Template

• Automate the entire process—from adding a record to Airtable to summarizing it with ChatGPT and recording the result in Google Sheets—so you can reduce the time spent on manual work
• Eliminate manual copy-and-paste tasks to prevent human errors such as transcription mistakes and missed summaries, helping maintain data accuracy

‍

■Flowbot Steps

1. First, connect Airtable, ChatGPT, and Google Sheets to Yoom
2. Next, select Airtable as the trigger and set the “When a record is added” action
3. Then, set ChatGPT’s “Generate text” action as the operation and instruct it to summarize the Airtable record retrieved by the trigger
4. Finally, set Google Sheets’ “Add a record” action as the operation and add the summary generated by ChatGPT to the specified sheet

* “Trigger”: An action that starts the flow. “Operation”: An action that processes data within the flow after the trigger starts.

‍

■Workflow Customization Options

• In the Airtable trigger settings, specify the base ID or table ID (or table name) you want to connect, as well as the field information containing the content to summarize
• For the action that adds data to Google Sheets, specify the spreadsheet ID where you want to record the summary and the name of the specific tab within the file

‍

■Notes

• Connect Airtable, ChatGPT, and Google Sheets to Yoom.
• You can select a trigger interval of 5, 10, 15, 30, or 60 minutes.
• Please note that the shortest available trigger interval varies by plan.
• For instructions on how to retrieve Airtable outputs, refer to this guide.
• To run ChatGPT (OpenAI) actions, you need a paid OpenAI API plan that allows you to make payments when the API is used.
• OpenAI charges for ChatGPT API usage based on the number of tokens used when connecting to the API. Please note that an error will occur if you are unable to make payments when using the API.