When a record matching specific conditions is added to Airtable, summarize its content with ChatGPT and add it to Google Sheets

■Overview

Reviewing the information that accumulates in Airtable every day, summarizing it with ChatGPT, and manually transferring it to another tool is time-consuming and can easily lead to oversights.
With this workflow, whenever a record that meets specific conditions is added to Airtable, ChatGPT automatically summarizes the content and adds the information to a designated Google Sheets spreadsheet. Eliminate the need to organize information manually and achieve more efficient data management.

‍

■Who This Template Is For

• Anyone who manually collects information or manages customers using Airtable and ChatGPT
• Anyone who manually transfers and shares data managed in Airtable with Google Sheets
• Anyone who wants to automate routine tasks using Airtable and ChatGPT and focus on core business activities

‍

■Benefits of Using This Template

• Automate the entire process—from adding a record to Airtable to having ChatGPT summarize it and adding the result to Google Sheets—to reduce the time spent on manual work
• Eliminate manual copy-and-paste and summarization tasks to help prevent human errors such as data transfer mistakes and incomplete summaries

‍

■Workflow

1. First, connect Airtable, ChatGPT, and Google Sheets to Yoom
2. Next, select Airtable as the trigger and set the action to “When a record is added”
3. Next, use the branching feature to configure the workflow so that it proceeds only when specific conditions are met
4. Next, select ChatGPT as an operation and use the “Generate text” action to create a summary based on the information retrieved from Airtable
5. Finally, select Google Sheets as an operation and use the “Add a record” action to add the generated text to the designated sheet

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

‍

■Customization Options

• For the Airtable trigger, configure the connected base ID, table ID or name, and the field information you want to retrieve as needed
• For the operation branching settings, you can define the conditions for starting subsequent workflow bots
• For the action that adds a record to Google Sheets, configure the spreadsheet ID and sheet tab name where the data will be written as needed

‍

■Notes

• Connect each of 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 information on how to retrieve Airtable outputs, see here.
• To run ChatGPT (OpenAI) actions, you must have a paid OpenAI API plan. (You must be able to make payments when the API is used.)
• OpenAI charges for ChatGPT API usage based on the number of tokens used when communicating with the API. Therefore, an error will occur if you are unable to make payments when using the API.
• Branching is an operation available on the Mini plan and above. On the Free plan, workflow bot operations that include branching will result in an error.
• Paid plans such as the Mini plan include a two-week free trial. During the free trial, you can use apps and features (operations) that are subject to plan restrictions.