App Icon
KPIBees
•  5,950
Overview
Connect & Import Google Ads, Google Search Console, Google Analytics, CSV, Microsoft SQL Server, JSON, MySQL, XML, PostgreSQL, Web Scraper, API for Social Media, SEO, Database to Google Sheets!
⇨ Use cases:
    ■ Import Google Ads data to Google Sheets. Use Metrics, Attributes and Segments in your queries.
    ■ Import Google Analytics data to Google Sheets. Use Metrics, Dimensions and Segments in your queries.
    ■ Import Google Search Console data to Google Sheets (previously known as Google Webmaster Tools). Use our solution to get historical data!
    ■ Import JSON to Google Sheets. Use JSON path in your queries. You can also use this tool as a JSON viewer and view JSON data inside a spreadsheet.
    ■ Import MySQL to Google Sheets. You can add your database connection credentials and write sql queries within seconds!
    ■ Import PostgreSQL (Postgres) data to Google Sheets.
    ■ Import Microsoft SQL Server data to Google Sheets.
    ■ Automatically Import CSV data to Google Sheets.
    ■ Import XML to Google Sheets. You can use XPath in your queries to bring the data that’s of interest to you.
    ■ Import Website data Sitemap to Google Sheets.
    ■ Import KML to Google Sheets to view your Google Maps data inside a spreadsheet.
    ■ Import REST API in Google Sheets. You can use one of the available connections for JSON or XML depending on your API return format.
    ■ Import Real Estate object file formats like RETS, Openimmo, REAXML, MLS, IDX to Google Sheets.
    ■ Import Google Adwords data to Google Sheets. Use Metrics, Attributes and Segments in your queries.
    ■ Web Scraping html, website content, tables to Google Sheet
    ■ Connect Oracle Database to Google Sheets
--> No Google Apps Script required!

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

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.

⇨ 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
    ■ Next Integrations on our roadmap: Facebook Ads, Facebook Insights, Instagram Ads, Quora Ads, Amazon Seller Central, SEMRush (SEO) & other SEM tools, further Database integrations (mongoDB) and a lot more. Do you want to have another integration? Please vote here: https://kpibees.typeform.com/to/lv7FP6
    ■ 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: https://kpibees.com/pricing/

⇨ 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 www.kpibees.com and have a chat with us about this opportunity!

⇨ A solution that's a lot more cost-effective than Supermetrics, enabling you to connect spreadsheets to your favorite APIs. Also, it can be used as an alternative to Reportgarden, ExcelifyFlex.io, Funnel.io, Power My Analytics, Improvado, Whatagraph, Analytics Canvas, Zoho Analytics, Stitch.io, Zapier, and IFTT.

⇨ KPIBees wants to support education & learning around the world. We welcome schools, universities, teachers, trainers, instructors and students to contact us and receive educational vouchers for FREE!

⇨ Legal
    ■ Terms of Use: https://kpibees.com/legal/terms-of-use/
    ■ Data Protection Agreement: https://kpibees.com/legal/data-protection-agreement/ (KPIBees is fully GDPR/BDSG compliant!)
    ■ Privacy Policy: https://kpibees.com/legal/privacy-policy/
Reviews
Language:
Sort by:
Profile Picture
A User of KPIBees | Import API, MySQL, Google Analytics
September 21, 2020
Easy and fast to query data to a spreadsheet, and the scheduling feature is also very useful.
Is this review helpful?
Yes
No
Profile Picture
A User of KPIBees | Import API, MySQL, Google Analytics
August 22, 2020
It was really easy to pull my data to spreadsheet. Works great!
Is this review helpful?
Yes
No
Profile Picture
A User of KPIBees | Import API, MySQL, Google Analytics
August 7, 2020
I has a problem getting xml using a rest API call. Turned out to be a "must fill spaces in URL" issue and selecting and selecting a "cartesian display" which did the trick. Suggest the video be updated and these "minor issues" be explained or documented for users and not developers. The WARNING from Google is quite standard. The issue is whether it is revoked when one no longer uses the extension. Google analytic normally requires this. To overcome this simply by making a note on the extension install page. VERY SIMPLE otherwise you will lose customers. Get a UI expert to help you.
Is this review helpful?
Yes
No
Profile Picture
A User of KPIBees | Import API, MySQL, Google Analytics
August 4, 2020
This add-On works well to scrap data using xPath. I love it. BUT READ THE FOLLOWING WARNING FROM GOOGLE:- This app wants permission to: See your spreadsheets Edit your spreadsheets Create new spreadsheets Upload or download your spreadsheets Organise and delete any of your spreadsheets See and change the people you share spreadsheets with There may be sensitive information in your spreadsheets, like financial records or personal lists. The use depends on what kind of data you going to use
Is this review helpful?
Yes
No
Profile Picture
A User of KPIBees | Import API, MySQL, Google Analytics
August 4, 2020
MESSAGE FROM THE DEVELOPER RELATED TO THE "WARNING" REVIEW! There are currently all the reasons to believe that the message below was posted by a COMPETITOR. It seems like a really nasty move from someone wanting to discredit the competition. We've contacted the user and have not heard back, also we received no prior mention of the "concerns" he/she was facing! 1. We indeed use Hotjar on our website & add-on, but this is because we want to catch bugs that the users have, like many other websites on the internet - but only within our own addon, not the entire sheet!! We deal with private imports of data, so the fact that "we track the user movements" is not really reasonable considering everything. 2. In terms of GDPR compliance, we uphold the data secrecy for our users 100%. Even in the question of "using hotjar" we are GDPR compliant because hotjar is in itself GDPR compliant. 3. Nasty references as to the company being located in Romania. No comment. 4. It's interesting how your review rates as the most "helpful", so basically the most voted, merely 2 hours after being posted! We urge anyone who has concerns about the review below to give us a message on chat. Meanwhile we will continue to build a great product. Thank you!
Is this review helpful?
Yes
No
Profile Picture
A User of KPIBees | Import API, MySQL, Google Analytics
July 29, 2020
everything is "coming soon". amateur and waste of time
Is this review helpful?
Yes
No
Profile Picture
A User of KPIBees | Import API, MySQL, Google Analytics
July 9, 2020
I was looking for a way to pull inventory data from a dealership xml into google sheets and this worked perfectly! Peter and his team are top-notch and respond VERY quickly to any questions or issues. I highly recommend this add on.
Is this review helpful?
Yes
No
Profile Picture
A User of KPIBees | Import API, MySQL, Google Analytics
July 1, 2020
Looked around for a connector from Sheets to my mysql DB to pull in the data. The connection is easy to set up, needs no tutorials. The data loads up optionally with the column names. Quite smooth. The paid version seems to have interesting addons like scheduled data refresh and such, but it appears pricier than Zapier. [I'm yet to evaluate the premium features fully]. Good luck to the developer.
Is this review helpful?
Yes
No
Profile Picture
A User of KPIBees | Import API, MySQL, Google Analytics
June 4, 2020
WARNING! After adding privacy extension I was alerted this website is using "hojar". At first I thought it is Google but actually it is this addon. I searched and it is recording everything I do in the addon and all my accounts. I tried to see on the company website and there is nothing about this on their website, there's nothing known about this company, no address and no people, the only small mention is in the terms of service - this company is in ROMANIA, the most corrupt country in Europe. This is from a company branding itself as "GDPR compliant". After this, in no way I trust them, changed passwords and removed all accounts.
Is this review helpful?
Yes
No
Profile Picture
A User of KPIBees | Import API, MySQL, Google Analytics
June 3, 2020
Very helpful add-on, integrates well with postgreSQL, barely any configuration needed to get going. Was able to write custom SQL queries and pull tables from our DB within minutes, saved so much time and useful for keeping spreadsheets up to date. Looking forward to a dynamic querying feature! Support is also very timely in responses and helpful!
Is this review helpful?
Yes
No
1-10 of 21
Additional information
KPIBees
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu