Everything you need to know to go from zero to a fully automated Meta Ads report in Google Sheets.
Flow Adlytics generates production-ready Google Apps Scripts that connect directly to the Meta Ads API and pull your campaign data into Google Sheets. You configure the report once, paste the script, and it runs automatically on whatever schedule you set.
Track campaign performance without leaving Sheets.
Build client reports for multiple accounts from a single tool.
Automate reporting so you can focus on analysis, not pulling data.
An active Meta (Facebook) Ads account with at least one campaign. You'll need your Ad Account ID, which looks like act_123456789.
A Meta API access token with ads_read permissions. We'll show you exactly how to get one below. It takes about 3 minutes.
A Google account with access to Google Sheets and Google Apps Script (both free). No special permissions needed.
Step-by-step. Takes about 3 minutes.
Visit developers.facebook.com and log in with your Meta account.
Click "My Apps" → "Create App". Choose "Business" type. If you have one, just open it.
In your app dashboard, click "Add Product" and add the Marketing API.
Go to Tools → Graph API Explorer. Select your app, click "Generate Access Token". Grant ads_read and ads_management permissions.
Short-lived tokens expire in 1 hour. Use the Access Token Debugger to exchange for a 60-day token. Or generate one via the Business Manager.
Paste the token in Settings → Access Tokens. It gets encrypted and auto-fills your scripts.