Build reports in Google Sheets + monday.com | Unito 2-way Sync
monday synced to google sheets with unito
How to Build a Report in Google Sheets Synced with monday.com
monday synced to google sheets with unito

How to Build a Report in Google Sheets Synced with monday.com

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 monday.com. In this context, we’ll be looking at a digital marketing report, but you can create a Unito workflow to sync any kind of monday.com board with Google Sheets to share key data with stakeholders.

In this step-by-step guide, we’ll by turning items from our monday.com 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 monday.com board looks like:

monday.com synced to Google Sheets with Unito 2-Way
This is a simplified example of how Unito syncs fields between monday.com items and rows in Google Sheets.

Why sync monday.com to Google Sheets with Unito?

monday.com 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 monday.com 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 monday.com:

Create a header row in Google Sheets

Go to docs.google.com 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 monday.com. 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 monday.com workspace

  1. Login to your monday.com 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 monday.com then Authorize again (the first button authorizes monday.com in Unito, while the second authorizes Unito in monday.com)
  7. Click Got it.

Step 1: Connect your monday.com board and Google Sheet to Unito

  1. Now you can either go to the Unito App and click +Create Flow or continue from your monday.com 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 monday.com. Then click +Choose account to specify the monday.com account you want to use.
  4. Pick the monday.com board you want to connect to Unito.
  5. Repeat steps 3 and 4 to connect Google Sheets with Unito.
  6. Click Confirm.
Connect monday.com and Google Sheets with Unito

Step 2: Set a flow direction between monday.com 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 monday.com, 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 monday.com 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 monday.com 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 monday.com 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 monday.com, 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 monday.com and Google Sheets

Fields represent the details of your spreadsheet rows and monday.com 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 monday.com 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 monday.com and Google Sheets. Congratulations!

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

  • Automatically create new Google Sheets rows based on specific monday.com 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: