Click "Try this template".
Click "OK" and give the Flowbot a name to recognize.
This template will be copied to your “My Project”.
Step 3: Form Trigger
Click the Form Trigger action item.
Create your form. Since our goal is to analyze survey results, enter the survey questions and click "Next".
If you want to gather any additional information besides the questions already entered, feel free to add those questions.
Enter the "Retrieved Value".
Set sample values for the form responses. Once you’ve entered them, click "Save".
📚 References: For more details on how to set up a form trigger, you can refer to the full guide here.
Step 4: Generate Content with ChatGPT
Next, click on the ChatGPT action item.
Give your action a title (optional). Check the pre-configured settings, then click “Next”.
Let’s create an instruction to ChatGPT.
Select the retrieved values from the form in the previous step. Choose the inquiry content you want to analyze with ChatGPT.
Below are optional settings you can set up.
- Role: Set the role of the entity (default: 'user'). It determines how ChatGPT responds, helping set the context for the interaction.
- Temperature: Set a value between 0 and 2. A higher value (e.g., 0.8) generates more creative and varied responses, while a lower value (e.g., 0.3) produces more focused and consistent outputs. It can be left blank.
- Maximum token count: A token is a unit of text (such as words or punctuation) that indicates the amount of text the model can process at once. It can be left blank.
- Model ID: Select the model to be used for generating texts (default, 'gpt-4o'). Different models may affect the quality and style of the output.
Once you’re finished with the setting, click “Test”.
If the test is successful, save it.
Step 5: Set Up Google Sheets Action
Let’s set up the final action. Click on the Google Sheets action item.
Change the title (optional) and confirm the pre-configured settings. Then click “Next”.
Select the Spreadsheet ID (where you want to add a record) from the displayed options.
Then, specify the Worksheet Tab Name and Table Range. Then click “Next”.
📚 Reference: For more details on table range settings, check this guide.
Use the retrieved value to specify the values to add to Google Sheets.
By selecting the generated response from ChatGPT in step 4, you can save ChatGPT’s response directly into Google Sheets.
Once you’re done with the settings, click “Test”. If the test is successful, click “Save”.
Step 6: Activate the Flowbot
Toggle the "Trigger On" button to activate your flow! Check if the Flowbot you set up is working properly.
That's it! Your Flowbot is ready 😊
.avif)
.avif)
.avif)
