Google Sheets is a cloud-based spreadsheet software offered as part of Google Workspace (formerly G Suite). It allows users to create, edit, and collaborate on spreadsheets in real-time, offering a wide range of features for data organization, analysis, and visualization.
Authorize Connection to Google Sheets
Authorize the connection so Dataddo can write to Google Sheets:
Google Sheets (OAuth)
To authorize this service, use OAuth 2.0 to share specific data with Dataddo while keeping usernames, passwords, and other information private.
- On the Authorizers page, click on Authorize New Service and select your service.
- Follow the on-screen prompts to grant Dataddo the necessary permissions to access and retrieve your data.
- [Optional] Once your authorizer is created, click on it to change the label for easier identification.
Ensure that the account you're granting access to holds at least admin-level permissions. If necessary, assign a team member with the required permissions with the authorizer role to authenticate the service for you.
Google Platform service account
| Field | Description |
|---|---|
| A name for this authorizer in Dataddo | A label so you can recognize the connection later. |
| URL | URL |
| Configuration file | Upload the JSON configuration file, which you have downloaded from your Google Cloud account, to Dataddo. Navigate to Certificates & Tokens to complete this step. |
Dataddo validates the connection when you save it.
Create a Google Sheets Destination
Go to Destinations, click Create Destination, and select Google Sheets. Give the destination a name, choose the authorizer, and click Save.
Fields that load from your account (such as the target object or module) appear after you choose the authorizer.
Write Modes
The write mode decides how each flow run changes your Google Sheets records. Google Sheets supports the standard write modes.
| Mode | Meaning |
|---|---|
insert |
Creates a new record for every row. |
insert_ignore |
Creates records, skipping rows that already exist. |
upsert |
Creates new records and updates existing ones matched by their key. |
update |
Updates existing records matched by their key; fails rows with no match. |
update_ignore |
Updates matched records, skipping rows with no match. |
delete |
Deletes records matched by their key. |
Flow columns are matched to Google Sheets fields by name. If a column has no matching field, it is ignored.
How to Create a Flow to Google Sheets
- Go to Flows and click Create Flow.
- Add one or more sources.
- Add Google Sheets as the destination and pick the authorizer.
- Select the target object and the write mode.
- Set the schedule and click Save.
Troubleshooting
Cannot connect to Google Sheets
Reauthorize the Google Sheets connection and make sure the account has permission to write the target object.
Rows are rejected
Google Sheets rejected rows that break its field rules (required fields, value formats, or duplicate keys). Fix the source data or the field mapping and restart the flow.