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

# Google Sheets

> Connect Google Sheets to your Macaly account

Google Sheets is Google's cloud-based spreadsheet tool for data and real-time collaboration. Connect your account once and the agent can read and write your spreadsheets directly, or use them to power dashboards and forms inside your project.

<Callout icon="user">
  Available on all plans
</Callout>

## Why connect Google Sheets

* **Turn form submissions into spreadsheet rows.** When someone signs up on your site, the agent appends their details as a new row in your Google Sheet automatically.
* **Build a dashboard on top of your data.** Read a sheet like your sales tracker and turn it into charts and totals inside your project, always current with what's in the sheet.
* **Update spreadsheets from the chat.** Create a sheet, find a row, or update its status without opening Google Sheets.

## What you need

* A **Google account** with Google Sheets. Sign in at [sheets.google.com](https://sheets.google.com) if you don't already have one.

## Connect Google Sheets to Macaly

<Steps>
  <Step title="Open Settings">
    Go to **Settings → Integrations** in your Macaly workspace.
  </Step>

  <Step title="Connect Google Sheets">
    Find the Google Sheets card in the list of apps and click the **Connect** button.
  </Step>

  <Step title="Authorize your account">
    A new window opens, where you'll be asked to sign in to Google. Once you approve access, you'll be redirected back to Macaly.
  </Step>
</Steps>

## Use Google Sheets from the chat

Once connected, describe what you want and the agent handles the rest.

Turn submissions into rows automatically:

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

Build a dashboard on your data:

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

Update spreadsheets 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".
```

## What the agent can do in Google Sheets

Create sheets and read values from any range, append, update, and upsert rows, search, find-and-replace, sort, and filter, insert, delete, hide, or resize rows and columns, apply formatting and data validation, and create and update charts.

## Good to know

* **You connect once.** Every project in your workspace reuses the same Google Sheets connection.
* **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. You can disconnect Google Sheets anytime from **Settings → Integrations**.