Hey Maloner,
So the idea has kinda shifted from exporting to Excel. Instead I am now using python to make the API request, then breaking it down into what I want. The next step is get the data into an email and send off. Then I will need to find a way to trigger this event. Current thinking is one of the Monday automations to fire off an email and use that to start the request. Finally I will need to get our dev team to host this script and get it scheduled in.
R