How to Start Using monday.com and Keep a Public Spreadsheet That Updates Automatically
17 Nov, 2025
Author
Antonina Smyrnova
If you’re wondering how to dive into monday.com and keep a public spreadsheet humming along, you’re really aiming for two wins: streamlining your team’s workflow and sharing just the right data with the outside world. Let’s kick things off with the workflow piece.
monday.com is your all-in-one command center for projects big or small. It gathers tasks, statuses, deadlines, and assignments under one digital roof, making teamwork more transparent and easy.
Imagine a project lead, once mired in the scattered emails and endless chats, now starting their day by opening monday.com and finding a neatly organized list of tasks and deadlines. No longer overwhelmed by fragmented information, they can focus on strategic planning and team support.
By making monday.com your team’s home base and syncing a public spreadsheet, you give stakeholders, clients, or the public a real-time window into your progress, without exposing your internal workings. Find out more in our article.
What a “Public Spreadsheet” Means & Why You Might Need One
A “public spreadsheet” is a document, like one on Google Sheets, that anyone with a link can view (and sometimes comment on). You are not giving everyone edit rights; you are just sharing your data.
Why do this?
- Transparency: If your organisation wants to publicly showcase its progress (e.g., non-profits, open-source projects, community initiatives).
- Stakeholder updates: Clients, boards, or sponsors who require live data without needing to log into monday.com.
- Public reporting: Marketing dashboards, release trackers, public roadmaps.
- Embed-ready: Many websites embed Google Sheets, making them great for displaying live status updates externally.
Thus (when you learn how to start using monday.com and keep a public spreadsheet), you’re creating a flow: monday.com → public sheet. With automation, you remove manual updates and reduce errors.
How to Start Using monday.com – Set Up Your First Board
1. Choosing Your Board Structure and Columns
When you launch monday.com, you create a board. Boards can be task lists, project trackers, pipeline views, etc. The key is to pick a structure that reflects your workflow: items could be “Tasks”, “Bugs”, “Clients”, “Events”, etc.
Then, you choose columns, such as Status, Date, Person, Long Text, and Number. The supported types are Text, Long Text, Person, Number, Status (Select), Date/Date & Time, Multi-select, Checkbox, Email, Phone, and Item ID.
When designing your board, select column types that align with what you’ll publish externally. For instance: Status, Due Date, Assigned Person, Notes.
2. Inviting Team Members and Setting Permissions
Once your board is set up, invite your team. monday.com lets you control who can view, edit, or join as a guest. For a public sheet workflow, keep your board stable and only allow authorized edits to items that will sync to the public sheet. This helps prevent unwanted changes from appearing in public.
Keeping a Public Spreadsheet in Sync with monday.com
Now, let’s focus on how to start using monday.com and keep a public spreadsheet that updates automatically.
1. Connecting monday.com to Your Public Spreadsheet
Thanks to the integration offered by resynced.io, you can synchronise your monday.com board with a public spreadsheet (such as Google Sheets) or even with another monday.com account.
The integration supports two-way sync or one-way sync, as well as filters, column selection, and more.
Here’s how:
- In resynced.io, go to Integrations → Add Connection under monday.com.
- Install the resynced.io app in your monday.com account via the marketplace link.
- Authorise resynced.io to view & edit your board (you’ll need those permissions).
- Choose your public spreadsheet (Google Sheets or another) or another monday.com board.
- Choose which columns to sync, decide if it’s one-way (monday.com to sheet) or two-way, and apply filters, such as only syncing items with status “Published.”
- Activate the sync. Changes in monday.com will now be reflected in your public sheet.
2. Supported Column Types and Sync Limits
The supported monday.com column types include Text, Long Text, Person, Number, Status (Select), Date/Date & Time, Multi-select, Checkbox, Email, Phone, and Item ID.
Also, note the board size limit: you can sync boards up to 10,000 items. If your board exceeds this, the sync won’t run.
3. Setting Up the Sync: Filters, Directions, and Automation
Once connected, you’ll configure:
- Direction: one-way (source → destination) or Two-way (both update).
- Filters: e.g., only items updated in the last 24h, or status = “Live”.
- Columns to include/exclude: only publish what you want.
- Schedule: how often sync runs (real-time or periodic).
With this setup, your public spreadsheet will reflect live data from monday.com, eliminating the need for manual row copying.
4. Publishing & Sharing Your Public Spreadsheet
Once the sync is live, publish your spreadsheet:
- If using Google Sheets: go to File → Share → “Anyone with the link can view”.
- Embed it into a website via the “Publish to web” option.
- Ensure viewers are aware that it’s read-only (internal edits are made in monday.com).
- On your monday.com board, consider having a “Public view” filter to ensure only relevant items appear.
This ensures you’re effectively learning how to start using monday.com and maintaining a public spreadsheet in a way that is safe, readable, and low-maintenance.
5. Maintenance Tips and Avoiding Sync Pitfalls
Even with automation, you should stay alert:
- If you change column types in monday.com or delete a column, your sync may break.
- If your board exceeds 10,000 items, sync will stop.
- Review your filters and column selections periodically.
- Ensure data cleanliness is maintained (no stray drafts, test items, etc.).
Tell your team that the board is now connected to a public sheet. Remind them that unauthorized edits may be visible to the public.
For more information on integration cases, please refer to our resources.
Real-World Use Cases: When Public Spreadsheets Save the Day
Now that you know how it works, let’s look at some real examples. These ideas show how linking monday.com to a public spreadsheet can turn a simple feature into something genuinely helpful.
1. The Open-Source Project
Suppose you run an open-source project with contributors from around the world. As your GitHub issues grow, your community wants to stay updated without getting lost in your internal workflow.
This is where a public spreadsheet can be helpful. Sync your monday.com board, filtered to show only "Ready for Contributors" and "In Progress" items, to a Google Sheet on your project website.
Developers in Tokyo, designers in Berlin, and testers in São Paulo can see what needs attention, who is working on each task, and which issues are available. They don’t need a monday.com login or to ask on Slack, "What can I work on?"
The roadmap updates automatically as your team works. Add a "Last Updated" timestamp column so visitors know the data is current, not from three sprints ago.
2. The Marketing Team's Public Roadmap
Your SaaS company moves quickly, and your users appreciate staying informed. Still, your internal product board is a mess of technical debt, engineering estimates, and features that probably won't ever launch.
Create a "Public Roadmap" board in monday.com with only customer-facing features, filtered to show items with status "Planned," "In Development," or "Shipping Soon." Sync it to a beautifully formatted Google Sheet (add some conditional formatting) and embed it on your product page.
Now, your users can see their requested features transition from "Planned" to "Shipping Soon" in real-time. They feel listened to, stay engaged, and stop sending your support team constant questions about release dates. If you launch something ahead of schedule, the spreadsheet updates right away.
Conclusion: Getting Started and Next Steps
That’s it, a complete beginner’s guide to starting with monday.com and keeping a public spreadsheet that updates automatically. By using monday.com as your main workspace and syncing with resynced.io, you can avoid manual exports, keep your public data up to date, and offer more transparency to stakeholders or the public.
Next steps:
- Create your first board in monday.com.
- Install the resynced.io integration and connect your board.
- Set up the sync to your chosen public spreadsheet, and decide whether it will be one-way or two-way.
- Publish your spreadsheet with the appropriate permissions.
- Monitor your board structure periodically and maintain it to avoid sync issues.
Ready to get started? Head over to the integration page at resynced.io – monday.com Integration and follow the quick-start steps.
Start your free trial today!
Here’s to smoother workflows and real-time public reporting!
FAQ
Can I sync Monday.com with Google Sheets so the sheet is publicly viewable?
Yes. With resynced.io, you can connect your monday.com board to Google Sheets and set the sheet to “Anyone with the link can view,” making it a public spreadsheet. (monday.com integration | resynced.io, n.d.)
Will changes made in the sheet be reflected in monday.com?
It depends on how you set the sync. You can choose one-way (from monday.com to the sheet) or two-way (in both directions). Two-way allows edits in the sheet to reflect back, so be careful if it’s public.
Are there any limitations on the number of items I can sync from monday.com?
Yes. resynced.io supports monday.com boards up to 10,000 items. If your board has more items, the sync will not run.
What happens if I change the column types in Monday.com after setting up the sync?
Changing column types or deleting columns can disrupt the sync. It’s recommended to disable the sync, make your board changes, adjust settings, and then re-enable it.
Can I filter which items get published to the spreadsheet?
Yes, when configuring the sync, you can set filters to include only items that meet certain criteria (e.g., status = “Published”).
Is it safe to publish a public spreadsheet from live data?
Yes, if you carefully choose what data to publish (exclude sensitive columns), set the sheet to view-only, and audit your board structure. The internal board stays in monday.com, and you only expose what you intend.
We are here to synchronize your data!
