Google Sheet blocks in a bot

The Google Sheet blocks let a bot read from and write to a spreadsheet without leaving the flow. Useful when a sheet is your working database.

What you can do

Store answers in real time as the customer replies, write each one to a row. Search a sheet for a value and reply with the matching record. Build dynamic buttons or lists from sheet rows so options update themselves when the sheet changes.

Row and cell operations

Beyond the basics there are blocks to create a spreadsheet, copy a sheet, get rows, look up rows, add or update a row, get or update a single cell, and clear or delete rows. Together they let a flow manage a sheet like a small database.