It sounds like you’ll need a Zap that starts with the Scheduler app (to trigger the Zap once a month) and then use webhook steps to call the Mailgun API to get the data that you need.
I’ve not worked directly with the Mailgun API so I’m not sure exactly how you’d need to set up the webhooks, but I do know that you’d need to do it that way rather than using the Zapier Mailgun integration.
Hello! There are three ways you’d be able to do this.
First Solution
The most simple way would be to chain several post requests as webhook steps, but honestly - If you don’t run into issues here, I’d be surprised.
Second Solution
A better way to do this (and it would definitely be dependent on the actual number of services you want to make a call to) would be using a fetch API call in a JavaScript code step
const res = await fetch('/<domain>/messages' + inputData.zipCode + ',us'); const json = await res.json(); return json;
Some resources on this would be here: https://documentation.mailgun.com/en/latest/api-sending.html#sending
and here: https://zapier.com/help/create/code-webhooks/javascript-code-examples-in-zaps
Third Solution
Alternatively, if you don’t want to get too technical, you could just sign into as many accounts as you need in Zapier here: https://zapier.com/app/connections and create an indivuidual zap for each account and send it to a database/G-Sheet.
Hope any of these ideas help you - Please let us know how you get on!
