- Help Center
- Google Integration Docs
- Google Sheets
-
Get Started With Unito
-
Using Unito
-
Items in Sync, Account Management, and Billing
-
Troubleshooting and FAQs
-
Data Privacy & Security
-
Integration Documentation
- Airtable
- Azure DevOps
- Basecamp
- Bitbucket
- ClickUp
- Confluence
- Eloqua
- Favro
- GitLab
- Google Ads
- HubSpot
- Intercom
- Jotform
- Mailchimp
- MeisterTask
- Microsoft Excel
- Microsoft Outlook
- Miro
- monday.com
- Notion
- Pipedrive
- PostgreSQL
- Slack
- Snowflake
- Stripe
- SurveyMonkey
- Teamwork
- Typeform
- Xero
- Zendesk
- Zoho Projects
- MySQL
-
Atlassian Jira Integration Docs
-
Trello Power-Up Docs
-
2-Way ServiceNow Integration
-
Asana Integration Docs
-
Flows, Features and FAQs
-
Google Integration Docs
-
Salesforce Integration Docs
-
Wrike Integration Docs
-
Azure DevOps Integration Docs
-
Smartsheet Integration Docs
-
GitHub Integration Docs
A Guide to Unito Spreadsheet Sync - Google Sheets Integration
Looking to add Google Sheets to your workflow? Here's what you can expect from this integration and Unito Spreadsheet Sync.
In this article:
- What Unito syncs from Google Sheets
- Supported fields for Google Sheets rows
- Additional features
- Other documentation
What Unito syncs from Google Sheets
Unito syncs rows from Google Sheets worksheets by linking individual fields from these rows to items in other tools (e.g., Trello cards, Jira issues, ServiceNow records).
Supported fields for Google Sheets rows
Since Google Sheets doesn't have set fields the way most other tools do, Unito syncs data from all cells in your spreadsheet's rows.
You can set two types of rules when syncing data from Google Sheets:
- Sync column if it has a value: e.g., create a rule in Unito to only sync rows with "any value" in a column you've called "Priority." This would mean only rows with text in that column would sync.
- Sync column if it's empty: The exact opposite of the previous rule. Taking that Priority example again, a row will not sync if it has anything in the Priority column.
Additional features
Unito's Google Sheets integration also supports the following features:
- Dropdowns: You can map dropdowns in other tools with columns in Google Sheets.
- Auto-populating headers: This integration can auto-populate column headers in Google Sheets in both 1-way and 2-way flows.
Other documentation
Need to know more about this integration? Check out our documentation on: