Google Sheets integration
Every answer, straight into the sheet your team already uses.
Read, add, update and clear rows from any chat, USSD menu or workflow — and start workflows when rows are added or changed.
- Works as
- ActionTrigger
- Connect with
- “Connect with Google”, in a few clicks.
- New and changed rows
- Checked for on a schedule you set, as often as every minute.
- For AI agents
- Give an agent Google Sheets as a tool, and it reads and adds rows itself.
Three ways to use it
Save, look up and start from the sheet.
Save what people tell you
Add a row for every registration, report or order, from a chat, a USSD menu or a workflow.
Look things up
Read rows to answer a question in the conversation — a schedule, a stock level, a list of who qualifies.
Start from the sheet
When a row is added or changed, start a workflow that messages the person on it or tells your team.
What teams build
The spreadsheet, wired into the service.
Save every report a field worker sends from a USSD menu as a row in the district’s sheet.
NGOs
Take the registration fee by M-Pesa when the form is sent, and add each paid registration to finance’s Google Sheet.
Government
When a name is added to the distribution list, send that person a WhatsApp message with their collection point.
NGOs
Answer “is my order ready?” from a sheet your warehouse team keeps up to date.
Enterprise
Post to the team’s Slack channel whenever a row’s status changes to urgent.
NGOs
Every Friday, email managers the week’s rows that are still open.
Enterprise
In Google Sheets
What the Google Sheets steps do.
Each one is a step on the canvas, or a tool an AI agent can use.
- Read
- Read rows, to answer a question or decide what happens next.
- Add
- Add a row.
- Update
- Update a row.
- Clear
- Clear a range.
- New rows
- Start a workflow.
- Changed rows
- Start a workflow.
Connecting it
Connected in four steps.
- STEP 01
Connect Google
Choose “Connect with Google” and allow access to your spreadsheets.
- STEP 02
Add a Google Sheets step
Choose the spreadsheet and the action, and match each column to an answer.
- STEP 03
Or start from the sheet
Add a Google Sheets trigger for new or changed rows, and choose how often to check.
- STEP 04
Test and publish
Try every path in the simulator, then publish.
Questions
Before you connect it.
Does it work with the sheets we already have?
Yes. Connect a Google account that can edit them, and choose the spreadsheet.
How quickly do new rows start a workflow?
The sheet is checked on the schedule you set, as often as every minute.
Should we use a data store instead?
Data stores keep records inside Buni.ai, with roles, exports and triggers of their own. Use Google Sheets when your team already works there.
Works well with
Create, read, update and delete records; new and changed records start workflows.
Send email and reply to it from any flow.
Create, update and cancel events, in the right time zone.
Bots for your own staff, messages posted from any flow, and Slack events that start workflows.
Connect your service to your spreadsheets.
Tell us what your team tracks, and we’ll show you the flow working with your sheet.