When an email arrives, have a conversation with ChatGPT and link it to Google Sheets to record the content.
■Overview
This flow involves conversing with ChatGPT based on the content of an email when it arrives and recording the details in a Google Spreadsheet.
■Recommended for
1. Those who handle multiple tasks at once, such as inquiry responses and information dissemination
・Customer service department personnel handling customer inquiries
・Managers in charge of overseeing companies with many branches
・Professionals such as social insurance labor consultants or tax accountants with advisory contracts
2. Those looking to reduce manual input tasks by utilizing AI technology
・Individuals who want to save effort in information search and data analysis using ChatGPT
・Office managers interested in workflow automation
3. Those who want to reduce manual input tasks and automate processes
・Owners of small and medium-sized enterprises aiming for business automation
・Office staff looking to improve data accuracy
■Benefits of using this template
・By automatically creating a Google Spreadsheet with the conversation content from ChatGPT, you can reduce manual work and improve operational efficiency.
・By transcribing the content to a Google Spreadsheet using ChatGPT, you can later edit or add to the responses on the spreadsheet. Additionally, by adding operations, you can create email responses or share the response content elsewhere.
■Important Notes
・Please integrate both ChatGPT and Google Spreadsheet with Yoom.
・Using ChatGPT or OpenAI's API may incur additional costs payable to OpenAI. Please check OpenAI's official website for details.
・AI operations are features available only in the Team Plan and Success Plan. In the case of Free Plan or Mini Plan, the operations set in the flow bot will result in errors, so please be aware.
・Paid plans such as the Team Plan and Success Plan offer a two-week free trial. During the free trial, you can use restricted apps and AI features (operations).
Create a reply to the received email using ChatGPT and notify the specified Slack channel.
The minutes added to the database will be summarized using ChatGPT, and a notification will be sent to the specified Slack channel.
# Translated Text After a meeting on Google Meet, ChatGPT automatically creates the minutes, translates them into multiple languages using DeepL, and shares them via email. This workflow eliminates the hassle of creating minutes and handling multiple languages, thereby improving team communication efficiency.
Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.
This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.
You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.
Create a reply to the received email using ChatGPT and notify the specified Slack channel.
The minutes added to the database will be summarized using ChatGPT, and a notification will be sent to the specified Slack channel.
# Translated Text After a meeting on Google Meet, ChatGPT automatically creates the minutes, translates them into multiple languages using DeepL, and shares them via email. This workflow eliminates the hassle of creating minutes and handling multiple languages, thereby improving team communication efficiency.
Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.
This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.
You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.
When a message is created in a thread
When a row is added
When a row is updated
Generate Text
Generate text (with image)
Generate Text (Advanced)
Generate Text (Web Search)
Generate Text from Image URL
Convert text to audio file
Retrieve model list
Create thread
Add message to thread
Convert audio file to text (file upload)
Set a value in a cell
Get values
Clear values
Create a new spreadsheet
Copy a sheet (tab)
Add a new sheet (tab)
Delete Sheet (Tab)
Replace values
When a message is created in a thread
Generate TextGenerate text (with image)Generate Text (Advanced)Generate Text (Web Search)Generate Text from Image URLConvert text to audio fileRetrieve model listCreate threadAdd message to threadConvert audio file to text (file upload)
When a row is addedWhen a row is updated
Set a value in a cellGet valuesClear valuesCreate a new spreadsheetCopy a sheet (tab)Add a new sheet (tab)Delete Sheet (Tab)Replace valuesUpdate Sheet NameDelete RowsGet Spreadsheet InfoGet sheet namesApply a formula to a rangeEnter values in a rangeEmbed an image in a cellSort by specific columnHide a sheetAdd a note to the specified cellsInsert columnsDelete columnsWrite values to multiple columns
