App Icon
Connect Facebook Ads, Facebook Insights, Google Ads, Search Console, Google Analytics, CSV, API, Intercom, SQL Server, JSON, MySQL, XML, PostgreSQL, Web Scraper, Youtube, MongoDB, SEO, Database!
Works with:
59,103
Overview
Video Tutorials: https://www.youtube.com/channel/UCC3HmpFen0McyRNoOzFFazA/videos

⇨ Use cases:
    ■ Import Facebook Ads and Facebook Page Insights to Google Sheets. 
    ■ 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 JSONPath 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 Sheets
    ■ Connect Oracle Database to Google Sheets
    ■ Import Youtube Analytics to Google sheets (Youtube Video & Channel statistics)
    ■ Connect MongoDB to Google Sheets
    ■ Connect Google Search Console to Google Sheets
    ■ Connect Intercom 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
    ■ 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 a 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
Do you want to have another integration? Please vote here: https://kpibees.typeform.com/to/lv7FP6

⇨ 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/
Additional information
Privacy policy
Terms of service
KPIBees | Connect Mysql, Postgres, API, JSON, XML will ask for the permissions shown below. Learn more
KPIBees | Connect Mysql, Postgres, API, JSON, XML will need access to your Google account
This will allow KPIBees | Connect Mysql, Postgres, API, JSON, XML to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
Send email as you
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
Rinalds Berzins
May 25, 2021
Excellent tool. Saved me a lot of time and money. And I'm just amazed at how easy it is to use and how user friendly it is.
Is this review helpful?
Yes
No
Profile Picture
Philip Meese
December 7, 2020
I've worked with other Spreadsheet enablement for Database connections and this one has exactly the features I was looking for and is super-easy to use. Getting started I had one small hitch that was sorted out quickly by the KPIBees support team who were very responsive (the problem was due to my lack of knowledge about server connections and they helped me to clear that up).
Is this review helpful?
Yes
No
Profile Picture
A User of KPIBees | Connect Mysql, Postgres, API, JSON, XML
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
Nicolai Grut
March 12, 2021
Fantastic tool, very easy to use. It has smart features that make it easy to get started and advanced features if you want to dive in deeper. Support was right there when I had questions before I started. Before I found KPIBees I tried two of the more expensive competitors and couldn't get them to work properly but I got KPIBees working perfectly in a couple of minutes.
Is this review helpful?
Yes
No
Profile Picture
Paulos Raja
June 8, 2021
Amazing, Saves lot of time and efforts
Is this review helpful?
Yes
No
Profile Picture
shahriar kabir
October 27, 2020
Great support.
Is this review helpful?
Yes
No
Profile Picture
Dan Sheridan
March 31, 2021
If you don't ask, you don't get - awesome support. I have been looking for an add-on that makes life easier when it comes to gathering customer feedback from game review websites and adding these reviews into a Google sheet for further analysis. I gave KPIBees a go as it said it features a Web Scraper and thought this could solve all my problems. I followed all the tutorials and selected the method to extract the data through the XPath, I was able to get a review into the sheet. I had trouble getting more than one review and so I reached out to support and I received super fast instructions on how to do this, plus a couple of useful tips to help scrape better data with the tool. If you don't ask, you don't get - I asked for help and got exactly what I needed, I can see KPIBees being an integral part of my workflow and I'm only scraping the surface of what KPIBees can do. Thanks again!
Is this review helpful?
Yes
No
Profile Picture
A User of KPIBees | Connect Mysql, Postgres, API, JSON, XML
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!
Is this review helpful?
Yes
No
Profile Picture
Dan Carter
May 6, 2021
Great tool, I love the integrations and ideas that they came up with to go straight into a google sheet. As a real potential to compete with DataMiner which is awesome. They need to build out the webscraper with advanced steps and multiple field intakes."
Is this review helpful?
Yes
No
Profile Picture
iww aman
October 23, 2020
Great support.
Is this review helpful?
Yes
No
1-10 of 65
Search
Clear search
Close search
Google apps
Main menu