← Back to Documentation

Google Sheets

Automate and manage spreadsheets with comprehensive data manipulation, formatting, and analysis.

Tool Reference: 71 tools with full schemas →

Setup

Connect the Google Sheets toolkit to one or more Google accounts.

Prerequisites

Before connecting Google Sheets, ensure you have configured an MCP server in your toolforest.io dashboard.

Setup Steps

Step 1: Connect a Google Account

1. Open Toolforest and go to Toolkits.
2. Select the Google Workspace tab.
3. Find Google Sheets.
4. Click Connect.
5. Choose the Google account you want this toolkit to use, or select Use another account.
6. You’ll be redirected to Google’s authorization page.

Important: The Google account you connect doesn’t need to match your toolforest.io email address.

Step 2: Authorize Permissions

Google will ask you to grant toolforest.io one permission:

• Create, edit, and delete files – Allows toolforest.io to manage files it creates.

Click Continue to grant this permission.

Step 3: Confirmation

After authorizing, you’ll be redirected back to toolforest.io with a “Successful connection” message. The toolkit status will now show Connected.

Step 4: Optionally Connect Additional Accounts

The first connected Google account is marked as the default account for this toolkit. If you want to use another Google account as well, click Manage accounts next to the toolkit, then choose Add another Google account.

When your AI assistant calls a Google Sheets tool, the default account is used unless the tool call specifies a different account.

Understanding Permissions

What toolforest.io Can Access

toolforest.io’s permissions are intentionally limited for your security:

• Files created by toolforest.io: Full access to create, edit, and delete
• Files you explicitly share: Access to files you select via Google Picker

Accessing Additional Files

Toolkits can only access files they create by default—use the Google Picker to grant access to additional files.

Step 1: Choose the Account

In your MCP server panel, locate the Google Sheets toolkit. If you have multiple Google accounts connected, decide which account should receive access to the selected files.

Step 2: Request Additional Access

Select the option to Add Google Sheets for that account.

Step 3: Confirm Permissions

An Additional Access dialog will appear explaining that the toolkit can only access files it creates by default. To grant access to additional files, click Continue.

Step 4: Sign In (If Required)

If you are not already signed into your Google account in the browser, you will be prompted to sign in before the Google Picker opens.

Step 5: Select Your Files

The secure Google Picker will open. Browse or search for the specific files you wish to authorize, then click Select.

Step 6: Confirmation

A “Files Added!” confirmation will appear. Click Done. Your AI assistant now has access to the selected files through that Google account.

Managing Your Connection

Disconnect

To disconnect the toolkit:

1. Click Manage accounts next to the toolkit
2. Click Disconnect for the Google account you want to remove
3. To remove every connected account for the toolkit, disconnect each account in the list
4. toolforest.io will remove the stored access tokens for disconnected accounts

Revoke Permissions

To fully revoke toolforest.io’s access to your Google account:

• Visit your Google Account permissions page
• Find toolforest.io and click Remove Access

Capabilities