Google Sheets in scenarios: leads, customer lookup and statuses in your spreadsheet
Plenty of teams keep leads in a Google Sheet and copy them over from chats by hand. In AISAR a scenario does it: a lead from WhatsApp, Telegram or Instagram lands as a new row right away, the bot finds the customer by phone number and replies with data from the sheet, and the status in the row changes once the customer confirms. AISAR sees only the spreadsheets you created through it or picked yourself; the rest of your Google Drive stays out of reach. 7 days free.
Updated: November 16, 2026. By the AISAR team
How to connect Google Sheets to AISAR
Four steps, no developer and no third-party connectors.
- 1
Connect a Google account
In the AISAR workspace open "Settings", "CRM and integrations", "Google Sheets" and sign in to Google. Google asks for permission only to the files you create in AISAR or pick yourself. You can connect several accounts.
- 2
Create a spreadsheet or pick your own
A new spreadsheet is created right from AISAR, with column names in the first row. An existing one is picked in the Google Drive window, and AISAR loads its sheets and columns.
- 3
Add a block to a scenario
In the builder pick "Add row", "Find row" or "Update row", choose the spreadsheet and sheet, and map columns to data: phone number, name, the customer's answers or scenario variables.
- 4
Run it and check
A test run writes to the spreadsheet for real, and the row number shows up in the run history. From then on the scenario runs by itself on every new lead.
What the blocks do
The spreadsheet becomes part of the scenario, not a place someone copies leads into at the end of the day.
Leads pile up in the sheet on their own
The "Add row" block writes a new row at the end of the sheet: the customer's name and phone number, the channel, answers to the bot's questions, any scenario variables. Columns you skip stay empty, and the row number is kept for the next steps.
Answers based on the data in the sheet
The "Find row" block looks up a customer by phone number or any value in a column and puts the cells of the matching row into variables. The bot then tells the customer their booking time, order status or bonus balance by itself. Phone numbers are compared digit by digit, so +7 701 and 8 701 match the same row.
Statuses change without a manager
The "Update row" block changes the cells you choose in a row found by a search or whose number is already known. The customer confirms the booking in the chat, and the sheet says "Confirmed" right away. If there is no such row, the block can add it.
Access only to the sheets you need
AISAR uses Google's narrowest permission: only the spreadsheets created through AISAR or picked by you. Customer text is written as plain text, and formulas from messages never run. If Google is briefly unavailable or hits its request limit, the scenario waits and carries on by itself.
Built-in blocks vs an external connector
| Criterion | AISAR + Google Sheets | External connector |
|---|---|---|
| Where you set it up | In the AISAR scenario builder | In a separate service, via webhooks |
| Access to Google Drive | Only the spreadsheets you pick or create | Often every spreadsheet in the account |
| Pricing model | Included in the Business plan | A separate subscription, often with an operations cap |
| Replying with data from the sheet | Yes, in the same scenario | Needs a separate link back to the chat |
| Google outage or rate limit | The scenario waits and carries on | Depends on the service |
What Google data AISAR sees
In short: what AISAR can access in Google, and what it never does with that data.
What AISAR is
AISAR is an omnichannel platform for businesses: customer conversations from WhatsApp, Telegram, Instagram and other messengers in one inbox, a CRM with deals, and automation scenarios.
Access only to your spreadsheets
The Google Sheets integration works only with the user's permission: AISAR gets access only to the Google spreadsheets the user created through AISAR or selected themselves (the drive.file scope), so that their company's scenarios can add, find and update rows. The rest of the user's Google Drive is not accessible to AISAR.
What AISAR never does with Google data
AISAR does not use Google APIs or Google user data to create, generate or distribute AI-generated non-consensual intimate imagery (NCII) or any other sexual content.
Privacy Policy and Limited Use
What Google data AISAR receives, how it is stored and how to revoke access is described in the "Data received from Google" section of our Privacy Policy. AISAR's use and transfer to any other app of information received from Google APIs will adhere to the Google API Services User Data Policy, including the Limited Use requirements.
The Business plan: scenarios, 3 channels and 5 users included, Google Sheets blocks at no extra cost. The price recalculates in ₽/$ with the currency switcher on the page.
A step-by-step setup guide is in the docs: docs.aisar.app, "Connecting Google Sheets"
Frequently asked questions
What people ask before connecting Google Sheets to AISAR.
No. AISAR asks Google for a single permission: access to the files created through AISAR or picked by you in the Google Drive window. Your other files, email and contacts stay invisible to it. From connected spreadsheets AISAR stores the title, the sheets and the first row with column names, and reads cells only when a scenario step needs them.
Yes. For example, the owner's personal account and a shared sales team account. In each scenario block you choose which account and which spreadsheet it works with.
It lands in the cell as plain text. AISAR writes values as they are, without parsing formulas, so a string like "=IMPORTXML(…)" does nothing in the sheet. Your own formulas can stay in the spreadsheet as before, in neighbouring columns for example: AISAR leaves them alone.
On a brief outage or when Google's request limit is hit, the scenario doesn't drop the lead: it waits and retries the step after 30 seconds, 2 minutes and 10 minutes. If Google still doesn't answer, the scenario takes the "Failed" exit and you see the reason in the run history. If access to the account was revoked, AISAR shows it on the connection page and offers to reconnect.
With the "Disconnect" button under "Settings", "CRM and integrations", "Google Sheets". AISAR revokes the access at Google itself and deletes the connection keys, while the spreadsheets stay in your Google Drive as they were. You can also revoke access in your Google account settings.
There is no separate charge: the blocks work wherever scenarios are available, that is, on the Business plan (20 000 ₸ a month, 3 channels and 5 users). No external connector subscription is needed.
Leads in your Google Sheet, starting today
Connecting a Google account takes a couple of minutes. 7 days free, no card required: build your first scenario and watch the rows appear on their own.
Try it for free