Google Ads to Google Sheets automatically
Automatically export Google Ads to Google Sheets: spend, impressions, clicks, conversions, and ROAS. GAQL, MCC, and search metrics — no code.
LightLead exports Google Ads to Google Sheets via GAQL: spend, impressions, clicks, CTR, CPC, conversions, and ROAS across campaigns, ad groups, ads, and keywords. Manager (MCC) and customer accounts, device/network segmentation, and automatic micro-dollar conversion are all supported.
Read more
What gets exported
- Spend, impressions, clicks, CTR, CPC, CPM, interactions, and engagement
- Conversions, conversion value, ROAS, and cost per result
- Search impression share: search_top_is, search_absolute_top_is, lost to budget and rank
- Quality score per keyword and video metrics
- Hierarchy: account → campaign → ad group → ad / keyword
Dimensions & metrics
- Entities: account, campaign, ad_group, ad_group_ad, keyword_view
- Metrics: spend, clicks, impressions, ctr, cpc, cpm, conversions, conversions_value, roas
- Search: search_impression_share, search_budget_lost_is, search_rank_lost_is, search_top_is
- Segments: device, network, hour, day_of_week, week, month, quarter, year
Auto-refresh
Reports refresh on a schedule — hourly, daily, or weekly. The default range is the last 30 days; LAST_7_DAYS, LAST_14_DAYS, LAST_30_DAYS, THIS_MONTH, LAST_MONTH, THIS_QUARTER, and custom ranges are available. Dates follow the account time zone.
Example sheet
| Campaign | Date | Impressions | Clicks | CTR | CPC | Spend | Conversions | ROAS |
|---|---|---|---|---|---|---|---|---|
| Search Camp 1 | 2026-07-30 | 112,000 | 3,210 | 2.9% | $0.42 | $1,348 | 87 | 4.2 |
| Performance Max 2 | 2026-07-30 | 89,400 | 1,940 | 2.2% | $0.58 | $1,125 | 64 | 3.6 |
The values illustrate the report structure. Real figures come from your Google Ads account and are converted from micro-dollars to your account currency automatically.
Setup in 4 steps
- Start with LightLead and go to Integrations → Ad connectors → Google Ads
- Authorize via Google OAuth (google_ads_read access is enough)
- Pick the customer account (or the child accounts of an MCC)
- Add a report: metrics, segments, range, and schedule
Specifics & limitations
- All amounts arrive in micro-dollars (1/1,000,000) — LightLead converts them automatically
- Search impression-share metrics (search_*_is) are not available at the ad level — query by campaign or ad group
- Quality score exists only on keyword_view
- A manager account (MCC) returns no data — connect the linked customer accounts
- Filters cannot be applied directly to computed ROAS or cost per result
Who it fits
- Search marketers: impression share, quality score, and lost budget
- Teams with multiple customer accounts: one MCC, consolidated reports across children
- Performance Max: conversions, value, and ROAS across channels
Pricing
LightLead starts free (1 Meta Ads account + Instagram Insights). Google Ads and Ads → CRM attribution 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 Google Ads to Google Sheets?
Start with LightLead, authorize via Google OAuth, and pick a customer account. The Read-only role plus google_ads_read access is sufficient.
What is an MCC and how does it work here?
A manager account controls linked customer accounts. In LightLead an MCC lists the accessible clients — each connects as its own source.
Why are amounts in dollars, not micro-dollars?
The Google Ads API returns cost_micros — LightLead divides by 1,000,000 and shows the account currency.
Can I export search impression share?
Yes — search_top_is, search_absolute_top_is, and lost shares are available at campaign and ad group level.
How often do reports update?
On a schedule: hourly, daily, or weekly, with a 30-day default range.
Full Google Ads connector reference: https://docs.lightlead.space/integrations/advertising/google-ads/
Read next
Start with LightLead free
Create your first report — spend, leads, and attribution in Google Sheets.
Create your first report