> ## Documentation Index
> Fetch the complete documentation index at: https://wl.macaly.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Sheets

> Create, read, and update spreadsheets in Google Sheets

Macaly connects to Google Sheets so the agent can work with your spreadsheets for you. Ask it to build a sheet, update some rows, or pull a range of data, or have it read and write your Sheets from the app you're building.

## What is Google Sheets?

Google Sheets is Google's cloud-based spreadsheet tool for data and real-time collaboration. With the Google Sheets integration, Macaly's agent works with your spreadsheets directly: it creates sheets, reads and writes data, builds charts, and brings spreadsheet data into your project.

## What you can do

A few examples of what the agent can do with Google Sheets:

* **Create and read spreadsheets.** Make a new spreadsheet, add sheets, and read values from any range, or look up and aggregate specific rows.
* **Write and update data.** Append rows, update or clear ranges, and upsert rows (update by key or add new ones).
* **Find and organize.** Search your spreadsheets, find-and-replace, sort and filter, and insert, delete, hide, or resize rows and columns.
* **Format and validate.** Apply cell formatting and conditional rules, and add data validation like dropdowns.
* **Visualize.** Create, update, and delete charts from your data.

## How it works

You describe what you want in the chat, and the agent handles the rest. Ask for a one-off task, or have the agent build Google Sheets right into your project.

**Ask the agent directly:**

```
Create a Google Sheet called "Budget 2026", add a "Q1" sheet, and
put my expense categories in column A.
```

```
In my "Leads" spreadsheet, find the row for Acme Corp and update
its status to "Won".
```

**Or build it into your app:**

```
Build a dashboard that reads my "Sales" Google Sheet and shows
the monthly totals as a chart.
```

```
I'm building a signup form. When someone submits, append their
name and email as a new row in my Google Sheet.
```

## Good to know

* **You connect once.** Authorize your Google account the first time, and the agent reuses that connection for later requests.
* **Edits change your real spreadsheet.** The agent writes to and clears cells in the actual sheet, so be specific about ranges.
* **Your account, your control.** The agent only acts when you ask it to, and you can revoke access from your Google Account settings at any time.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.