・
Organizing meeting minutes can take time. But don’t let these frustrations slow you down; there’s a perfect solution.
By integrating Google Sheets with ChatGPT, you can automatically summarize meeting minutes and update your Google Sheets with summarized content. This automation can save you time and effort on manually summarizing and updating records :) There are also more possibilities with using ChatGPT to summarize chat tool messages and automatically update them to Google Sheets. Perfect for when you need to review important information later.
In this article, we will explain how to easily set up these automations using ChatGPT and the no-code tool Yoom.
Yoom is a next-generation no-code automation that lets you connect and automate tasks between your favorite apps. Connecting different apps can be challenging for non-engineers, but <span class="mark-yellow">Yoom makes automation accessible to everyone</span>.
You don't need to go through a complex setup and IT jargon, you can build your automation workflows with just a few clicks :) It's designed for those who want to streamline their daily work and save hours of time and stress from repetitive work.
👉 Sign Up for Yoom Here – Quick and Easy in Just 30 Seconds!
In this guide, you'll learn the step-by-step process of how to use Yoom to <span class="mark-yellow">automatically summarize meeting minutes using ChatGPT and update them to Google Sheets</span>.
Yoom offers ready-made templates to automatically summarize meeting minutes created in Google Sheets using ChatGPT.
We’ll also walk you through the step-by-step process of creating this automation flow in the following section of this article.
There are several ways to automatically update and organize data using ChatGPT. Here are some practical, ready-to-use templates you can try out.
Just click on the "Try It" button to get started quickly!
This flow uses data management applications like Google Sheets to send data to ChatGPT for organization and summarization.
You no longer need to reorganize the data manually, making it perfect for creating reports and documents quickly :)
This flow starts with chat applications like Microsoft Teams, then uses ChatGPT to summarize and organize the message.
You don’t need to read the lengthy conversations or transfer the data to another tool for further action.
This flow uses tools like Google Forms to automatically summarize responses using ChatGPT and update a Notion database.
Perfect for those who want to quickly review collected opinions, requests, or compile meeting minutes.
We'll walk you through how to set up a flow that <span class="mark-yellow">automatically organizes and summarizes meeting minutes using ChatGPT and updates it to Google Sheets</span>.
⏱️ Setup time: 10 minutes
🔧 What You’ll Need
If you don’t have a Yoom account yet, register now from this registration form!
⚠️ Note: To run ChatGPT (OpenAI) actions, you’ll need a paid OpenAI API plan. Make sure you have your payment set up ready for smoother transactions when the API usage fees are incurred. For more details, visit OpenAI API Pricing.
Go to "My Apps" from the left side menu, and click the "+ Add" button.
Search for the application name and select it.
Enter the account name. Use a name that's easy to recognize, such as your company name or the person responsible for the account.
To get your access token, you need to create and obtain the API Secret key.
First, log in to the OpenAI API platform.
Then click the gear icon at the top right → API Keys in the left menu → Create new secret key at the top right in order.
Set each item and create the Secret key.
Copy the displayed Secret key and save it in a secure location.
‼️ Once you leave this screen, you will not be able to view the key.
Paste it into the AccessToken field, and click "Add".
Search for Google Sheets from the app list and select it.
Click on "Sign in with Google".
Select the account you want to connect to, then click "Continue".
Once the apps are connected in Yoom, you will see the following notification pop up.
Click the "Try It" button to copy the pre-built template into your project.
Click "Try this template".
Click "OK" and give the Flowbot a name to recognize.
This template will be copied to your “My Project”.
First, click the "When a row is added" icon at the top.
Give the trigger a title (optional) and verify that the correct Google account is selected.
Then, click "Next".
Set your trigger interval (frequency of sync) to how frequently Yoom checks Google Sheets for updates. It can be set to 5 minutes, 10 minutes, 15 minutes, 30 minutes, or 60 minutes. We recommend setting the trigger to the shortest activation interval available for your plan.
⚠️ Note: The trigger interval varies depending on your Yoom plan. Be sure to check your current plan’s limit.
Select the Spreadsheet ID and Sheet ID (where Yoom checks for updates) from the displayed options.
Specify the Table Range (Start), Table Range (End), based on where your data starts and ends in Google Sheets.
For Column with Unique Values, select a column with no duplicate values, such as email addresses or IDs. This column will act as the unique key.
For this example, we prepared the following Google Sheets for testing purposes.
Once the setup is complete, click "Test".
If the test is successful, the information retrieved from Google Sheets will be displayed as the retrieved value, as shown below.
Don't forget to click "Save" after the test is complete!
Next, click the "Summarize" icon.
Give your action a title (optional) and confirm your ChatGPT account is selected.
Then, click "Next".
Click on the input field to display data retrieved from Google Sheets as Meeting Names or Meeting Dates. You can use these dynamic values to create your instruction. Using the retrieved values will create instructions that change each time the flow is triggered. Avoid entering fixed text in the message content, as it will generate the same way every time.
For this example, we want ChatGPT to create meeting minutes. So we select "Minutes" from the Google Sheet's retrieved value.
📚 Reference: For more details on retrieved values and how to set them up, see the guide here.
Settings like temperature and maximum token count are optional, so feel free to adjust them as needed. Refer to the annotations for guidance when modifying these settings.
Once the setup is complete, click "Test" and save if there are no issues!
Finally, click the "Operate Database" icon.
Set the account information to link with Google Sheets.
Make sure "Update record" is selected as the action.
Spreadsheet ID, Worksheet Tab Name
Table Range:
📚 Reference: For more details on table range settings, check this guide.
Once the setup is complete, click "Next".
Set the conditions for updating the record. In this case, the condition is the "Meeting No." which serves as the unique key.
Now we specify what data to add to Google Sheets.
In this case, we want to add the summarized content from ChatGPT into Google Sheets. So we will select "Response Content" to quote ChatGPT output in the meeting minutes column.
Once the setup is complete, click "Test".
If the test is successful, the summary generated by ChatGPT will get added into the specified column in Google Sheets.
Once confirmed, don't forget to click "Save"!
Toggle the "Trigger On" button to activate your flow! Check if the Flowbot you set up is working properly.
That’s it! Your Flowbot is complete!
You can try out more automation using ChatGPT and Yoom. Here are some more examples you can explore for your next automation.
If you’re interested in automating using ChatGPT, try out the templates we’ve introduced :) <span class="mark-yellow">You can set up processes that handle summarizing meeting minutes, messages from chat tools, and responses from forms, all without manual effort</span>.
This time, we introduced a flow to automatically summarize meeting minutes using ChatGPT and update them to Google Sheets. With this automation, your database is automatically updated, and you no longer need to manually create or input the summary. Best of all, no special knowledge is needed, and anyone can easily set it up! Ready to simplify your workflow? Sign up for Yoom and try it today!
.avif)
.avif)
.avif)
