This article will show you how to connect Google Sheets to Unito so you can sync real-time 2-way updates with other tools.
When you sync other work items to Google Sheets, they'll appear in your rows which means you should think of your columns as fields. Be sure to use the first row as a table header with appropriate field names in order to keep track of your data. We recommend doing this before installing the add-on.
Here's an example of a table header that's ready to sync with Unito:
Looking for inspiration? Here's our free status report template for Google Sheets to help you start syncing with Unito.
Watch us install the add-on for Google Sheets:
Install the Unito add-on for Google Sheets
Before you can start building a flow with Google Sheets, you need to install the Unito add-on through the Google Workspace Marketplace. The add-on will create two columns in your sheet, which enable Unito to properly sync your data.
Why do I need the Unito add-on for Google Sheets?
Having these columns in your sheet is essential for Unito's automated sync to function. You can hide these columns as soon as they're created, but they must stay in your sheet in order for Unito to continue syncing your data.
How to install the Unito add-on for Google Sheets
- From your sheet, click Extensions, then Add-ons, and Get add-ons.
- Type Unito in the search bar.
- Install the Unito for Google Sheets add-on and follow the instructions in the pop-up.
- Click Insert the two columns in this sheet before going to Unito. Doing so will add two columns: UnitoID and Last Modified.
Add Google Sheets to your Unito account
The next step is to login to Unito and add Google Sheets to your list of connected integrations.
1. From the dashboard, click +Create Flow.
2. Select Start Here beside 1. Connect your tools.
3. Now, from the drop-down menu in + Add a tool to this flow, look for Google Sheets.
4. Next, select + Choose account, followed by + Connect a new Google Sheets account.
5. Follow the instructions on-screen and pick the Google account you want to connect with Unito, selecting Allow when prompted.
Now all you need to do is specify which sheet to connect to Unito. You can either type in the name of the sheet or copy-paste the URL from Google Sheets:
Now your Google Sheets account should be connected to Unito!
If you're ready to continue building your first Google Sheets flow, follow one of these comprehensive guides to pair your spreadsheet with Trello, Asana, Google Contacts, monday.com, Airtable, Wrike, Microsoft Excel, or HubSpot. Don't see your tool there? No problem! Here's a step-by-step guide to connect Google Sheets and another app so you can start populating spreadsheets with real-time data.