Integration · Automate and collaborate
Google Sheets and Meteor AI agents
Connect Google Sheets to a Meteor Met: read ranges, append rows, overwrite or clear cells and create tabs in your sheets, with your own Google account.
How does Google Sheets connect to Meteor?
Meteor connects to Google Sheets from its own card in Connections and gives your Met 6 tools over the sheets your Google account can open: read a range, append rows at the end without overwriting what was there, overwrite cells, clear content without touching the formatting, see the tabs and named ranges, and create a new tab. It lets an operating record, such as a WhatsApp lead or a weekly figure, land in the sheet your team already works in. It does not create new files or find sheets by name: it works on a sheet that already exists.
Reads and acts
What your Met can do in Google Sheets
What your Met reads and what it does in your own Google Sheets account, with nothing to migrate.
Reads
- Reads a range from a sheet
- Reads the tabs and named ranges of a sheet
Acts
- Writes to a range
- Appends rows at the end without overwriting what was there
- Clears the contents of a range without touching the formatting
- Creates a new tab
On top of that, you can switch off any action of this connector in each Met, and the connector refuses it even if the Met asks.
What it automates
What a Meteor Met does with Google Sheets
Every lead lands in the team's sheet
When a conversation ends in a qualified lead, your Met confirms the tab, checks that the contact is not already there and appends a row with the fields you defined.
A report that builds itself every week
Your Met pulls the figure from another connected system, shows it and appends it as the new week's row, without rewriting the previous ones.
Answer with what the sheet says
If your price list or your stock lives in a sheet, your Met reads the range and answers with that figure instead of answering from memory.
6 tools
Everything your Met can ask Google Sheets for
Each one is a real action in the connector. You can switch off the ones you would rather it never used.
| Tool | What it does |
|---|---|
sheets_get | Reads an A1 range as visible values or as unformatted numbers; the unformatted mode accepts up to 5,000 rows, 100 columns and 50,000 cells per finite range. |
sheets_append | Appends rows at the end of a range; by default it inserts new rows and overwrites nothing. |
sheets_update | Overwrites the cells of a specific range. By default it evaluates formulas; it can also store the literal value. |
sheets_clear | Clears the contents of a range without removing its formatting. |
sheets_metadata | Returns the tabs, the named ranges and the properties of the sheet. |
sheets_add_tab | Creates a new tab. If one with that title exists, it neither fails nor duplicates it. |
The limits
What the Google Sheets integration does NOT do
We would rather say it here than have you find out during rollout.
-
It does not create new spreadsheet files or find a sheet by its name. It needs the link or the id of a sheet that already exists; to search your drive you also need the Google Drive card.
-
It does not delete sheets or tabs and it does not change formatting. It can clear the contents of a range, which is not the same as deleting.
-
It offers no atomic write. Reading a row and writing it are two calls, so two writers at the same time could overwrite each other; that is why your Met reads before it overwrites.
-
It does not include the dedicated Mercado Libre weekly report writer, Search Console, PageSpeed or Classroom: those tools belonged to the single Google Workspace connection, which is not offered to new accounts today.
Before you start
What you need to connect Google Sheets
- 1
The Google Sheets card connected
In Met, open Connections → Google Sheets → Connect and authorize with your Google account. Authorization runs through a connection provider whose app Google has already approved; the token does not go through Meteor's servers and your password is never requested.
- 2
Access from that account to the sheet
The sheet has to belong to that account or be shared with it, with edit rights if your Met is going to write. Share the sheet link with your Met when you set up the task.
Frequently asked questions
Questions about Google Sheets and Meteor
Yes. Appending inserts at the end of the range by default and overwrites nothing. Changing cells that already hold data uses a different tool, and your Met shows you first what is going to change.
With this connection alone, no: it needs the link or the id. If you also connect Google Drive, your Met can search the file by name and then read or write it here.
Yes, and anyone who already has it connected still sees it. Since November 12, 2026 new accounts connect Google app by app: Gmail, Google Calendar, Google Drive and Google Sheets, each with its own card.
Yes. Your Met writes to a range, appends rows at the end without overwriting, clears cells and creates tabs in the sheets your Google account can access.
Yes. Every time a lead comes in on WhatsApp, your Met appends a row with their details at the end of the sheet your team already uses, without overwriting what is there.
Step by step
Automations that use Google Sheets
Complete tasks, with the steps and the tools that run at each one.
Automate and collaborate
Other integrations in the same family
Last updated
Want to see a Met running Google Sheets?
We will show you with your own account connected, not with a canned demo.