Make your bots more relevant, useful and powerful with our new Google sheets integration. Connect to Google sheets at any point to:
- Get data
- Insert a row
- Update a row
Get data from Google sheets
Search Google Sheets for a matching record and use the data returned as a variable in your bot.
This can open the door to tons of useful use cases, for example, we can ask the lead to insert their order ID and we return the order status.
To see the steps how to do get data from Google sheets, check out our help doc
Insert a row in Google sheets
Capture information during your conversation and store that data in your Google sheet by inserting a new row.
Example: adding a new row for the visitor's name.
To see the steps how to add rows in Google sheets, check out our help doc
Update a row in Google sheets
Update existing records in Google Sheets with new data captured in Continually. This can be useful to update certain info about some leads or change info about that lead in your sheet.
Example: look up a visitors email and update the row, adding their name to another column.
To see a full example and the steps on how to update rows in Google sheets, check out our help doc