Google Sheets

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

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).

Sheet vs Spreadsheet

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: