Google Sheets
Read and write data in Google Sheets spreadsheets.
Databaseoauthproxy
Connect Google Sheets
Google Sheets uses OAuth for authentication. Redirect your user to the login URL to start the authorization flow. After the user authorizes access, the callback is handled automatically.
# Redirect user to start OAuth flow
GET /auth/google_sheets/login?account_id=YOUR_ACCOUNT_ID&redirect_uri=https://your-app.com/callback
# Callback handled automatically at
GET /auth/google_sheets/callback
Make API Calls via Proxy
Use the proxy endpoint to make authenticated API calls to Google Sheets without managing tokens yourself. Calimatic Connect handles credential injection and token refresh automatically.
POST /connect/v1/proxy/google_sheets
# Headers
Authorization: YOUR_JWT_TOKEN
Content-Type: application/json
# Body
{
"method": "GET",
"path": "/me"
}
Check Status
Verify whether your Google Sheets connection is active and credentials are valid:
GET /connect/v1/providers/google_sheets/status
# Headers
Authorization: YOUR_JWT_TOKEN
Disconnect
Remove the Google Sheets connection and revoke stored credentials:
DELETE /connect/v1/providers/google_sheets/disconnect
# Headers
Authorization: YOUR_JWT_TOKEN