← Back to Documentation

Google Sheets

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

Setup

Connect the Google Sheets toolkit to your Google account.

Prerequisites

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

Setup Steps

Step 1: Connect to Google

1. Navigate to your MCP server panel in the toolforest.io dashboard
2. Locate the Google Sheets toolkit
3. Click Connect
4. 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.

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: Open the Options Menu

In your MCP server panel, locate your connected toolkit and click the ⋮ (three-dot button) next to the Disconnect button.

Step 2: Request Additional Access

From the menu, select the option to Add Google Sheets.

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.

Managing Your Connection

Disconnect

To disconnect the toolkit:

1. Click the Disconnect button in your MCP server panel
2. toolforest.io will remove all stored access tokens

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