How to download Meta Ads export of report from e-mail

How To
1

Hello together,

in Meta you have the option to receive automatic reports via e-mail. You will then receive a e-mail with a button to download a xlsx file. The URL of the button is:

https://www.facebook.com/ads/report_builder/past_report/download_report/?report_run_id=[HERE IS THE ID]&export_format=xlsx&source=email

Now if you open that URL in the browser, a pop-up opens for downloading the report. I am now trying to automatically download it. I can’t use the http get file module, because the URL is not a direct link to the file.

How can I do that?

2

Welcome to the Make community!

To do this, you can try using the Facebook Insights “Get Insights” module —

Returns insights for the selected ad, ad set, ad account or campaign.

For more information, see https://www.make.com/en/integrations/facebook-insights, and https://www.make.com/en/help/app/facebook-insights in the help centre.

For more information, see the official Insights API documentation.

If you need further assistance, please provide the following:

  • You’ll need to provide a real link…

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

3 Likes
3

I guess this is the better way and it works also great - thank you!

1 Like