■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
.avif)
