Connect

Google Sheets

ProductivityOAuthGoogle Sheets developer docs ↗

Google Sheets connects through the standard Google OAuth flow. You authorize Modiva on Google's own consent screen — Modiva can then read, write, append and bulk-update spreadsheet values and create new spreadsheets through one unified API and MCP server. It uses the privacy-preserving drive.file scope: Modiva only sees spreadsheets it created or ones you explicitly opened with it, never your whole Drive. Google access tokens are short-lived; Modiva refreshes them automatically.

Before you start

A Google account.
Access to the spreadsheets you want to automate.

Step-by-step setup

1
Sign in to Modiva
Log in at modiva.ai and open the Dashboard. You need a Modiva account before you can connect any platform — creating one takes a minute and no credit card is required for the free tier.
The Modiva dashboard — your home for connections, posts and analytics.
2
Open Connections → New connection
In the left sidebar choose Connections, then click New connection. You'll see the full catalogue of platforms grouped by category (Social, Ads and CRM).
The connection picker. Use the search box or category filter to find your platform.
3
Select Google Sheets
Click the Google Sheets card. Modiva redirects you to Google Sheets's official sign-in and permission screen — your password is entered on Google Sheets, never on Modiva.
Click Connect on the Google Sheets card to start the secure OAuth flow.
4
Authorize Modiva on Google Sheets
Review the permissions Modiva is requesting and approve them. If you manage more than one account, page or profile, pick the one you want Modiva to manage.
Google Sheets's consent screen. Approve the requested scopes to continue.
5
You're connected
Google Sheets now sends you back to Modiva and the connection appears with a green Connected status. From here it's available to every MCP key and API call in your workspace.
A healthy connection shows a green dot and the connected account name.

Permissions Modiva requests

When you connect Google Sheets, Modiva asks only for the access it needs to run the tools you use. You can revoke it any time from Google Sheets or by disconnecting in Modiva.

Read & write your spreadsheets
Access only files you create with or open in Modiva (drive.file)
Create new spreadsheets and tabs
Stay connected by refreshing access tokens

Troubleshooting & FAQ

Where is my Google Sheets password stored?

Nowhere. You sign in on the provider's own site and Modiva only receives a scoped access token, which is encrypted at rest with AES-256-GCM. Modiva never sees your password.

My connection says Expired or Error — what do I do?

Open Connections, find the platform and click Reconnect (or Refresh token). Providers periodically expire tokens or revoke them when you change your password; reconnecting re-runs the consent screen and restores access.

How do I disconnect?

Open Connections, click the Google Sheets row and choose Disconnect. Modiva deletes the stored token immediately. You can also revoke Modiva from inside Google Sheets's own app settings.

Why doesn't Modiva list all my spreadsheets?

Modiva uses the drive.file scope, which only exposes files created by Modiva or ones you've explicitly opened with it — your wider Drive stays private. Create the sheet through Modiva, or paste an existing spreadsheet's id/URL into the tool call.

Can Modiva delete my files?

The tools read, write, append and clear values, and create spreadsheets and tabs. There is no file-deletion tool, and clearing a range keeps the sheet and its formatting.