Skip to main content
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.
Available on all plans

​
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 if you don’t already have one.

​
Connect Google Sheets to Macaly

1

Open Settings

Go to Settings → Integrations in your Macaly workspace.
2

Connect Google Sheets

Find the Google Sheets card in the list of apps and click the Connect button.
3

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.

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