Integration, updated 16 Nov 2026

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. 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. 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. 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. 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

CriterionAISAR + Google SheetsExternal connector
Where you set it upIn the AISAR scenario builderIn a separate service, via webhooks
Access to Google DriveOnly the spreadsheets you pick or createOften every spreadsheet in the account
Pricing modelIncluded in the Business planA separate subscription, often with an operations cap
Replying with data from the sheetYes, in the same scenarioNeeds a separate link back to the chat
Google outage or rate limitThe scenario waits and carries onDepends 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.

20 000 ₸ / mo

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.

7 days free

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