How to broadcast a single monday.com board to multiple spreadsheets
Use case overview
With resynced.io, you can sync data from a single monday.com board into multiple Google Sheets. By updating information in the monday.com board, it automatically updates in the connected sheets according to your sync settings. This allows you to manage data in one place and reflect it in different sheets based on your customized sync rules.
Prepare your data
In monday.com
Organize your board with the relevant columns and data that must be broadcasted.
Decide if all data will be shared or only specific fields or items (e.g., limited data for certain use cases).
In Google Sheets
Create corresponding sheets where the data will be synchronized.
Select a platform, accounts, and a source
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.
Choose the workspace and board from monday.com and the spreadsheet and sheet from Google Sheets.
Filters (optional)
By default, resynced.io syncs all items. You can use filters to sync only specific items.
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.
For each Google Sheets file, create a separate synchronization in resynced.io:
Full Data Sync: Sync all columns and items to one spreadsheet for a comprehensive view.
Filtered Syncs: Create additional syncs to send selected columns or rows (fields or items) to specific spreadsheets.
Example: Sync only specific fields (e.g., status and amount) to one spreadsheet and others to another.
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 monday.com board and Google Sheets spreadsheet
How to synchronize data between two monday.com accounts
How to utilize Google Sheets formula capabilities on monday.com boards
How to synchronize Notion database and monday.com board
