Google Workspace integration

Overview

Google Workspace is the umbrella for Gmail, Calendar, Drive, Sheets, and the rest of Google's productivity suite. The Automize Google Workspace connector covers the most common automation surface – read/send email, list/create events, read and update Sheets, list Drive files, manage Docs and Slides metadata.

• Regions: Google Workspace is global. No region selector – connector talks to googleapis.com. Data residency for Google Workspace itself is set at the tenant level via Google Workspace admin console.
• Plans: Any Google account – personal (gmail.com), Workspace (custom domain), Cloud Identity. Some endpoints (Admin SDK, Vault, etc.) need a Workspace plan, not personal.

Setting up the connection

Auth type: OAuth 2.0 (Authorization Code).

1. In Google Cloud Console, create a new project (or pick an existing one).
2. Enable the APIs you need: Gmail, Google Calendar, Google Drive, Google Sheets, Google Docs, Google Slides.
3. Go to OAuth consent screen, configure (External for personal Gmail, Internal for your Workspace domain), add the scopes listed below.
4. Go to Credentials → Create OAuth client ID → Application type: Web. Set the Authorized redirect URI to the one in the Automize Google Workspace connector dialog.
5. Copy Client ID + Client Secret.
6. In Automize, open Settings → Connectors → Google Workspace → Add connection. Paste credentials, click Connect with Google, pick the account, approve scopes.

Scopes required:

• https://www.googleapis.com/auth/gmail.modify
• https://www.googleapis.com/auth/gmail.send
• https://www.googleapis.com/auth/calendar
• https://www.googleapis.com/auth/drive
• https://www.googleapis.com/auth/spreadsheets
• https://www.googleapis.com/auth/documents
• https://www.googleapis.com/auth/presentations

Find your credentials at https://console.cloud.google.com/apis/credentials.

Rate limits

Each Google service has its own quota – typically 250 req/sec/user for Gmail, 600/min/user for Calendar, 300 read + 300 write/min for Drive, 60 read + 60 write/min/user for Sheets. The connector reads quotaExceeded / 429 responses and retries with exponential backoff. Heavy reads should use the Drive change feed instead of polling.

Data model

Each service is a distinct API but shares a common identity (the
connected Google account).

    Gmail: Labels ─── Threads ─── Messages
    Calendar: Calendars ─── Events
    Drive: Files (with folder structure via parents[])
    Sheets: Spreadsheet ─── Sheet (tab) ─── range (A1 notation)
    Docs: Document ─── body elements
    Slides: Presentation ─── slides

Drive ↔ Sheets/Docs/Slides: every Sheet/Doc/Slide is a Drive File,
reachable by File ID either via Drive list endpoints or directly.

Available operations

26 operations available. Click any row to jump to its detail.

Operations

Create Event

Create a new calendar event

Tips

• Required: summary, start:{dateTime, timeZone}, end:{dateTime, timeZone}.
• Set conferenceData.createRequest to auto-create a Meet link. Pass sendUpdates=all to email attendees.

Delete Event

Delete a calendar event

Tips

• Hard-deletes. sendUpdates=all notifies attendees of cancellation.

Query Free/Busy

Query free/busy status for calendars

Get Event

Get a calendar event by ID

Tips

• Returns event with attendees, recurrence rule, conferenceData (Meet link).

List Calendars

List available calendars

No input parameters.

List Calendar Events

List events from a calendar

Tips

• calendar_id: primary for the user's main calendar, or another calendar ID.
• timeMin/timeMax in RFC3339 for date-range filtering.
• singleEvents=true expands recurring events into individual instances.

Update Event

Update an existing calendar event

Tips

• PATCH-style. Send sendUpdates=all to re-notify attendees.

Create Draft

Create an email draft (pass message.raw as base64url RFC 2822)

Delete Draft

Delete a draft permanently

Get Draft

Get a draft by ID

List Drafts

List email drafts

No input parameters.

Send Draft

Send an existing draft by ID

Get Email

Get a full email message by ID

List Labels

List Gmail labels

No input parameters.

List Emails

List email messages

Modify Message Labels

Add or remove labels on an email message

Tips

• addLabelIds + removeLabelIds. Pass label IDs from List Labels.
• Common: TRASH (delete), INBOX (move out of inbox), UNREAD/STARRED (markers).

Send Email

Send an email (raw RFC 2822 base64url encoded)

Trash Email

Move an email to trash

Untrash Email

Remove an email from trash

Append Rows

Append rows to a sheet

Batch Update Spreadsheet

Batch update – add/delete sheets, format cells, merge, sort, etc.

Clear Sheet Range

Clear values from a range

Create Spreadsheet

Create a new spreadsheet

Get Spreadsheet

Get spreadsheet metadata

Read Sheet Range

Read values from a sheet range (e.g. Sheet1!A1:D10)

Write Sheet Range

Write values to a sheet range

FAQ

Why does my Gmail Send fail with 400 Bad Request?

Most often a malformed raw field. The raw must be base64url-encoded RFC822 (not standard base64). Build with To/From/Subject headers then the body, joined by \r\n.

Service-account auth (no user) – possible?

Yes, with domain-wide delegation set up by a Workspace admin. The current connector uses delegated OAuth; service-account flow isn't yet exposed. Workaround – create a dedicated 'bot' Workspace user with appropriate licenses.

What's the largest file I can upload via Drive Upload?

Simple upload caps at 5MB. For larger files use resumable upload (not currently exposed in this connector). Workaround – chunk-write to a Sheet, or use Drive's web UI for one-off large transfers.

Sheets says 'INVALID_VALUE' when I write – why?

Cell references inside formulas must use the correct locale (comma vs semicolon as argument separator depending on locale). Use valueInputOption=RAW to bypass parsing.

Related connectors

• Microsoft-graph
• Dropbox
• Box