When a row matching specific conditions is added to Google Sheets, analyze it with OpenAI and add the results

■Overview

Do you find it time-consuming to manually copy data accumulated in Google Sheets and analyze or summarize it with OpenAI? With this workflow, whenever a specific row is added to Google Sheets, OpenAI automatically analyzes the specified content and appends the results to the sheet. By automating routine analysis tasks through the integration of OpenAI and Google Sheets, you can spend more time on higher-value work.

■Who Is This Template For?

• Anyone who wants to integrate OpenAI with Google Sheets and automate data analysis
• Anyone who manually classifies and summarizes data in Google Sheets
• Anyone who wants to eliminate human errors such as transcription mistakes and missed checks during manual data analysis

■Benefits of Using This Template

• Adding data to Google Sheets triggers everything from analysis with OpenAI to appending the results, helping you reduce the time previously spent on manual work
• Prevent human errors such as data transcription mistakes and prompt input errors, improving the accuracy of your work

■Workflow Overview

1. First, connect your Google Sheets and OpenAI accounts to Yoom
2. Next, select Google Sheets as the trigger, set the “When a row is added” action, and specify the target sheet and table range
3. Next, add the “Branch” feature as an operation and configure it so that only rows meeting specific conditions proceed to the subsequent steps
4. Next, set OpenAI’s “Generate text (Chat completion)” action as an operation and create an analysis prompt based on the information retrieved by the trigger
5. Finally, set Google Sheets’ “Add a record” action as an operation and add the results generated by OpenAI to any sheet

※“Trigger”: An action that initiates the flow. “Operation”: An action that performs processing within the flow after the trigger starts.

■Customization Options

• In the Google Sheets trigger and operation settings, configure the target spreadsheet, sheet, table range, and other details as needed
• With the Branch feature, you can freely customize the conditions for running subsequent operations using information retrieved by the preceding trigger, such as “only when a specific column is not empty”
• You can freely customize the prompt used to request text generation from OpenAI, and embed information from specific cells retrieved from Google Sheets as variables in the prompt

■Notes

• Connect Google Sheets and OpenAI to Yoom.
• You can select a trigger interval of 5, 10, 15, 30, or 60 minutes.
• Please note that the shortest trigger interval varies by plan.
• Branching is an available feature (operation) on the Mini plan and higher. On the Free plan, operations configured in your flow bot will result in an error.
• Paid plans such as the Mini plan include a 2-week free trial. During the free trial, you can use apps and features (operations) that are otherwise subject to restrictions.
• To run ChatGPT (OpenAI) actions, you need a paid OpenAI API plan. (You must be able to make payments when the API is used.)
  OpenAI API pricing
• OpenAI provides paid access to the ChatGPT API, which uses a pay-as-you-go pricing model based on the tokens used during API communication. Please note that an error will occur if you are unable to make payments when using the API.