> ## Documentation Index
> Fetch the complete documentation index at: https://docs.mailofly.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Google workspace

# Google Workspace

Connect Google for **OAuth sending** and **Sheets-powered segments** — two integrations that keep Gmail users and spreadsheet workflows in sync with Mailofly.

***

## Google OAuth sending

Send mail through Gmail or Google Workspace without storing your Google password.

### Setup

1. **[Accounts](https://www.mailofly.com/user/accounts) → Add account → Google**
2. Complete OAuth consent
3. Account appears with your Google email as the sender

### Details

| Property      | Value                      |
| ------------- | -------------------------- |
| Auth method   | OAuth 2.0 (offline access) |
| Scopes        | Email send + profile       |
| Daily limit   | **500 emails/day**         |
| Token refresh | Automatic                  |

<Warning>
  Google Workspace admins may need to allow Mailofly in their OAuth app allowlist.
</Warning>

***

## Google Sheets segments

Sync a published spreadsheet into a Mailofly segment — new rows become contacts on each sync.

<Info>
  Requires **Basic plan or higher** (`allow_google_sheet_sync`).
</Info>

### Setup

1. **[Contacts](https://www.mailofly.com/user/contacts) → Google Sheet tab**
2. Select target **segment**
3. Paste the **sheet URL**
4. Set **sheet name** (tab) and **header row**
5. Click **Sync**

### Sheet requirements

| Requirement | Detail                                                  |
| ----------- | ------------------------------------------------------- |
| Access      | Sheet must be **published to web** or publicly readable |
| Header row  | Must include an `email` column                          |
| Format      | Standard Google Sheets — one contact per row            |

### Column mapping

Recognized headers map automatically:

```
email, first_name, last_name, name, phone, company, …
```

Unrecognized columns become `custom_fields` for merge tags like `{{ custom.company }}`.

### Sync behavior

* **Incremental** — only new rows since last sync are imported
* **Manual trigger** — click Sync on the connection
* **API/cron** — `POST /api/integrations/google-sheets/sync` for scheduled syncs

***

## Use cases

| Workflow                             | How                                             |
| ------------------------------------ | ----------------------------------------------- |
| Sales team maintains leads in Sheets | Sheet → segment → campaign                      |
| Event RSVP form exports to Sheets    | Auto-sync new attendees into a blast list       |
| Support team uses Gmail              | OAuth account for personal outreach via Compose |

***

## Related

* [Contacts & segments](https://docs.mailofly.com/guides/contacts)
* [Sending accounts](https://docs.mailofly.com/guides/accounts)
* [Campaigns](https://docs.mailofly.com/guides/campaigns)


## Related topics

- [Integrations](/integrations/index.md)
- [Avoid MX Conflicts](/guides/domains/avoid-mx-conflicts.md)
- [Index](/changelog/index.md)
- [Custom Domains](/receiving/custom-domains.md)
- [Introduction](/audience/introduction.md)