Google Sheets

Read from and (optionally) write to your Google Sheets — pull data into reports, or push results back out. Only the sheets you explicitly add are accessible.

Prerequisites

Connecting Sheets

1. On your dashboard, open the Google Sheets card and authorize.
2. Paste the URL of each sheet you want to make queryable — only these are accessible.
3. In Claude, add https://mcp.syncmetrics.io and sign in with the same account.

What you can do

Read

List your added sheets, inspect their structure, read any range and search across the content.

Write

Append rows, update ranges and create new tabs — useful for exporting a report Claude just built back into a sheet.

Tools

list_my_google_sheets	Your added sheets.
get_google_sheet_metadata	Tabs, dimensions, structure.
read_google_sheet_range	Read a range of cells.
search_google_sheet	Find content within a sheet.
append_google_sheet_rows	Add rows to a sheet.
update_google_sheet_range	Write values to a range.
create_google_sheet_tab	Add a new tab.

Example prompts

• Read the “May Budget” tab and tell me where I'm over.”
• Export last month's Meta campaign report into a new tab in my Reporting sheet.”