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/ja/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/ja/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/ja/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/ja/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/ja/articles/8687581