Meta Ads · Daily
Target: Meta Report!A1
Updated: today 08:00
Google Sheets™ Add-on - BY OZDO
Meta Ads & CRM in Google Sheets™. Automatically.
In 6 clicks.
Automatically export Meta Ads, TikTok Ads and CRM to Google Sheets. ROAS, attribution, and auto-refresh - no code.
Report examples
0
Data sources
∞
Reports
0
Lines of code
0min
To first report
LightLead
BY OZDO
⚙️
🌙
EN
Reports
Attribution
Update History
Alerts
ALL
META
FBP FB PAGE
Active exports
3 total
Bitrix24 Leads
Target: Bitrix leads!A1
Updated: today 07:45
Kommo CRM
Target: CRM Sheet!A1
Updated: never
+ CREATE REPORT
Integrations
Your sources are already supported
Ad platforms connect via OAuth. CRM connects via API key or webhook. One minute to connect.
All integrationsAd channels
Meta Ads
Facebook Page Insights
Instagram Insights
TikTok Ads
CRM
Kommo CRM
KeyCRM
Bitrix24
LP CRM
Pipedrive
HubSpot
GoHighLevel
Why
A familiar pain for every marketer
Data is scattered across tabs
Meta, TikTok, and CRM live separately. The summary is built manually, mistakes are inevitable, and time is wasted.
It is unclear what actually brings leads
UTMs exist, CRM exists, but tying ads to deals still takes hours every time.
A report gets outdated before it opens
Management needs ROAS right now, but by the morning sync the numbers are already stale.
Features
Everything you need is already in the add-on
The wizard loads accounts and metrics for you. No scripts required.
🎯
Attribution analytics
Automatically detects UTM fields in the ad sheet and matches them to deals in CRM. CPL, ROAS, and linked deals without manual stitching.
✓
Auto-detection of UTM fields
✓
Strict / balanced / loose matching
✓
Preview the match rate before saving
Attribution preview ✓ 2 matches
utm_source=meta_ads
Deal #4821 · $42,000
matched
utm_campaign=retarget_2026
Deal #5102 · $28,500
matched
utm_source=tiktok_ads
not found
unmatched
4.2x
ROAS
$8
CPL
67%
Match rate
⚡
A report in 4 clicks
The wizard loads accounts, metrics, and sheets for you. Pick fields and schedule, then launch.
🔄
Scheduled auto-refresh
Every hour, day, or week, the data refreshes automatically. No macros or manual triggers.
🔔
Metric alerts
If CPL rises above the threshold, a Telegram alert is sent. No more checking spreadsheets every morning.
🗂
CRM reports out of the box
Kommo, KeyCRM, Bitrix24, LP CRM, HubSpot, Pipedrive, and GoHighLevel funnel stages, statuses, and fields sync automatically.
AI insights
A dedicated AI block for the team and the manager
Once the data is connected, LightLead can generate not just numbers, but also a short explanation of what changed and what to look at next.
AI insights
AI analyzes connected data and prepares a scheduled report with key takeaways for the team.
scheduled
What is included
Example insights
Rising CPL, lead drop, best campaign of the week, gaps between ads and CRM, and recommendations on what to check first.
Telegram
Manage reports right in Telegram
LightLead
Report “Meta → Kommo” completed.✅ 1,240 rows · ROAS: 3.8x · CPL: $920
📱 Open mini app
Run Meta Ads Daily
LightLead
▶ Started. Status: running…
⚠️ Alert
CPL increased: $1,400🔐
Role-based access
Admin, operator, recipient. Each user sees only what they should, down to individual sources.
📲
Mini app without Google Sheets™
Run reports, check status, and configure attribution directly in Telegram.
🔔
Real-time alerts
Errors, CPL spikes, or reconnect events are pushed instantly without manual monitoring.
👥
Built for teams
Multiple users with different permissions. Managers see everything, operators only their own scope.
Pricing
See which campaigns drive real deals and revenue
Connect LightLead to ChatGPT or Claude and ask questions about your ad and CRM data in plain language.
No credit card required
Cancel anytime
Pay for 10 months and get 2 free
14-day Agency trial starts after your first successful data connection
Free
Test the product
$0/mo
Free forever · no credit card
See which ad campaigns generated real deals and revenue. Free, with no credit card required.
- 1 active project
- 1 ad account · 1 trial CRM connection
- Basic Ads → CRM attribution preview
- Manual refresh · 30-day history
- No custom Telegram alerts
- 20 trial MCP queries · Google Sheets template
Marketer
Freelancers and marketers
$29/mo
Billed monthly
Control up to three projects without manual reports or complex BI systems.
- 3 active projects
- Up to 10 ad and CRM connections
- Basic UTM attribution Ads → CRM
- Daily refresh · 12-month history
- Telegram Mini App and standard alerts
- Single-project MCP analysis · limited AI summaries
Most popular
Agency
Small and medium agencies
$79/mo
Billed monthly
Manage advertising, CRM, deals, and performance for every client in one control system.
- 12 active client projects
- Up to 40 connections · 5 users
- Advanced Ads → CRM attribution
- Hourly refresh · 24-month history
- Custom Telegram alerts · automatic AI summaries
- Multi-project MCP analysis · agency overview
Agency Pro
Agency teams with many clients
$149/mo
Billed monthly
Control the performance of your whole team and client portfolio with advanced analytics, AI, and MCP.
- 35 active client projects
- Up to 120 connections · 10 users
- Advanced attribution and quality control
- Hourly refresh · extended history
- Scheduled reports · advanced AI summaries
- Agency-wide MCP analysis · activity log
Need more projects, users, or custom terms? Contact the LightLead team.
Compare plans in detail
Project count is the main limit. Connection, user, refresh, attribution, MCP, and AI depth grow with each plan.
| Capability | Free | Marketer | Agency | Agency Pro |
|---|---|---|---|---|
| Active projects | 1 | 3 | 12 | 35 |
| Ad and CRM connections | 1 ad + 1 trial CRM | Up to 10 | Up to 40 | Up to 120 |
| Users | 1 | 1 | Up to 5 | Up to 10 |
| Data refresh | Manual | Daily | Hourly | Hourly |
| Data history | 30 days | 12 months | 24 months | Extended |
| Ads → CRM attribution | Basic preview | Basic UTM | Advanced | Advanced + quality control |
| Telegram alerts | No custom alerts | Standard | Custom | Custom |
| MCP access | Trial | Yes | Yes | Yes |
| Single-project analysis | Limited | Yes | Yes | Yes |
| Multi-project analysis | No | No | Yes | Yes |
| Whole-agency analysis | No | No | Limited | Yes |
| MCP activity log | No | No | No | Yes |
How it works
Your first report in 4 steps
01
Contact us
Email [email protected] and we will reply with the next step for LightLead.
02
Connect your sources
Meta connects via OAuth. Kommo, KeyCRM, Bitrix24, LP CRM, HubSpot, Pipedrive, and GoHighLevel connect via API key or webhook.
03
Configure the report
The wizard shows accounts and metrics. Choose fields, sheet, and schedule.
04
Data updates automatically
Press RUN or wait for the schedule. Telegram alerts arrive automatically.
FAQ
Frequently asked questions
Can't find your answer? Email [email protected].
What is LightLead?
LightLead connects ad accounts and CRM systems to Google Sheets™, builds Ads → CRM attribution, AI performance summaries, and Telegram alerts, and lets you analyze your data through MCP in ChatGPT or Claude.
How much does LightLead cost?
Free is $0 forever with no credit card. Marketer is $29/mo, Agency is $79/mo, and Agency Pro is $149/mo. Annual billing costs $290, $790, or $1,490 respectively: pay for 10 months and get 2 free. Contact us if you need more projects, users, or custom terms.
Is there a free trial?
The Free plan is free forever with no credit card. The 14-day Agency trial starts only after your first data source is connected successfully, so setup time does not use up trial days.
Which ad platforms and CRMs does LightLead support?
Ad platforms: Meta Ads, TikTok Ads, Meta Pages Insights, Instagram Insights. CRMs: Kommo, Bitrix24, KeyCRM, LP CRM, Pipedrive, HubSpot, and HighLevel (GoHighLevel).
Do I need to know how to code?
No. Connecting data sources and setting up reports happens through a wizard inside the add-on - no scripts or code required.
Where does the data go?
Data is written directly into the Google Sheet you choose. Each report gets its own sheet (or sheets), which you can configure.
Can I cancel anytime?
Yes, you can cancel your subscription at any time, with no penalties or extra conditions.
Does LightLead support Telegram notifications?
Yes. Starting from the Marketer plan, you get the Telegram Mini App and standard alerts. Agency and Agency Pro add custom alerts.
Contact us.
We will help with access.
Email [email protected] and we will reply with the next step for LightLead.
Contact usYour data stays in your spreadsheet · Works in any Google Sheets™