Google Sheets

1. Go to the Google Cloud Console

   • Visit https://console.cloud.google.com/.
   • Log in with your Google account.

2. Create or Select a GCP Project

   • In the top menu, select an existing project or click on the project dropdown and choose "New Project" to create one.

3. Enable Necessary APIs

   • Navigate to “APIs & Services” > “Library.”
   • Search for and enable:
     • Google Sheets API
     • Google Drive API

4. Create a Service Account (Recommended for Automation)

   • Go to “IAM & Admin” > “Service Accounts.”
   • Click + CREATE SERVICE ACCOUNT.
   • Enter a name (e.g., mcp-sheets-service) and description.
   • Click "Create and Continue."
   • Grant this service account access to project:
     • Add the Editor role (or more granular, e.g., “Drive File” and “Sheets” roles for stricter permissions).
   • Click "Continue" then "Done."

5. Download the Service Account JSON Key

   • In the service accounts list, find your newly created account.
   • Click the three dots under “Actions” and select “Manage keys.”
   • Under the "Keys" tab, click ADD KEY > "Create new key" > choose JSON > CREATE.
   • The JSON key file will download. Save this file securely.

6. Create and Share a Google Drive Folder

   • Go to Google Drive.
   • Click "+ New" > "Folder" and give it a name (e.g., "AI Managed Sheets").
   • Open the folder and copy the Folder ID from the URL:
     For example, in https://drive.google.com/drive/folders/THIS_IS_THE_FOLDER_ID, THIS_IS_THE_FOLDER_ID is the value you need.
   • Right-click the folder > "Share" > enter the service account’s email (found in your JSON key under client_email).
   • Grant Editor access, uncheck "Notify people," and click "Share."

7. Fill In Your Values In The FastMCP Connection Interface

   • Use your button (“Install Now”) to add environment variables.
   • Fill in the fields as follows:
     • SERVICE_ACCOUNT_PATH: Enter the path to your downloaded service account JSON key file.
     • DRIVE_FOLDER_ID: Enter the folder ID of the Google Drive folder you just created.

   (If using “CREDENTIALS_CONFIG” instead: Convert the content of your JSON file to Base64 and use that string, per advanced instructions in the README.)

8. Save and Connect

   • Complete the FastMCP server setup by saving/proceeding.
   • You are now ready to connect your client!

Note:

• Use the "Service Account" method for most server and automation scenarios.
• For detailed steps on OAuth or alternative methods, see the README sections above.
• If you get a “spawn uvx ENOENT” error on macOS, use the full path to uvx as described.