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!
Listing updated:November 28, 2023
Works with:
190K+
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
    ■ IP lookup in Google Sheets - get detailed information on IP addresses.

--> 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
PricingNot available
Developer
Non-trader
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:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Thierry Rodet (EXO)
September 21, 2023
Today, I tested connecting Google Sheets to our SQL database using AppScript. It was slow and often disconnected, so I tried KPIBees instead. KPIBees was much faster and easier to use, and I was able to get the results I needed in 20 seconds. I'm still learning how to use it, but I'm impressed so far.
Is this review helpful?
Yes
No
Profile Picture
Saif Al-Sadouni
August 5, 2023
I run a YouTube channel named "Creepy Chronicles" and have been using KPIBees extensively to analyze alot of information from my YouTube channel, which would otherwise be very difficult to understand from just using their analytics page. Thanks for the amazing tool, I've been able to scrape alot of information in regards to these various variables: ID, Title, Thumbnail Published at, Duration, View Count, Like, Count, Comment, Count, Link
Is this review helpful?
Yes
No
Profile Picture
Captain
October 25, 2023
really good tool. pricing could be cheaper. but worth it. using it for sheets and links. works like a charm
Is this review helpful?
Yes
No
Profile Picture
Simon Stafferton
November 15, 2023
I've started using KPI Bees more and more to pull Google Ads data in Sheets, and quite simply it rocks. I've used a few alternatives, and there has always been various ssues, but KPIBees is reliable, easy to use, and now an essential tool in our armoury!
Is this review helpful?
Yes
No
Profile Picture
Deadlyrock
November 27, 2023
Great addon I suggest you get it
Is this review helpful?
Yes
No
Profile Picture
Ray Chandonnet
April 11, 2023
I'm CFO of a luxury car subscription startup company. We maintain our central database on all our vehicles in MySQL. I wanted to reduce the friction and errors associated with maintaining duplicative data in spreadsheets that I use for financial management purposes. I use KPIBees to directly connect Google Sheets into MySQL and run queries that import realtime data from our database, which I can then use to run my numbers with full confidence that I have no slippage in data!! It was incredibly easy to make a secure SSL connection to MySQL through KPIBees and run my queries. Saved me a ton of time and greatly improves my financial controls by virtually eliminating errors, and without needing to do cumbersome data extracts from MySQL into CSV and then importing into Sheets. Great product.
Is this review helpful?
Yes
No
Profile Picture
aris cruz
May 26, 2023
this app helps me in tracking my sign-ups and sales, even though I have limited access to the Wix of my client. this app is awesome!
Is this review helpful?
Yes
No
Profile Picture
Jamie Wrenn
June 13, 2023
We manage 335 short term rental properties and MySQL helps me collect changing information on a weekly basis. It was easy to connect to our property management software and works perfectly with Google Sheets.
Is this review helpful?
Yes
No
Profile Picture
Sales Growth
December 1, 2023
good
Is this review helpful?
Yes
No
Profile Picture
Shakti Motani
November 10, 2022
was smooth, in 30 sec i could connect to the ms server from google sheet great experience!!! but i could test only one query and my free limit as exhausted.
Is this review helpful?
Yes
No
1-10 of 123
Search
Clear search
Close search
Google apps
Main menu