Import data from databases, APIs, and files into Google Sheets™ with scheduled refreshes and automation
By:
Listing updated:May 12, 2026
Works with:
245K+
Overview
Video tutorials: https://www.youtube.com/channel/UCC3HmpFen0McyRNoOzFFazA/videos

KPIBees brings external data into Google Sheets™ so you can build live dashboards and automate reporting. Connect databases, APIs, files, or websites, then schedule refreshes to keep your spreadsheets always up to date—no Apps Script required.

⇨ Use cases
  • Marketing & analytics reporting (weekly KPIs, campaign performance)
  • SEO & site monitoring (sitemaps, on-page tables, structured data)
  • Finance & ops (sales, inventory, P&L from your data warehouse)
  • Data engineering workflows (JSON/XML parsing, CSV pipelines)
  • Ad-hoc analysis directly in Sheets

⇨ What you can import
  • Databases: popular SQL engines such as MySQL, PostgreSQL, SQL Server, Oracle
  • APIs: REST endpoints returning JSON or XML (with JSONPath/XPath support)
  • Files: CSV/TSV from a URL or cloud storage
  • Web pages: import HTML tables and sitemaps

⇨ How it works
  1) Pick a data source
  2) Select the destination cell in your sheet
  3) Configure the query (fields, filters, parameters)
  4) Save & Run
  5) (Optional) Add a refresh schedule

Create and manage multiple queries per spreadsheet. Re-run or edit any query at any time.

⇨ Request integrations
Vote for new sources or suggest one: 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 GDPR compliant)
  • Privacy Policy: https://kpibees.com/legal/privacy-policy/
Additional information
PricingFree of charge with paid features
Developer
Non-trader
Support
Privacy policy
Terms of service
ReportFlag as inappropriate
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
Michael Krause
July 8, 2025
KPIBees is a MOST EXCELLENT add-on and does just what it's advertised to do! It's easy to install, easy to implement and easy to manage. While it is another add-on so naturally has it's own user interface, it IS very streamlined in that it's not overloaded with anything more than what's needed. Thanks VERY much for the wonderful UX.
Is this review helpful?
Yes
No
Profile Picture
Hteik Htar Tin
April 23, 2026
It is a really effective visualization tool to use. Great!
Is this review helpful?
Yes
No
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 12, 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
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
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
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
Mike Kikot
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
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 112
Search
Clear search
Close search
Google apps
Main menu