Here's how to connect Google Sheets to Unito so you can sync spreadsheets in real-time with automated 2-way updates.
What does this article cover?
- Use a row header (or table header)
- Why do I need the Unito add-on for Google Sheets?
- Watch how to install the Unito add-on for Google Sheets
- How to install the Unito add-on for Google Sheets
- Connect Google Sheets to your Unito account
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. If you don't have Unito's Google Sheets Add-On installed yet, you should add it now. Instructions on how to use it can be found in this article.
Always use a row header (or table header) in your Google Sheet
Be sure to use the first row as a table header (or row header) with appropriate field names in order to keep track of your data. We recommend doing this before installing the add-on.
Example: Each cell in the first row will become its own field. So if cell B1 has the word "Title" in it, you'll see that field appear in Unito's list of possible field mappings with the same name. In the image below, you can see what that looks like in Unito.
Why do I need 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. This is represented visually by cells labelled: "UnitoID" and "Last Modified" in the first row of your table header. Only columns between those cells will sync with Unito.
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.
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:
How to use the Unito add-on for Google Sheets
- You can either get the add-on directly from the Google Workspace Marketplace or from your sheet. Click Extensions, scroll down tothen Add-ons, and Get add-ons.
- Type Unito in the search bar.
- Install the Unito Spreadsheet Sync add-on and follow the instructions in the pop-up.
- Click extensions again, look for Unito in the drop-down menu then click Get started with Unito.
- Now, click Add 2 columns before going to Unito. Doing so will add two columns: UnitoID and Last Modified.
Connect Google Sheets to your Unito account
The next step is to login to Unito and add Google Sheets to your list of connected integrations.
- From the dashboard, click +Create Flow.
- Select Start Here beside 1. Connect your tools.
- 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!
Hey Trello users! There's an even faster way to sync data to your Google Sheets!
Get the Export & Sync Power-Up for Trello. If you're a Trello user, it's already included in your Unito plan!
If you're ready to continue building your first Google Sheets flow, follow one of these comprehensive guides to pair your spreadsheet with GitHub, Trello, Asana, Google Contacts, monday.com, Airtable, Wrike, Microsoft Excel, or HubSpot. Don't see your tool there? No problem! Here's a generic step-by-step guide to connect Google Sheets and another app so you can start populating spreadsheets with real-time data.