Hi Everyone!
Hope you are all doing well.
I have a little issue with finding a way to export an entire board into an excel spreadsheet automatically. I know you can use the UI to export which is great, however, I want this to be automated to save doing this every day.
Does anyone have any suggestions for this?
Hey @Rhys_Cook!
Ivan here from the monday.com team! That’s a really great question and a wonderful piece of feedback that I’d like to pass along to our Autopilot Team. At the moment, we currently do not have an automation that would automatically export a board for you.
However, you could set up a recurring automation recipe that would remind you to export the board every day:
Would this help in the meantime?
Hi Ivan!
Thanks for the response, yes that would help but I am trying to make this an automatic process. I was thinking about the problem and there isnt a need for a excel sheet as such, I am currently trying to understand how the API2 works so I can query the data I want from the board and then somehow get this into an email and sent.
Kind regards,
Rhys
Hey Rhys!
That sounds really great and definitely check out our developers page at monday.com/developers/v2 for more information around our API and to learn more about what you’re able to accomplish. Have you had a chance to check out that page on our website?
Hi Ivan,
Yes I have gone through it a few times now and it seems to do what we are looking for, however my coding skills are far from up to scratch and I have recruited an in house developer to help me get it working as we want. I need to make a few adjustments to the board for this to work effectively as we need some columns to reset each day. Will update this post as I progress, although some built in way to autonomously export boards would be fantastic, I know you can do this in the UI so I assume the functionality is there somewhere!
I use Google Sheets not Excel. But if you aren’t attached to the difference then you can definitely use the API to run a daily function to read the board and collect the pieces of data. Are you hoping to pull updates too or just the contents of the columns? Keep in mind some columns don’t work with the API.
Hi Chris, thanks for sharing, I am aiming just to pull the content on the columns. Columns currently on the board are Title, status, long text and formula (which holds the days date).
I don’t see any challenges in being able to do what you are asking for. I haven’t needed to pull a formula column data yet using the API, I know I can manipulate the date but pulling the value should be doable.
