conscious-sapphire•2y ago
Capturing the script to a google sheet
Hi, here in my QnA intent, I want to be able to record all the user and bot responses when the intent is triggered and eventually send it to a google sheet. any idea on how to do that.
here is a screenshot for more context. Thanks
3 Replies
To record both user and bot responses in your QnA intent and send them to a Google Sheet, you'll need to use the Capture Step in Voiceflow. Here's a simplified process:
- Use the Capture Step to record the entire user reply or specific entities within the user's response. This allows you to capture and store the user's utterance in a variable.
- After capturing the user's response, you can further process or store this information by integrating with external services like Google Sheets or AirTable through API calls.
- For sending data to Google Sheets, you would typically use an API block configured to make a POST request to a web service that interfaces with Google Sheets. This might involve setting up a Google Apps Script as a web app or using a third-party service that provides an API for Google Sheets.
- Ensure you have the necessary variables created to store user and bot responses. These variables can then be included in the API request body to be sent to Google Sheets.
Remember, the integration with Google Sheets would require some setup outside of Voiceflow, such as configuring the Google Sheets API or setting up a web service that can accept POST requests and interact with Google Sheets on your behalf.
For more detailed guidance on capturing user input and working with APIs in Voiceflow, you can refer to the following resources:
- Capture – Voiceflow
- Airtable Integration – Voiceflow
conscious-sapphireOP•2y ago
i used this idea already. what i need to further improve is if they decided to ask many questions instead of one to be saved in one variable. how to capture all the interaction from asking questions by the user to the bot responding to each on of them.
You can use the vf_memory built in variable which stores the last 10 user & ai responses.