Google Sheets
      Back to home
      1. Help Center
      2. Integration Documentation
      3. Google Sheets

      How to Add Unito to Your Google Sheet

      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?

      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.

      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. 

      sales report 1

      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

      1. 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.
      2. Type Unito in the search bar.
        Unito Google Sheets Add-On
      3. Install the Unito for Google Sheets add-on and follow the instructions in the pop-up.
      4. Click extensions again, look for Unito in the drop-down menu then click Get started with Unito.
      5. Now, click Insert the two columns in this sheet before going to Unito. Doing so will add two columns: UnitoID and Last Modified.

      google sheets add-on 1

      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.


      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.

      tool connection google sheets

      4. Next, select + Choose account, followed by + Connect a new Google Sheets account.

      choose tools to connect

      5. Follow the instructions on-screen and pick the Google account you want to connect with Unito, selecting Allow when prompted.

      google sheets OAuth

      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:

      Choose Sheet

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