What is LightLead
LightLead is a Google Sheets add-on that connects to your ad accounts and CRM systems, pulls data into spreadsheets, and builds reports.
What LightLead does
- Automated data collection from ad accounts (Meta Ads, Google Ads, TikTok Ads) and CRMs (Kommo, Bitrix24, Pipedrive, HubSpot, and others)
- Report building — configure once, and data refreshes automatically on schedule
- End-to-end analytics (attribution) — link ad data with CRM data to see which ads drove deals
- AI assistant — ask questions about your data in natural language
- Telegram notifications — receive reports and alerts directly in Telegram
Supported data sources
Ad Accounts
- Meta Ads (Facebook and Instagram)
- Google Ads
- TikTok Ads
- Meta Pages Insights
- Instagram Insights
CRM Systems
- Kommo (ex-AmoCRM)
- Bitrix24
- KeyCRM
- LP CRM
- Pipedrive
- HubSpot
- HighLevel (GoHighLevel)
Where data goes
Data writes to a Google Sheet you select during setup. Each report occupies its own sheet (or sheets), which you can configure.
Who LightLead is for
- Marketers — collecting ad account data in one place
- Executives — consolidated reports on ad and sales performance
- Analysts — end-to-end analytics linking ads and CRM
- Agencies — multi-client reports from multiple ad accounts
Report vs. Integration
- Integration (connector) — a connection to a data source (ad account or CRM). You set it up once when adding a source.
- Report — a specific data query from connected integrations. For example: "Show me spend and conversions by Meta Ads campaign for the last 7 days."
A single connector can be used in multiple reports.
Standard Report vs. Attribution Report
- Standard report — data from one source (or multiple unrelated sources)
- Attribution report — links ad data with CRM data by identifiers (e.g., UTM tags or client ID), showing the full funnel from ad impression to deal