Help & Support
Send Feedback
Tired of copy/pasting data into your marketing reporting sheets? Connect to Google Analytics, Social Media, SEO, JSON, Database, Mysql, API and create beautiful dashboards in a matter of minutes!
168 users
Works with
In your day-to-day work, you use a ton of software tools and always struggle to analyze the data from them. These tools usually offer their own analytics, but you still crave to see the data in that elegant spreadsheet format - nothing can match that! And you end up manually copying everything into google sheets - for hours, every single week. Sometimes you have to. If you want to compare Google ads with Facebook ads, you’ll need a tool that enables you to do this. Even more, maybe you’d like to have KPIs from Website Analytics, Ads & Marketing, Subscriptions, and your own database, ALL-IN-ONE-PLACE.

➡ Meet KPIBees, a GDPR compliant tool that imports data from various products or services into Google Sheets, with just a few clicks, you can create beautiful marketing dashboard.

A solution that's a lot more cost-effective than Supermetrics, enabling you to connect spreadsheets to your favorite APIs.


⇨ How it works:
    ■ Select an integration (currently Google Analytics, JSON and Database (mysql) are available, as we've just launched, working to add more!)
    ■ Select a cell in a spreadsheet where you want to bring the data.
    ■ Create a new query with the parameters that you want.
    ■ Save & Run the query.
    ■ And you're done! The Add-on will pull the data into the spreadsheet starting with your selected cell as starting point!
You can create an unlimited number of queries and you can always come back to modify them and run them again. When you select a spreadsheet cell that is part of a query and the KPIBees Add-on is running, it pops-up a notification and you can open that query or edit it!

⇨ Integrations
    ■ As we've just launched, at the moment we have integrations with Google Analytics, JSON and Database (mysql)
    ■ Next Integrations on our roadmap: Google Search Console, Google Ads, Facebook Ads, Facebook Insights, Instagram Ads, Quora Ads, Amazon Seller Central, SEMRush (SEO) & other SEM tools, further Database integrations (mongodb, PostgreSQL) and a lot more. Do you want to have another integration? Please vote here:
    ■ Every integration is Free as long as we are in Beta - Google Analytics will always be Free. Check our pricing page for more information about our premium packages:

⇨ Use cases
    ■ Import data from Google Analytics into Google Sheets. Run queries with your desired parameters (metrics, dimensions, segments), and get the output into the selected cell of the spreadsheet.
    ■ Import data from JSON url, use JsonPath for bringing your desired structure to sheets.
    ■ API connector for various tools that you use.
    ■ Import data from your MySQL databases straight into spreadsheets.
    ■ Schedule your marketing reporting any time you want and send email or slack notification whenever a refresh happens

⇨ Future features on our roadmap
   ■ Ability to use templates from our Template Gallery and to get ready to use reports within seconds! Schedule data refresh and email beautiful reports to yourself or your clients. 

⇨ Enterprise usage
   ■ KPIBees can build integrations for your own company tools or APIs and make them available just for your domain or users, while being fully GDPR compliant. Visit and have a chat with us about this opportunity!

⇨ Legal
    ■ Terms of Use:
    ■ Data Protection Agreement: (KPIBees is fully GDPR/BDSG compliant!)
    ■ Privacy Policy:
A User of KPIBees
February 11, 2020
WOW! It's working very easy. I like this app, Prompt action...too early to see results yet but looks very promising. Good work!
Submit reply
A User of KPIBees
December 1, 2019
nothing works
Submit reply
A User of KPIBees
October 17, 2019
Works! I did not manage to import json first but after talking to support they clearerd it out quick!
Submit reply
A User of KPIBees
October 2, 2019
Doesn't work, shows red message "no address". Waste of time
Submit reply
1-4 of 4
Additional information
Clear search
Close search
Google apps
Main menu