Automatically Send and Forward Chat Tool Data to ChatGPT
This flow starts with chat apps like Microsoft Teams and uses ChatGPT to summarize and organize the conversation content.
It makes it easier to review later or to transfer to another tool!
・
"Organizing meeting minutes takes a surprisingly long time..."
"It's tough to search through chat exchanges later..."
Don't you want to resolve these frustrations?
These issues might be solved by utilizing ChatGPT.
For example, by integrating Google Sheets with ChatGPT, you can summarize the content of meeting minutes with ChatGPT and automatically update Google Sheets.
This way, you can save the effort of summarizing and updating, and reduce your working time.
Additionally, you can summarize chat tool content with ChatGPT and automatically update Google Sheets.
This automation is especially recommended for when you want to review necessary information later.
In this article, we will explain automation using ChatGPT and how to set up automation!
Yoom offers templates for automating workflows using ChatGPT!
If you want to try it right away, click the banner below to get started!
There are various ways to automatically update data with ChatGPT. We've picked out a few methods for you to check out!
By clicking "Try it out" on the automation example that interests you and registering an account, you can immediately experience automatic updates with ChatGPT. Registration takes just 30 seconds, so feel free to give it a try!
This is a flow where data management apps like Google Sheets are used as a starting point to send data to ChatGPT for organization and summarization.
It saves the effort of reorganizing data, making it useful as a base for reports and document creation!
This flow starts with chat apps like Microsoft Teams and uses ChatGPT to summarize and organize the conversation content.
It makes it easier to review later or to transfer to another tool!
This flow starts with a form creation tool like Google Forms, summarizes the responses using ChatGPT, and automatically updates a Notion database.
It's useful when you want to quickly get an overview of collected opinions and requests or swiftly compile meeting minutes!
Now, let's create a flow to automatically update ChatGPT data!
This time, we'll use Yoom to proceed with the setup without any coding!
If you don't have a Yoom account yet, please issue one from the registration form here.
[What is Yoom]
This time, we will create a flow bot to organize and summarize meeting minutes created in Google Sheets using ChatGPT!
The creation process is broadly divided into the following steps.
First, log in to your Yoom account.
If you haven't used Yoom before, please check out Getting Started with Yoom.
1. Click on My Apps and then click on Add.
2. You can search by app name in the input field.
Let's register ChatGPT as My App!
To execute actions of ChatGPT (OpenAI), you need to subscribe to the OpenAI API paid plan (ensure you can make payments when the API is used).
The ChatGPT API is provided by OpenAI for a fee, and charges are incurred based on usage.
If you cannot make payments when using the API, it will result in an error, so please check in advance!
Enter "ChatGPT" in the input field, and the ChatGPT icon will appear. Click on the ChatGPT icon.
1. The following screen will be displayed.
Please enter your Account Name and Access Token.
For detailed instructions on registering My App, please refer to the following link.
How to Register ChatGPT as My App
Similarly, search for Google Sheets and click on the icon.
1. The following screen will appear.
Click on "Sign in with Google".
2. Select the account to integrate.
When you click on the account, you may be asked for additional access.
Review the content, and if there are no issues, complete the setup.
When My App registration is successful, the following screen will be displayed.
Check if the icons for ChatGPT and Google Sheets are displayed on the My Apps screen.
Click on "Try it" from the link below.
If the following message appears, the template copy was successful.
The copied template will be stored in My Projects.
First, click the "When a row is added" icon at the top.
Set the account information to link with Google Sheets.
Select "When a row is added" as the trigger. Once the setup is complete, click "Next".
Let's configure each item!
For this setup, we have 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 retrieved value as shown below.
If you're curious about the details of the retrieved value, check the link below.
About the Retrieved value
Don't forget to click "Save" after the test is complete!
Next, click the "Summarize" icon.
Set the account information to link with ChatGPT.
Select "Generate Text" as the action.
Once the setup is complete, click "Next".
Configure each item.
When you click the edit field for Message Content, the retrieved value from Google Sheets will be displayed as shown below, so make use of it when setting up!
Additionally, settings such as temperature and maximum token count are not mandatory, but if you wish to change them, refer to the annotations while entering the values.
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.
Select "Update record" as the action.
Database Integration will be set up.
Conditions for the record to update will be set.
In this case, the condition is the meeting number, which serves as the unique key.
Values for the updated record will be set. In this flow, we want to transcribe the summarized content from ChatGPT into Google Sheets, so we will quote the ChatGPT output in the minutes summary section.
Once the setup is complete, click "Test"!
If the test is successful, the summarized content from ChatGPT should be transcribed into the minutes summary column in Google Sheets.
Once confirmed, don't forget to click "Save"!
Congratulations! All settings are now complete.
Once the setup is complete, the following screen will be displayed.
Click "Turn on Trigger" to activate the flow bot.
This is how you can organize and summarize meeting minutes created in Google Sheets using ChatGPT and update them!
You can organize the content entered in a form and create a draft article directly from it.
You can also automatically create and send guide emails based on a list, and even automatically reply to received emails!
If you are interested in automation using ChatGPT, please try the templates we introduced.
In particular, automating the summarization of meeting minutes triggered by Google Sheets, chat tool summaries, and summaries of Google Form responses will free you from manual summarization.
<span class="mark-yellow">Tasks that used to be time-consuming can be significantly shortened, allowing you to focus on other tasks.</span>
With this automation, the database data is also automatically updated, eliminating the need for manual entry.
If you are interested in automation using Yoom, please create a free account from here.
Registration is simple and can be done in about 30 seconds, so you can set it up between tasks!
These automations can be easily implemented with no code, so please take advantage of them.
.avif)
.avif)
