From Meta Ads to a live, auto-updating Google Sheet in 5 steps. No code knowledge required.
Log in to Meta for Developers, create an app, and generate a long-lived access token with ads_read permissions. This token lets Flow Adlytics fetch your campaign data securely.
Tokens last ~60 days. Regenerate anytime from Meta Business Manager.
Paste your token in Settings → Access Tokens. It's stored encrypted and never shown in full again. You can also save multiple Ad Account IDs with friendly aliases.
Saving your token means it will be auto-embedded in every script you generate.
In the Script Builder, select your account, pick your metrics (Spend, Impressions, Clicks, Purchases, Reach), set your date range, and click Generate. Your script is assembled in under a second.
Use preset templates for the most common report types — Performance, ROAS, or Weekly.
Open Google Sheets, go to Extensions → Apps Script, paste your script, and click Run. Grant the necessary permissions when prompted. Your sheet populates immediately with live Meta data.
The script creates a dedicated sheet tab called "Meta_Ads" automatically.
In Apps Script, click the clock icon to set a trigger. Schedule the script to run daily, weekly, or on any interval. Your report refreshes automatically — no manual work required.
Set it to run at 6am and your data is always fresh when you start the day.
It takes less than 5 minutes from start to your first automated report.