I want to pull all items and subitems into a GoogleSheet.
Here’s my logic:
- I pull the board based on his id and push it’s values to a sheet in my Google Sheet
- I run through the values of the subitems, extracting their ids.
- I’m pulling all the items data based on the id
- I’ll push the data into another sheet (tab) in my Google Sheet with a column that holds the id of the parent (or another identifier).
My problem is that when I’m querying for the id, I can’t get the name of the columns, which makes it complex to get a list of all the returned columns. I fill it is too much of a overhead.
As subitems are just boards on the monday.com backend, is there a way for me to get the board id and query it? it will make my life super easy.