monday synced to google sheets with unito

How to Build a Report in Google Sheets Synced with

Building reports with the help of an automation tool will save time, effort and reduce the risk of human error as you copy-paste key details, facts and figures to and from your spreadsheet. That’s where Unito shines the most and that’s what we’ll be discussing in this article: how to build a report in Google Sheets synced with In this context, we’ll be looking at a digital marketing report, but you can create a Unito workflow to sync any kind of board with Google Sheets to share key data with stakeholders.

In this step-by-step guide, we’ll by turning items from our board into rows in Google Sheets. Unito turns the details of your items into mappable fields that will appear in your Google Sheets columns. The key is to use the first row as a table header and give each column an appropriate name that pairs well with the fields in monday.

Here’s what our synced spreadsheet and board looks like: synced to Google Sheets with Unito 2-Way
This is a simplified example of how Unito syncs fields between items and rows in Google Sheets.

Why sync to Google Sheets with Unito? is one of the best project management tools on the market with a wide range of use cases to support collaboration. But if you’re building a report to share with executives or board members, they don’t often want to jump into your boards to see how things are going. That’s where spreadsheets come in handy: they’re flexible, functional, and everyone is used to working with them. So you have two choices: copy paste all the key details from your boards to a spreadsheet, however long that takes, or connect them to an automation platform with two-way sync, such as Unito.

With two-way syncing, you can set a flow direction for how new rows are created in Google Sheets as well as how those rows update based on changes later on. That means in addition to automating row creation, you can also keep individual rows updated in real-time -or not- based on how you like to work.

Before we build a report in Google Sheets synced with

Create a header row in Google Sheets

Go to and open up your spreadsheet. Make sure each column in the first row is clearly labelled with whatever titles you want to map to or from If you don’t know how to categorize the data you want synced, you can start with this Google Sheets template. Or, you can use this Microsoft Excel template if you prefer.

Here is an example of a header row. You’ll need to label the first and last columns of your sheet: “UnitoID” and “Last Modified”. The Unito extension does this automatically, or you can create the titles manually.

Install the Unito add-on to your Google Workspace

Now, click Extensions, then Add-ons, and select Get add-ons. Search for “Unito for Google Sheets” and add it to your workspace by following the on-screen instructions.

Google Sheets Unito Auth Screen
You must check every box in the auth screen or Unito won’t be able to sync your row data.
Unito Google Sheets Add-On
You can find more detailed steps on this process here.

Add Unito to your workspace

  1. Login to your account
  2. Then, select Board Power-Ups > Apps Marketplace
  3. Type Unito in the search field
  4. Click on the Unito app, then Add to your account
  5. Now, hit Install, verify your workspace and board and Add Feature
  6. Authorize then Authorize again (the first button authorizes in Unito, while the second authorizes Unito in
  7. Click Got it.

Step 1: Connect your board and Google Sheet to Unito

  1. Now you can either go to the Unito App and click +Create Flow or continue from your workspace once you’ve added the app.
  2. Click Start Here to connect your tools.
  3. Select +Add a tool to this flow in either column and connect Then click +Choose account to specify the account you want to use.
  4. Pick the board you want to connect to Unito.
  5. Repeat steps 3 and 4 to connect Google Sheets with Unito.
  6. Click Confirm.
Connect and Google Sheets with Unito

Step 2: Set a flow direction between and Google Sheets

Flow direction determines how new tasks or rows are created by Unito. So with a two-way sync at this stage, adding new rows to Google Sheets will create a matching item in, and vice versa. Since we’re building a report in a spreadsheet, we’ll choose a one-way sync from monday to Google Sheets.

Set a flow direction between and Google Sheets

Note: Later, you’ll be able to add field mappings to determine which fields will be kept updated in both tools — regardless of the flow direction you set here.

Select Confirm when you’ve chosen a flow direction.

Step 3: Set rules to filter data between and Google Sheets

This is where you can set up conditions to filter out monday items that you don’t want to appear in Google Sheets. If you don’t set any rules, then all items in your chosen monday board will appear in Google Sheets. If that’s what you want, simply hit confirm and proceed.

Otherwise, Add a new trigger to begin setting up your rules. There can be some variability here, depending on your particular setup.

Set rules to filter data between and Google Sheets
Here we’ve chosen to sync any items with the priority levels: low, medium or high

Rules can filter data using several fields in, though we recommend choosing status or priority.
You can learn more about setting up rules here.

Step 4: Customize field mappings to sync rows between and Google Sheets

Fields represent the details of your spreadsheet rows and items. Since you’re sending field data to a spreadsheet, you’ll only be able to sync numbers or text fields.

First, you’ll be asked whether you want to set up your field mappings from scratch or let Unito do this automatically. Since we have to name all of our fields in Google Sheets, you’ll need to choose the manual option.

A screenshot of the first step of Unito's field mapping process: picking auto-map or start from scratch.

Most fields will be automatically mapped for two-way updates, but you can modify each individually if you prefer one-way updates in some cases. For example, you may not want changes in Google Sheets to affect your monday items, so you could set each mapped field to a one-way sync.

Select +Add mapping, then Select a field in both bases to pair the fields together. Here’s a simplified version of our monday to Google Sheets field mappings

Customize field mappings to sync rows between and Google Sheets
We named all of our fields in monday and Google Sheets similarly to avoid confusion. Name refers to the item name.

Click Confirm when you’re satisfied with your field mappings.

Step 5: Save, close, and launch your workflow!

And that’s it! You’ve just built a flow between and Google Sheets. Congratulations!

If you followed the steps above, your flow ill now:

  • Automatically create new Google Sheets rows based on specific items
  • Keep your spreadsheet and board updated in real-time.

If you have any questions, please don’t hesitate to reach out and let us know.

What’s next after setting up your monday-Google Sheets integration?

If you want to know what else you can do with Unito, here’s some inspiration to help you power up your workflows: