When there is a form response, use ChatGPT to categorize the response type and add it to a Google Spreadsheet.
■Overview
When a survey response is submitted to the Yoom form, ChatGPT is used to categorize the response type and add the information to a Google Spreadsheet.
This allows for centralized discrimination and data accumulation based on the form responses.
■Preparation
・Pre-registration (integration) with the app to be used is required. Below is a reference guide for integration.
※ There may not be a detailed guide available for apps that can be integrated simply. https://intercom.help/yoom/en/collections/3041779
・Prepare a spreadsheet in advance to accumulate application information.
※ The spreadsheet used for accumulation (view-only access. Please copy if you wish to use it.) https://docs.google.com/spreadsheets/d/1bluRKYuqY7oMyXdaQN3HezyanrlLJaYzryrUg-lS4pk/edit#gid=0
■Creation Method
① Select the form trigger, configure the settings below, and save.
・Each question item: Set necessary items such as name, contact information, and question content for the form.
・Acquired values: You can enter demo values on the next page. Please enter demo values as they will be used in the subsequent test.
※ For detailed form settings, please refer here. https://intercom.help/yoom/en/articles/8009267
② Press the + mark under the trigger, select ChatGPT from the operations to integrate with the app, configure the settings below, and test/save.
・Action: Converse.
・Message content: Embed the inquiry content obtained in ① and instruct the following judgment.
・Role: Select the ChatGPT response role.
※ The default is user setting
・Temperature: Specify a value between 0 and less than 2. A higher value like 0.8 increases randomness, while a lower value like 0.2 makes it more focused and deterministic.
・Maximum token count: The maximum number of tokens allowed for the generated response. The default is 4096 tokens.
・Model: Select the ChatGPT AI model.
※ For embedding output, please refer here. https://intercom.help/yoom/en/articles/8223528
※ {{Inquiry content}}: Please review this text and determine "Sales" if it is sales-related, "Question" if it is question-related, and "Potential Spam" if it seems like spam.
③ Press the + mark, select Google Spreadsheet from the operations to manipulate the database, configure the settings below, and test/save.
・Execute action: Add a record.
・Spreadsheet ID: Click the field and select the pre-prepared spreadsheet from the options.
・Spreadsheet tab name: Click the field and select the target sheet from the options.
・Table range: Enter the target range including column names. In this example, it is set as A1:E.
・Values of the record to be added: Embed the output obtained in ① and the judgment result obtained in ② corresponding to the displayed column names.
※ For the definition of the Google Spreadsheet table range, please refer here. https://intercom.help/yoom/en/articles/8703465
■Notes
・The use of ChatGPT/OpenAI API is paid. Depending on your OpenAI plan, it may not be available, so please check your plan in advance. https://intercom.help/yoom/en/articles/8687581
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
