Hi HubSpo!
I am looking to build out a Google Script (the best option I could figure out) that allows me to pull marketing email stats (delivered, opens, clicks, etc.) and have them populate in a Google sheet weekly. I am not that dev-savvy, but I was able to figure out how to pull a script together with the help of AI.
I am running into an issue where the internal email name and subject line are coming through and populating in the Google sheet, but I am getting '0' for all the stats. I have tried playing around with {/marketing/v3/emails/{emailId} but have not had much luck. Would anyone be willing to help me work through this? Happy to share the script code I have so far, or look at any resources.
Thanks,