Meta Ads to Google Sheets automatically
Automatically export Meta Ads to Google Sheets: spend, impressions, clicks, leads, and attribution. Set up in 4 steps, no code.
LightLead automatically exports Meta Ads data to Google Sheets: campaigns, ads, spend, impressions, clicks, CTR, CPL, conversions, and ROAS. Data refreshes on a schedule, and attribution ties ads to CRM deals. Connecting an ad account takes about two minutes via Meta OAuth.
Read more
What gets exported
- Campaigns, ad sets, and ads
- Spend, impressions, clicks, CTR, CPC, CPM, reach, and frequency
- Results, conversions, and cost per result
- Creatives: thumbnail, ad copy, links, media type
- Campaign and ad set budgets (daily and lifetime)
Dimensions & metrics
- Entities: ad account, campaign, ad set, ad, insights
- Metrics: impressions, clicks, ctr, cpc, cpm, reach, frequency, spend, results, purchase_roas
- Periods: today, yesterday, last_7d, last_30d (30 days by default)
- Flexible AND/OR filters on campaigns, ad sets, ads, and metrics
Auto-refresh
Reports refresh on a schedule — hourly, daily, or weekly — no macros, no manual runs. LightLead respects Meta rate limits and uses async reports and caching for large accounts.
Example sheet
| Campaign | Date | Impressions | Clicks | CTR | CPC | Spend | Results | ROAS |
|---|---|---|---|---|---|---|---|---|
| Campaign A | 2026-07-30 | 48,000 | 1,240 | 2.6% | $0.48 | $595 | 46 | 3.8 |
| Campaign B | 2026-07-30 | 31,500 | 820 | 2.6% | $0.41 | $336 | 29 | 4.1 |
The values above illustrate the report structure. Real data comes from your ad account and CRM.
Setup in 4 steps
- Start with LightLead and go to Integrations → Ad connectors → Meta Ads
- Click Connect and authorize via Facebook Login (OAuth 2.0)
- Pick the ad account from the list
- Add a report: choose metrics, a period, and a schedule — data lands in Google Sheets
Limitations
- Meta API limit of about 3 requests per second; exponential backoff up to 15 minutes when throttled
- Very large accounts may truncate results by page count — narrow the selection with filters
- Overly wide requests can return a payload-too-large error — split metrics into groups of 10–15
- Creative fields load via a separate request and may be missing on API errors
- Budgets arrive in cents from the API — LightLead converts them to currency automatically
Pricing
LightLead starts free (1 Meta Ads account + Instagram Insights). Ads → CRM attribution and Telegram alerts start with the Solo plan at $19/month; multiple CRMs and multi-client reports come with Agency plans from $49/month.
FAQ
How do I connect Meta Ads to Google Sheets?
Start with LightLead and connect an ad account via Meta OAuth — authorization takes about two minutes. Then add a report with the metrics and schedule you need.
Can I export spend and leads together?
Yes — one report can hold Meta metrics and attributed CRM deals. Attribution matches ad UTM tags to deals.
Is coding required?
No. The LightLead wizard loads accounts and metrics; you pick fields and a schedule.
What permissions does LightLead need in Meta?
Exporting statistics requires ads_read and read_insights on the ad account.
How often do reports update?
You can schedule refresh every hour, every day, or once a week.
Full Meta Ads connector reference: https://docs.lightlead.space/integrations/advertising/meta-ads/
Read next
Start with LightLead free
Create your first report — spend, leads, and attribution in Google Sheets.
Create your first report