Google Sheets
In one line: Connect Google Sheets so your UnleashX agent can read rows, write updates, manage tabs, and track changes in your spreadsheets.
1. Overview
Google Sheets is Google’s spreadsheet service for storing structured data in rows, columns, and tabs. Once connected, your UnleashX agent can create and delete spreadsheets and sheets (tabs), read and write rows and cells, append or update data, clear ranges, delete rows/columns, and detect updates for trigger-style flows. Connecting Google Sheets to UnleashX turns spreadsheets into a live data backend for your agent: log new leads, update a status cell, or pull the latest rows into a prompt — all from natural language, with no manual copy-paste.2. What you’ll need
1
A Google account with Sheets
Any personal Google account or a Google Workspace account with Sheets enabled.
2
Permission to grant access
You must be able to complete the Google sign-in and approve the requested permissions.
3
An UnleashX agent
An agent in your UnleashX workspace where you’ll add the Sheets connector.
No admin access? On a managed Google Workspace account, your admin may need to allow UnleashX before authorization succeeds.
3. Get your credentials
Google Sheets uses Google OAuth 2.0. You do not create or paste an API key. UnleashX redirects you to Google, you sign in once, and Google issues an access token to UnleashX automatically.1
Start the connection in UnleashX
In your agent’s Data Connectors, find Google Sheets and click Connect (see Section 4).
2
Sign in with Google
Choose the Google account whose spreadsheets you want to connect.
3
Review and approve the requested scopes
Click Allow to grant access and return to UnleashX.
There is no key to copy. Access is granted by your Google sign-in and can be revoked anytime at your Google Account permissions page.
4. Connect on UnleashX
1
Open your agent
Sign in at https://www.tryunleashx.com and open your agent.
2
Go to Data Connectors
In the agent, open Data Connectors.
3
Find Google Sheets and connect
Locate Google Sheets and click Connect / Add / Configure.
4
Authorize with Google
Click Authorize, sign in with Google, and approve the requested permissions.
5
Confirm success
You’ll return to UnleashX and the connector status will show a Connected badge.
Use Google Sheets in a Workflow
Once connected, you can add Google Sheets to any automation from the Workflows builder. Its triggers and tools appear in the Apps panel, marked with an MCP badge.1
Add a trigger or action node
Open Workflows → New Workflow. On the canvas, click + Add Trigger (or the + below any node) to add a step.
2
Pick Google Sheets from the Apps panel
In the Paths panel, open the Apps tab and select Google Sheets. Use the search box if you have many connectors.
3
Choose a trigger or tool
Pick the trigger or action you want. Configure its fields — required fields are marked with a red asterisk (*).
4
Add or select your account
Under Selected account, choose an already-connected account, or click Add Account to connect one now.
5
Save and test
Fill in the remaining fields and click Save. Use Test to verify the step, then toggle Publish when the workflow is ready.
The steps are the same for every connector. For the full workflow builder guide, see Using MCP in Workflows.
5. Available tools
6. Example usage
“Add a new lead to the Leads tab: name Alice, email alice@acme.com, status New.” Runs List Sheets to confirm the tab, then Append Row.
“What’s in cell B3 of the Budget sheet, and set it to 5000.” Runs Get Cell, then Update Cell.
7. Permissions & data access
UnleashX can:- Read spreadsheet values, rows, and cells.
- Create and delete spreadsheets and sheets (tabs).
- Append, update, and clear rows, columns, and cells.
- Detect updates for trigger-style flows.
- Access Gmail, Calendar, or other Google services unless connected separately.
- Change your Google account settings or password.
- Edit spreadsheets you don’t have access to.
access-token header, a google_sheets_access_token header, or an Authorization: Bearer header, falling back to your UnleashX session), refreshed automatically when it expires.
8. Troubleshooting
For general connector issues, see /mcp/integrations.
9. Frequently asked questions
Does UnleashX store my spreadsheet data? No. It reads and writes through Google’s API in real time to fulfill your requests. Can multiple team members connect Sheets? Yes. Each person authorizes their own Google account. How do I find a spreadsheet ID? It’s the part of the URL between/d/ and /edit: https://docs.google.com/spreadsheets/d/{spreadsheet_id}/edit.