Search
Clear search
Close search
Main menu
Google apps
App Icon
Connect MySQL ™, PostgreSQL ™, SQL Server ™, Google ™ products, CSV, API, JSON, XML, and a lot more, to Google Sheets ™!
Listing updated:August 21, 2024
Works with:
223K+
Overview
Video Tutorials: https://www.youtube.com/channel/UCC3HmpFen0McyRNoOzFFazA/videos

⇨ Use cases:
    ■ Import MySQL™ to spreadsheets. You can add your database connection credentials and write SQL queries within seconds!
    ■ Import PostgreSQL™ (Postgres) data to spreadsheets.
    ■ Import Microsoft SQL™ Server data to spreadsheets.
    ■ Import Facebook Ads & Page Insights™ to spreadsheets. 
    ■ Import Google Ads™ data to spreadsheets. Use Metrics, Attributes and Segments in your queries.
    ■ Import Google Search Console™ data to spreadsheets. Use our solution to get historical data!
    ■ Import JSON to spreadsheets. Use JSONPath in your queries. You can also use this tool as a JSON viewer and view JSON data inside a spreadsheet.
    ■ Automatically Import CSV data to spreadsheets.
    ■ Import XML to spreadsheets. You can use XPath in your queries to bring the data that’s of interest to you.
    ■ Import Website data Sitemap to spreadsheets.
    ■ Import REST API in spreadsheets. 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 to spreadsheets.
    ■ Web Scraping html, website content, tables to spreadsheets
    ■ Connect Oracle Database to spreadsheets
    ■ Import Youtube Analytics™ to spreadsheets (Video & Channel statistics)
    ■ Connect Google Search Console™ to spreadsheets

--> No Google Apps Script required!

➡ Meet KPIBees, a GDPR compliant tool that imports data from various products or services into spreadsheets 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.

⇨ 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

⇨ 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
PricingFree of charge with paid features
Developer
Non-trader
Privacy policy
Terms of service
KPIBees will ask for the permissions shown below. Learn more
KPIBees will need access to your Google account
This will allow KPIBees 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
Nick Teophan
June 27, 2024
The best extensions I've ever used, hands down! If you need to quickly and precisely connect data, use this, it's a life saver!
Is this review helpful?
Yes
No
Profile Picture
Aung Thura Htoo
June 13, 2024
One of the best data visualization extension ever. It has provided me a resource to connect my data sources from API to other available methods. Additionally, I would recommend this looker studio to whoever trying to learn data visualization and other reporting visuals.
Is this review helpful?
Yes
No
Profile Picture
Miloš Krstić
June 25, 2024
KPIBees has helped me input tons of data into Sheets. Even the free version is superb. I fully recommend this great add-on!
Is this review helpful?
Yes
No
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
Mike Kik
June 26, 2024
THIS MUST BE THE BEST TOOL EVER! THANK YOU KPIBEES FOR SAVING MY TIME AND BEEING THE BEST!
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
The Stage Door Choir
March 28, 2024
Still learning how to use the app but it looks like it will be useful!
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
Renny Htoo
June 13, 2024
An extraordinary feature of API that connects data source from not only JSON but also a variety of sources including CSV and other sources. I recommend this add-on for anyone who are trying to create a data source that can be used to present valuable findings. Everyone using this API will find it as interestingly easy yet useful tool.
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
1-10 of 120