Integrations / Spreadsheets
Connect Google Sheets to WhatsApp: sheets and spreadsheets by chat
Flann is an AI agent your business talks to on WhatsApp. Connect Google Sheets once, then ask Flann to look things up in it or get work done in it, by text or voice note. Contracts, menus, rotas, signed forms. They pile up in Google Sheets faster than anyone can keep them tidy, and the one you need is never where you left it. Flann reads Google Sheets for you, finds the right version and tells you what it says.
50 actions in Google Sheets. 17 only look things up, and 33 create, update, send or delete. You connect with a one-click sign-in.
What you can ask Flann to do in Google Sheets
Send any of these on WhatsApp, in your own words. Flann finds the right Google Sheets action and fills in the details from the conversation.
“Find spreadsheets in Google Sheets.”
“Show me my sheet names in Google Sheets.”
“Export the sheet as PDF from Google Sheets.”
“Add a sheet in Google Sheets.”
“Move the spreadsheet in Google Sheets.”
“Update the spreadsheet values in Google Sheets.”
What Flann can work with in Google Sheets
Google Sheets gives Flann 50 actions across 15 kinds of record. These are the ones you are most likely to use.
| Record | What Flann can do | Actions |
|---|---|---|
| Sheets | addcreatedeleteexportcopy | 5 |
| Spreadsheets | look upmovesearch | 4 |
| Charts | createdeletelook upupdate | 4 |
| Data validation rules | look upupdate | 2 |
| Dimensions | deleteadd | 2 |
| Spreadsheet values | look upupdate | 2 |
There are three ways to get sheets work done in Google Sheets. Side by side:
| Compare | In Google Sheets yourselfYou click through each job | A rules toolRuns the steps you wired up | Flann on Google SheetsYou ask, Flann does the clicking |
|---|---|---|---|
| Asking for something | Open the app and find the right page | Only what was wired up in advance | A WhatsApp message, typed or spoken |
| Finding answers about sheets | Filters and searches you run yourself | Only the look-ups someone built | 17 look-ups, answered straight away |
| Making changes | Typed in by hand | Run unchecked once built | 33 changes, made from a message |
| Google Sheets records | All of them, one screen at a time | Only the ones you wire up | 15 kinds, from one chat |
| Getting connected | Nothing new to set up | Someone builds and maintains each flow | One sign-in to Google Sheets |
YesPartlyNo
Step by step: Google Sheets jobs you can hand to Flann
Each step below names the Google Sheets action Flann actually runs.
Create a sheet from a voice note
- You message Flann on WhatsApp: “Create a sheet in Google Sheets with these details.”
- Flann runs
Export Sheet as PDFin Google Sheets and shows you what it found. - Flann runs
Create a Google Sheetin Google Sheets. - Flann creates it in Google Sheets and confirms in the chat.
Fix a spreadsheet without opening Google Sheets
- You message Flann on WhatsApp: “Change the spreadsheet in Google Sheets: here is what is different.”
- Flann runs
Search Spreadsheetsin Google Sheets and shows you what it found. - Flann runs
Move Spreadsheet to Folderin Google Sheets. - Flann makes the change in Google Sheets and confirms in the chat.
Clean up charts you no longer need
- You message Flann on WhatsApp: “Which charts in Google Sheets are out of date? Remove the ones I confirm.”
- Flann runs
List Charts in Google Sheetsin Google Sheets and shows you what it found. - Flann runs
Delete Chart from Google Sheetsin Google Sheets. - Each removal is confirmed in the chat.
Repetitive Google Sheets work Flann takes off your plate
These are the jobs that come back every day or every week. Message Flann instead, and keep the decisions for yourself.
Chasing the unsigned agreements
Today
Every week a few agreements sit unsigned in Google Sheets. Working out who has not signed, and writing a polite nudge to each person, quietly eats the end of your Friday afternoon.
With Flann
“Which agreements in Google Sheets are still waiting for a signature?”
Open envelopes in Google Sheets come back as one list: who each is waiting on and how long it has been out. A short reminder is drafted for each signer, in the tone you use with customers and suppliers, and checked against what was already sent so nobody is nagged twice in a week.
What you stop doing: Keeping a mental list of who still owes you a signature stops being your job.
Updating the price list sheet
Today
When a supplier puts prices up, the change has to reach your price list in Google Sheets. Finding every affected row, retyping the figures and checking the margin column is fiddly work, and one slip means selling at a loss for weeks.
With Flann
“The wholesaler email has new dairy prices. Update every milk drink in the Google Sheets price list.”
Using the new figures from the email, Flann finds every row in Google Sheets that relies on dairy and works out the new cost and margin for each.
What you stop doing: Hunting down every affected row and retyping figures by hand is gone.
More on this: how to hand repetitive tasks to an AI agent on WhatsApp.
How Flann connects to Google Sheets
- Search for Google Sheets in Flann’s Connectors.
- Sign in to your Google Sheets account on the secure page that opens and allow access. There is no developer account or API key to set up.
- Go back to WhatsApp and ask for what you need. Flann chooses the Google Sheets action and fills in the details.
Look-ups run as soon as you ask and change nothing in Google Sheets. You can disconnect Google Sheets from Connectors at any time.
Ways to use Google Sheets with Flann
Summarise before you read
Ask what a long document says. Flann reads it in Google Sheets and gives you the points that matter.
Find it without searching
Ask for last month’s price list or the signed agreement. Flann searches Google Sheets and brings it into the chat.
Share without the hunt
Ask Flann for the file a customer needs. It finds it in Google Sheets so you can send it on.
Everything Flann can do in Google Sheets
The full list of Google Sheets actions available to Flann once you connect it.
Looks up 17
- Batch get spreadsheet
- Batch Get Spreadsheet Values by Data Filter
- Export Drive Spreadsheet
- Export Sheet as PDF
- Get Drive File Metadata
- Get sheet names
- Get Spreadsheet by Data Filter
- Get spreadsheet info
- Get spreadsheet values
- List Charts in Google Sheets
- List Drive Changes
- Search Developer Metadata
- Search Spreadsheets
- Aggregate Column Data
- Get conditional format rules
- Get Data Validation Rules
- Look up spreadsheet row
Changes 33
- Add Sheet to Existing Spreadsheet
- Append Dimension
- Append Values to Spreadsheet
- Batch Clear Spreadsheet Values
- Batch Clear Values By Data Filter
- Batch update spreadsheet values
- Clear Basic Filter
- Copy Sheet to Another Spreadsheet
- Create a Google Sheet
- Delete Dimension (Rows/Columns)
- Delete Sheet
- Find and Replace in Spreadsheet
- Insert Dimension in Google Sheet
- Move or Resize Chart in Google Sheets
- Move Spreadsheet to Folder
- Mutate conditional format rules
- Set Basic Filter
- Set Data Validation Rule
- Sort Range
- Update Dimension Properties (Hide/Unhide & Resize)
- Update Sheet Properties
- Update Spreadsheet Properties
- Update spreadsheet values
- Upsert Rows (Smart Update/Insert)
- Auto-Resize Rows or Columns
- Batch Update Values by Data Filter
- Clear spreadsheet values
- Create Chart in Google Sheets
- Create spreadsheet column
- Create spreadsheet row
and 3 more
More Spreadsheets apps Flann works with
Common questions
What can Flann do with sheets in Google Sheets?
Flann can add, create, delete, export and copy sheets in Google Sheets, using 5 actions (Add Sheet to Existing Spreadsheet, Create a Google Sheet, Delete Sheet, Export Sheet as PDF and more). Looking up runs straight away and changes nothing. The other actions create or change sheets in Google Sheets.
What can Flann do with spreadsheets in Google Sheets?
Flann can look up, move and search spreadsheets in Google Sheets, using 4 actions (Get Spreadsheet by Data Filter, Get spreadsheet info, Move Spreadsheet to Folder, Search Spreadsheets). Looking up runs straight away and changes nothing. The other actions create or change spreadsheets in Google Sheets.
How does Flann connect to Google Sheets?
Open Connectors in Flann, choose Google Sheets and sign in to your Google Sheets account on a secure page. There is no developer account or API key to set up. Once it is connected, Flann can use 50 actions in Google Sheets.
Can I use Google Sheets from WhatsApp?
Yes. You talk to Flann on WhatsApp or in the Flann app, by text or voice note, and Flann works in Google Sheets for you. You do not need to open Google Sheets.
Is Google Sheets included in my Flann plan?
Yes. Every Flann plan includes every app, Google Sheets included.