Skip to content

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.

How we write into your system without migrating it

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.

Before you start

What you need to connect Google Sheets

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