What it does
Integrates Google Sheets with Blip Builder via Google account login. From a flow, the bot can read values from a spreadsheet, search for a row by a value, and add new rows using data from the conversation.
Key features
- Read a range: returns the values from a specific range in the spreadsheet (by spreadsheet ID and range).
- Search for a row: looks up a value and returns the first row that contains it.
- Add a row: writes new data at the end of the spreadsheet, inserting a new row (interprets values as if typed by the user, respecting formulas and formats).
- Login with your Google account, with the option to switch accounts.
Requirements
- Google account with access to the spreadsheets you want to use.
- Sign in with Google in the extension settings and grant the spreadsheets permission.
- Install the Builder browser extension, indicated on the settings screen.
Benefits
- Centralizes data in spreadsheets your team already uses, without migrating to another tool.
- Query and update data in real time directly from the conversation.
- Automatically records responses, leads, or service events in a spreadsheet.
- Reuses existing spreadsheets as a data source and destination for the bot.
Who it's for
Teams that use Google Sheets to organize data and want to read or write that information from chatbot flows.
Learn more
Documentation: https://bit.ly/ww-gsheets
