We are relatively new to using Monday.com and I’ve been in charge of setting up boards, automations, and integrations for our organization. I really love the functionality of the “My Work” dashboard and the flexibility other custom dashboards give, but Dashboards are limited to 20 boards connected and “My Work” shows items I’m collaborating on and not “responsible” for.
We have around 70-100 active boards at any given time, so I can’t pull all the information I need. This got me looking into API and Google Sheets connectivity.
Here’s my question in a nutshell:
How could I code a Google Apps Script to automatically send an API request to search every board in our main workspace, and organize a list of all items that have “X” person in a column titled “responsible”?
In other words, create a google sheet version of “My Work” but filter it based on items I’m not just mentioned in as a collaborator/teammate etc. but solely as responsible.
If this isn’t possible or it’s too complex, how could I simply automate a scheduled “export” of all boards to a compatible google sheets file (.csv, .xls, etc)? As of now I can only export one board at a time.