How to synchronize monday.com board and Google Sheets spreadsheet

Use case overview

monday.com offers powerful project management capabilities, but many clients prefer viewing reports in Google Sheets. That’s where resynced.io’s two-way sync keeps both apps updated.

Connect your accounts

If you haven’t already, authorize your monday.com and Google Sheets accounts to connect them with resynced.io. For details, see the monday.com and Google Sheets integration pages.

Set up the synchronization

In resynced.io, select monday.com and Google Sheets as the apps to sync. Choose the workspace and board from monday.com and the spreadsheet and sheet from Google Sheets.

Match your data

In the “match by” section, select a field that contains unique values to match data between the apps. This is like a unique ID that helps the system know which items in monday.com correspond to the rows in Google Sheets. Every value in this field needs to be unique. If two items have the same value, synchronization will not run, but your data will not corrupt. The system will notify you and show you where the problem is.

Enable item creation or deletion

By default, item creation and deletion are turned off. You can enable resynced.io to:
· Create new items in one app when they are added to the other.
· Delete items in one app when they are removed from the other.

Map your fields

In the “Synchronize” section, decide which fields in monday.com correspond to columns in Google Sheets. You can also set the sync direction—one-way or two-way.

Start synchronization

Once everything is configured, click “Save and Run” to start the synchronization.
For a detailed, step-by-step guide, check out the Quick Start guide.
An example of setup is provided below.

Similar guides