Automate Meta Ads Insights to Google Sheets using Make.com

Questions
1

:bullseye: What is your goal?

I want to automatically fetch Meta (Facebook) Ads performance data into Google Sheets on a daily schedule using Make.com.

My expected workflow is:

Meta Ads → Make.com → Google Sheets

I want to pull metrics such as:

Date
Campaign Name
Ad Set Name
Ad Name
Spend
Impressions
Reach
Clicks
CTR
CPC
CPM
Purchases/Conversions
ROAS

The Google Sheet should update automatically every day without downloading CSV reports manually.

:thinking: What is the problem & what have you tried?

I have connected the Facebook Ads Campaign Management app in Make.com, but I cannot find any module to retrieve Ads Insights or performance metrics.

The available modules are things like:

Watch Campaigns
List Campaigns
Update Campaign
Get Reach Estimate
Search Ad Interests

There is no Get Insights or List Insights module.

2

Nikhil — you’re right that the Facebook Ads Campaign Management app has no Get Insights module. That’s a gap in the prebuilt connector, not in the API.

The insights data lives at the /act_<ad_account_id>/insights endpoint of Meta’s Marketing API. You can reach it from Make with a generic “Make an API Call” module on your existing Facebook connection — pass the fields you listed plus a date preset, then map the result straight into Google Sheets on a daily schedule.

The two fiddly parts are the token permissions (you need ads_read) and pagination once the date range grows past a few hundred rows.

Happy to sketch out the exact module setup if that would help.