Connect a Google account with one approval on Google's own screen — no passwords or API keys. Read Google Sheets now; Drive export and Gmail sending follow. Paid plans.
Endpoints (5)
Start connecting a Google account. Returns authorize_url: give it to the user as a clearly labelled "Connect Google" link or button. The user approves on Google's own screen and the tokens are stored automatically — never ask the user for a password or secret. The link is single-use and expires after 10 minutes. Paid plans only.
| Field | Type | Required | Description |
|---|---|---|---|
capabilities |
array | ✓ Yes | What the connection may do. Available now: ["sheets_read"]. |
return_url |
string | No | Optional page on a websitepublisher.ai domain to return to after approval. |
Whether Google is connected for this project: account email, granted capabilities, and what to do when re-authorization is needed.
No input parameters required.
Disconnect Google: revokes access at Google and deletes the stored tokens.
No input parameters required.
Spreadsheet title and its tabs (name, rows, columns). Requires capability sheets_read.
| Field | Type | Required | Description |
|---|---|---|---|
spreadsheet |
string | ✓ Yes | Google Sheets URL or spreadsheet ID. |
Read rows from a tab or A1 range, max 5000 rows per call. Requires capability sheets_read.
| Field | Type | Required | Description |
|---|---|---|---|
spreadsheet |
string | ✓ Yes | Google Sheets URL or spreadsheet ID. |
range |
string | ✓ Yes | Tab name ("Leads") or A1 range ("Leads!A1:F500"). |
max_rows |
integer | No | Cap on returned rows (default and maximum 5000). |
MCP Tool Names
When using this integration through an AI assistant (Claude, ChatGPT, Cursor, etc.), the endpoints are available as MCP tools:
| Endpoint | MCP Tool Name |
|---|---|
| connect | google_connect |
| connection-status | google_connection_status |
| disconnect | google_disconnect |
| sheets-get-meta | google_sheets_get_meta |
| sheets-read-range | google_sheets_read_range |
Website