← All integrations
Facebook Ads

Facebook Ads → Google Sheets™

Meta Marketing API ad account discovery, campaign, ad set, ad, and insights reporting data.

API Import for Google Sheets™ lets you connect Facebook Ads with the most popular apps, so you can automate your work and have more time for what matters most — no code required.

Google OAuth

Facebook Ads (Meta Marketing API) is the advertising platform behind Facebook, Instagram, and the Meta Audience Network. It manages ad spend across campaigns, ad sets, and individual ads — tracking impressions, clicks, spend, and conversion events at every level. While Meta's Ads Manager gives you a visual dashboard, exporting performance data is limited and the interface isn't built for cross-account analysis or custom reporting. API Import connects to the Meta Marketing API and pulls your ad account data directly into Google Sheets™ — campaign stats, ad set breakdowns, spend by day, and ad-level performance — so you can build custom dashboards, compare date ranges, and share reports without manual exports.

Example prompts
“List my Facebook Ads ad accounts”
“List Facebook Ads campaigns for ad account 1234567890”
“Get Facebook Ads campaign insights for ad account 1234567890 for the last 30 days”
“Get Facebook Ads ad-level insights for ad account 1234567890 yesterday”
“List Facebook Ads ad sets for ad account 1234567890”
“List individual ads for ad account 1234567890”
How to get credentials
  1. Open API Import for Sheets from the Google Sheets™ Extensions menu.
  2. Select Facebook Ads from the API selector.
  3. Click Connect and authorize your account.
  4. Your credentials are stored securely — no copy-pasting required.
→ View in docs

Ready to connect Facebook Ads to Google Sheets™?

Install the free add-on and start pulling data in minutes.

Install Free on Google Sheets™