Every tool you run. One Google Sheet. Always current.
Advertising, analytics, commerce and more — connected in about two minutes, then refreshing on its own.
Free forever plan · No credit card · 2-minute setup
Why teams switch
Less plumbing, more reporting.
The parts of this job nobody wants to keep doing by hand — Analytics Lens just does them.
5x
Faster reporting
Hours of manual exports and pivot-table rebuilding turn into minutes of review.
No code, no developer, no API
Sign in to a source and pick what you want. Nothing to configure outside the sheet itself.
Automated refreshes
Set a schedule once — hourly, daily, or every 15 minutes on paid plans — and stop opening tabs to re-export.
Automated workflows
Automatically send screenshots and reports by email, Google Chat, Slack, and more — no one has to remember to hit export.
10x your productivity. Create automatic, up-to-date marketing reports.
Add to Google Sheets — FreeConnect your first source free — see real data land in Google Sheets in under two minutes.
Connectors
Pick a source. Sign in once. That's the setup.
No API keys, no scripts, no developer. Each connector takes about 30 seconds, and every plan includes all of them.
Google Ads
Campaigns, keywords, search terms, conversions
Meta Ads
Spend, ROAS, creative performance by ad set
Google Analytics 4
Sessions, conversions, channel breakdowns
Search Console
Queries, clicks, impressions, average position
Shopify
Orders, products, customers, revenue by day
HubSpot
Contacts, deals, pipeline stages
Stripe
Charges, subscriptions, MRR
LinkedIn Ads
Campaign spend and lead-gen forms
Building something we don't support yet?
How it works
Three steps. Under two minutes. No code.
-
Install the add-on
Get Analytics Lens from the Google Workspace Marketplace. It opens in a sidebar inside the sheet you're already working in.
-
Connect your sources
Sign in to whichever platforms you run. Pick the metrics, dimensions and date range you want, and choose where in the sheet they land.
-
Set it and forget it
Choose a refresh schedule. Your sheet stays current on its own. Every formula, pivot table and chart you've already built keeps working exactly as it did.
The export loop
You already know how long this takes.
It's the same routine in every team that reports on anything.
Doing it by hand
- Log into the first platform, export a CSV
- Log into the next one, export another
- Paste both in, fix the columns, fix the dates
- Realise last week's numbers moved
- Rebuild the pivot table
- Do it all again next week
With Analytics Lens
- Open the sheet
- It's already current
Who it's for
If you report on numbers, this is for you.
Different teams, same routine — pull the data, refresh the report, repeat.
Agencies and consultants
Run reporting for 5 clients or 50 without rebuilding anything per account. Connect every client under one login, point an existing template at a new account, and hand them a Sheet instead of another dashboard login.
Marketing teams
Spend, sessions, queries and orders side by side in one sheet, refreshed before the weekly review — not the night before it.
Analysts and ops
Skip the manual export step entirely. Clean, scheduled rows landing in a known range, so the model on top of them stays trustworthy.
Founders and finance
Revenue, ad spend and traffic in one place without asking anyone to pull a report. It's already in the sheet when you open it.
Pricing
Start free. Upgrade when your reports do.
No credit card to start. Every plan includes scheduled runs — connector count and refresh volume scale with the plan.
Starter
For trying it out on your own reports
$0/month
Free forever
- 1 user
- 5 connectors
- 35 refreshes / month
- Scheduled runs
No credit card required
Basic
For reporting on more sources, more often
$15.9/month
Billed monthly
- 1 user
- 10 connectors
- 100 refreshes / month
- Scheduled runs
Cancel anytime
Pro
For teams running high-volume reporting
$25.9/month
Billed monthly
- 1 user
- 10 connectors
- 1,000 refreshes / month
- Scheduled runs
Cancel anytime
Enterprise
For teams that need scale, collaboration, and AI on top
- Multiple users
- 10 connectors
- Unlimited refreshes
- AI Insights
- AI Chat bot
Connector count and refresh volume scale by plan — see each plan for what's included.