How to synchronize monday.com board and Google Sheets spreadsheet
Use case overview
monday.com offers powerful project management capabilities, but your clients, vendors, or other departments may prefer viewing reports in Google Sheets. That's where resynced.io's two-way sync keeps both apps updated.
Select a platform, accounts, and a source
To sync between monday.com and Google Sheets, select monday.com on one side and Google Sheets on the other side as the platforms for syncing.
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.
Pick the source from which the data will sync: a workspace and board in monday.com and Google Sheets spreadsheet with the specific sheet.
Filters (optional)
By default, resynced.io syncs all items, but you can use filters to choose which items to sync and which not.
For monday.com, select the column you want to filter, set filters like "equals" or "does not equal," and enter a value.
In Google Sheets each cell in a column can contain different data types. Select the column you want to filter, then set your filter conditions, including data type, such as "Text equals or doesn't equal," "Number equals or doesn't equal," "Checked or unchecked," and enter a filter value. For example, a Budget column might contain numbers stored as text in Google Sheets, and if you filter the Budget column by 'Number equals,' the filter won't work, and no items will be updated.
Always match the values exactly as they appear in the source. Pay attention to capitalization. For example, if the status is "Done," filtering by "done" won't work as expected.
Item creation and deletion
By default, item creation is enabled only for the left source. New items added in the left source will appear in the right source. You can change this setting to allow item creation in both directions. You can also enable item deletion for one or both apps.
Map fields, sync direction, start synchronization
Map columns from monday.com to the corresponding columns in Google Sheets. Also, map all possible values for columns like Status or Dropdown for two apps. You can also set the sync direction—one-way or two-way.
Click "Save and Run" to start the synchronization.For a detailed, step-by-step guide, check out the Quick Start guide.
Was this guide helpful?
Let us know at hi@resynced.io
Similar guides
How to synchronize data between two monday.com accounts
How to broadcast a single monday.com board to multiple spreadsheets
How to utilize Google Sheets formula capabilities on monday.com boards
How to synchronize Notion database and monday.com board
