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.
Meet Yoom: No-Code Automation
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 Yoom makes automation accessible to everyone.
🌐 Connect with apps like ChatGPT, Google Sheets, and more.
📖 Use automation templates - no technical setup required
📈 Boost productivity and reduce human errors
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.
In this guide, you'll learn the step-by-step process of how to use Yoom to automatically summarize meeting minutes using ChatGPT and update them to Google Sheets.
✔️ For Those Who Want To Try It Quickly
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.
Organize, summarize, and update the minutes created in Google Sheets using ChatGPT.
■Overview In this workflow, ChatGPT automatically organizes, summarizes, and updates meeting minutes entered into Google Sheets after meetings. This automation reduces effort and achieves high-quality meeting minutes management. With Yoom, you can easily connect apps without programming.
■Recommended for ・Business people managing meeting minutes in Google Sheets ・Team members spending time organizing meeting minutes after meetings ・Administrators looking to improve work efficiency using ChatGPT ・Company representatives aiming to enhance the consistency and accuracy of meeting minutes
■Notes ・You need to connect Google Sheets and ChatGPT with Yoom. ・To execute ChatGPT (OpenAI) actions, you need to subscribe to OpenAI's paid API plan. (Payment must be possible when the API is used) https://openai.com/api/pricing/ ・The use of ChatGPT's API is provided by OpenAI for a fee, and it is charged based on tokens during API communication. Therefore, please be aware that an error will occur if payment cannot be made when using the API.
■Overview In this workflow, ChatGPT automatically organizes, summarizes, and updates meeting minutes entered into Google Sheets after meetings. This automation reduces effort and achieves high-quality meeting minutes management. With Yoom, you can easily connect apps without programming.
■Recommended for ・Business people managing meeting minutes in Google Sheets ・Team members spending time organizing meeting minutes after meetings ・Administrators looking to improve work efficiency using ChatGPT ・Company representatives aiming to enhance the consistency and accuracy of meeting minutes
■Notes ・You need to connect Google Sheets and ChatGPT with Yoom. ・To execute ChatGPT (OpenAI) actions, you need to subscribe to OpenAI's paid API plan. (Payment must be possible when the API is used) https://openai.com/api/pricing/ ・The use of ChatGPT's API is provided by OpenAI for a fee, and it is charged based on tokens during API communication. Therefore, please be aware that an error will occur if payment cannot be made when using the API.
■Overview The "Organize and summarize meeting minutes created in Notion using ChatGPT" flow is a business workflow to streamline the creation and management of meeting minutes. It reduces the burden of creating meeting minutes and enables efficient information sharing.
■Who we recommend this template for: ・Those who manage meeting minutes in Notion but find it time-consuming to organize and summarize them. ・Those who find it challenging to manually organize detailed meeting minutes each time. ・Team leaders and project managers who want to share meeting content in an easy-to-understand manner. ・Those who want to smoothly share minutes and make decisions. ・Executives and managers who want to efficiently manage and update the content of minutes. ・Those who want to streamline regular meeting minute creation tasks. ・Those who want to automate tasks using AI and spend time on other important tasks. ・Those who want to focus on creative tasks.
■Precautions ・Please link Notion and ChatGPT with Yoom. ・By using the trigger with the Chrome extension, you can start the trigger directly from Notion. ・Please refer to the following for the setting method of the trigger using the Chrome extension. https://intercom.help/yoom/ja/articles/8831921
■Overview In this workflow, Slack messages are summarized by ChatGPT, and the summary results are automatically recorded in Google Sheets. This system allows you to organize important information without missing it and achieve automatic updates of business workflows. By using Yoom, you can easily connect apps without programming.
■Recommended for ・Those who use Slack daily and want to efficiently manage many messages ・Managers who want to automate and streamline operations using ChatGPT ・Those who want to automate data management in Google Sheets and simplify update tasks ・Leaders who want to centralize information summarization and recording to facilitate smooth team information sharing ・Companies that want to introduce automatic updates of business workflows to reduce work effort
■Notes ・It is necessary to connect Slack, Google Sheets, and ChatGPT with Yoom. ・To execute ChatGPT (OpenAI) actions, a paid plan contract for OpenAI's API is required. (Payment must be possible when the API is used) https://openai.com/ja-JP/api/pricing/ ・The use of ChatGPT's API is provided by OpenAI for a fee, and it is a pay-as-you-go system based on tokens during API communication. Therefore, please be aware that an error will occur if payment cannot be made when using the API.
■Overview This workflow allows ChatGPT to summarize discussions and shared content on Microsoft Teams and automatically reflect the results in Google Sheets. This automation facilitates smooth information organization and sharing. With Yoom, you can easily connect apps without programming.
■Recommended for - Team leaders who want to efficiently manage communication content on Teams - IT personnel who want to automate information summarization using ChatGPT - Business people who want to simplify data management in Google Sheets - Administrators of companies aiming for automatic updates of business workflows
■Notes - Microsoft Teams, Google Sheets, and ChatGPT need to be integrated with Yoom. - To execute ChatGPT (OpenAI) actions, a paid OpenAI API plan is required. (Payment must be possible when the API is used) https://openai.com/ja-JP/api/pricing/ - The use of ChatGPT's API is provided by OpenAI for a fee, and it is charged on a pay-as-you-go basis with tokens during API communication. Therefore, please be aware that an error will occur if payment cannot be made when using the API. - Microsoft365 (formerly Office365) has a home plan and a general corporate plan (Microsoft365 Business), and authentication may fail if you are not subscribed to the general corporate plan.
■Overview This workflow allows ChatGPT to summarize responses collected through Google Forms and automatically update the summarized content in Google Sheets. This process significantly reduces the manual effort of data organization and supports smooth decision-making. With Yoom, you can easily connect apps without programming.
■Recommended for - Business users collecting surveys or feedback using Google Forms - Personnel aiming to improve work efficiency by reducing time spent on manual data summarization - Those interested in automation solutions using ChatGPT and want to incorporate it into their workflow - Those who want to manage data more effectively in Google Sheets - Those who want to automate business processes by connecting multiple SaaS apps through Yoom
■Notes - You need to connect Google Sheets, ChatGPT, and Google Forms with Yoom. - To execute ChatGPT (OpenAI) actions, you need to subscribe to OpenAI's paid API plan. (Payment must be possible when the API is used) https://openai.com/ja-JP/api/pricing/ - The use of ChatGPT's API is provided by OpenAI for a fee, and it is a pay-as-you-go system based on tokens during API communication. Therefore, please be aware that an error will occur if payment cannot be made when using the API. - For methods to obtain response content when using Google Forms as a trigger, please refer to the following. https://intercom.help/yoom/en/articles/6807133
■Overview In this workflow, survey and feedback collected via Google Forms are succinctly summarized using ChatGPT, and the results are automatically recorded in Notion. This automation eliminates the need for manual data organization, enabling centralized information management and thorough analysis. With Yoom, you can easily connect apps without programming.
■Recommended for ・Those collecting many responses via Google Forms and spending time on manual summarization ・Business professionals looking to improve efficiency using ChatGPT and Notion ・Leaders aiming to automate data organization and analysis to enhance team productivity ・Personnel responsible for creating regular reports accurately and without omissions
■Notes ・You need to connect Notion, ChatGPT, and Google Forms with Yoom. ・To execute ChatGPT (OpenAI) actions, a paid OpenAI API plan is required. (Payment must be possible when the API is used) https://openai.com/ja-JP/api/pricing/ ・The use of ChatGPT's API is provided by OpenAI for a fee, and it is charged based on tokens during API communication. Therefore, if payment cannot be made when using the API, an error will occur, so please be careful. ・For methods to obtain response content when using Google Forms as a trigger, please refer to the following. https://intercom.help/yoom/en/articles/6807133
🚀 Create a Flow to Automatically Organize and Summarize Meeting Minutes in Google Sheets Using ChatGPT
We'll walk you through how to set up a flow that automatically organizes and summarizes meeting minutes using ChatGPT and updates it to Google Sheets.
⏱️ Setup time: 10 minutes
🔧 What You’ll Need
A free Yoom account
Access to ChatGPT and Google Sheets
If you don’t have a Yoom account yet, register now from thisregistration 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, visitOpenAI API Pricing.
Organize, summarize, and update the minutes created in Google Sheets using ChatGPT.
■Overview In this workflow, ChatGPT automatically organizes, summarizes, and updates meeting minutes entered into Google Sheets after meetings. This automation reduces effort and achieves high-quality meeting minutes management. With Yoom, you can easily connect apps without programming.
■Recommended for ・Business people managing meeting minutes in Google Sheets ・Team members spending time organizing meeting minutes after meetings ・Administrators looking to improve work efficiency using ChatGPT ・Company representatives aiming to enhance the consistency and accuracy of meeting minutes
■Notes ・You need to connect Google Sheets and ChatGPT with Yoom. ・To execute ChatGPT (OpenAI) actions, you need to subscribe to OpenAI's paid API plan. (Payment must be possible when the API is used) https://openai.com/api/pricing/ ・The use of ChatGPT's API is provided by OpenAI for a fee, and it is charged based on tokens during API communication. Therefore, please be aware that an error will occur if payment cannot be made when using the API.
Step 1: Connect ChatGPT and Google Sheets in My Apps
Go to "My Apps" from the left side menu, and click the "+ Add" button.
Search for the application name and select it.
Connect ChatGPT
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 theOpenAIAPI 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".
Connect Google Sheets
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.
Step 2: Copy the Template
Click the "Try It" button to copy the pre-built template into your project.
Organize, summarize, and update the minutes created in Google Sheets using ChatGPT.
■Overview In this workflow, ChatGPT automatically organizes, summarizes, and updates meeting minutes entered into Google Sheets after meetings. This automation reduces effort and achieves high-quality meeting minutes management. With Yoom, you can easily connect apps without programming.
■Recommended for ・Business people managing meeting minutes in Google Sheets ・Team members spending time organizing meeting minutes after meetings ・Administrators looking to improve work efficiency using ChatGPT ・Company representatives aiming to enhance the consistency and accuracy of meeting minutes
■Notes ・You need to connect Google Sheets and ChatGPT with Yoom. ・To execute ChatGPT (OpenAI) actions, you need to subscribe to OpenAI's paid API plan. (Payment must be possible when the API is used) https://openai.com/api/pricing/ ・The use of ChatGPT's API is provided by OpenAI for a fee, and it is charged based on tokens during API communication. Therefore, please be aware that an error will occur if payment cannot be made when using the API.
Click "OK" and give the Flowbot a name to recognize.
This template will be copied to your “My Project”.
Step 3: Google Sheets Trigger Action
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 Yoomplan. 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!
Step 4: Organize and Summarize with ChatGPT
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!
Step 5: Update Google Sheets
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
Select from the displayed options.
This is where you specify where you want to add the generated meeting minutes.
Table Range:
Set the table range where you want to add your data.
For this example, we will set it as below.
📚 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"!
Step 5: Activate the Flowbot
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!
💡 Other Automation Examples Using ChatGPT
You can try out more automation using ChatGPT and Yoom. Here are some more examples you can explore for your next automation.
After the Zoom meeting ends, create minutes with ChatGPT and send them to participants via email.
■Overview The "After Zoom meeting, create minutes with ChatGPT and send email to participants" flow is a business workflow that automates the creation and sharing of meeting records. It is an ideal workflow for teams that frequently hold meetings or organizations that prioritize the accuracy of records.
■Recommended for ・Business persons who frequently use Zoom and spend time creating minutes after meetings ・Project managers who want to accurately record meeting content and share it with the entire team ・IT personnel who want to improve work efficiency by utilizing ChatGPT ・Managers of companies who want to improve the quality of minutes and facilitate smooth information sharing ・Team leaders who find manual minute creation burdensome in meetings with many participants
■Notes ・Please link Zoom, ChatGPT, and Yoom respectively. ・You can select the trigger interval from 5 minutes, 10 minutes, 15 minutes, 30 minutes, and 60 minutes. ・Please note that the shortest trigger interval varies depending on the plan. ・To obtain Zoom recording information, meeting data must be cloud recorded. ・Cloud recording is limited to specific Zoom plans, so please be careful. Please refer to here for details. ・The maximum downloadable file size is 300MB. Depending on the app's specifications, it may be less than 300MB, so please be careful. ・Please check below for details on the file size that can be handled by triggers and each operation. https://intercom.help/yoom/ja/articles/9413924 ・OCR or AI operations that transcribe audio to text are functions available only in the Team Plan and Success Plan. In the case of the Free Plan and Mini Plan, the operations of the flow bot set will result in an error, so please be careful. ・Paid plans such as Team Plan and Success Plan can be tried for free for two weeks. During the free trial, you can use restricted apps and AI functions (operations).
■Overview The "Organize form content with ChatGPT and create a draft in WordPress" workflow is a business workflow that reduces the effort of content creation. This makes the content creation process smoother.
■Recommended for ・Bloggers and content creators who tend to spend a lot of time creating blog posts ・Those who want to efficiently manage content by integrating ChatGPT and WordPress ・Those who regularly update blogs but struggle with coming up with article ideas ・Web marketers who want to improve efficiency by utilizing automation
■Notes ・Please integrate Yoom with both ChatGPT and WordPress. ・To execute ChatGPT (OpenAI) actions, a paid OpenAI API plan is required. (Payment must be possible when the API is used) https://openai.com/ja-JP/api/pricing/ ・The use of ChatGPT's API is provided by OpenAI for a fee, and it is a pay-as-you-go system based on tokens during API communication. Therefore, please be aware that an error will occur if payment cannot be made when using the API.
■Overview This workflow automatically summarizes documents uploaded to OneDrive using ChatGPT and saves the results back to OneDrive. It is an optimal business workflow for those who want to efficiently organize and utilize a large volume of materials.
■Recommended Users for This Template Business professionals managing a large number of documents who need efficient summarization IT personnel using OneDrive who want to automate the summarization process Project leaders who want to facilitate smooth information sharing within the team
■Notes ・Please integrate both OneDrive and ChatGPT with Yoom. ・The trigger can be set to activate at intervals of 5, 10, 15, 30, or 60 minutes. ・Please note that the shortest activation interval varies depending on the plan. ・There are consumer plans and general business plans (Microsoft365 Business) for Microsoft365 (formerly Office365), and if not subscribed to a general business plan, authentication may fail. ・To execute ChatGPT (OpenAI) actions, a paid OpenAI API plan is required. (Payment must be ready when the API is used) https://openai.com/ja-JP/api/pricing/ ・Use of the ChatGPT API is provided by OpenAI on a paid basis, with metered billing based on tokens used during API communication. Therefore, an error will occur if payment cannot be made when using the API, so please be cautious. ・AI operations for OCR or voice transcription are only available with Team Plan and Success Plan. For Free Plan or Mini Plan, flowbot operations configured will result in errors, so please be aware. ・Paid plans such as Team Plan and Success Plan offer a two-week free trial. During the free trial, you can use restricted applications and AI functions (operations).
If you’re interested in automating using ChatGPT, try out the templates we’ve introduced :) You can set up processes that handle summarizing meeting minutes, messages from chat tools, and responses from forms, all without manual effort.
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!
In today's era where the number of tools is constantly increasing, it can often be confusing to decide which ones to use. We aim to provide clear and useful information to make your work a little easier!
.avif)
