KPIBees: Easily Automate Data Import Into Google Sheets
With KPIBees, you won’t get tired of copy pasting KPIs or other important data into your spreadsheet again.
KPIBees is a Google Sheets Add-on that resides directly in your spreadsheet and it’s really easy to pull any kind of external information and have it auto-update on a regular basis. With 21+ different sources to pull data from, you’ll have more time analyzing data than you importing them manually.
KPIBees Pricing Overview
KPIBees price starts at $12.49 per month for a personal plan, which already gives you full access to this tool, and allows you to add it into an unlimited number of spreadsheets, reports, and templates. The price scales if you want to have more Query Credits and Query Rows Limit.
Alternatively, KPIBees is offering a limited lifetime deal on Appsumo which starts at $59 for a single-code deal. Find out more about KPIBee’s lifetime deal below:
Find out more details about their lifetime deal here »
Price starts from:
$12.49 per month
✅ Has a free version
✅ Save more when you subscribe to a yearly plan
Lifetime Deal price starts from:
$59.00 – Single payment for a single-code deal
👉 One-click access to all your favorite tools – from databases to marketing tools.
👉 Create a query from your data source by selecting a spreadsheet cell and selecting the fields you require – for example, write SQL directly in the spreadsheet!
👉 Auto-refresh queries and receive email and slack notifications whenever it happens. Keep your spreadsheet data updated and in-sync with its sources.
👉 Retrieve tables, Xpath, JSON, XML, and CSV data.
👉 Connect your spreadsheet into 21 different sources of data such as: Google Analytics and Search Console, Youtube, Wix, MySQL, Facebook, and more!
KPIBees Use Cases
👉 Digital agencies who build ads dashboards and share them with their clients
👉 People that provide updating database spreadsheet reports to others without giving access to the database.
👉 Viewing API (JSON/XML) responses in a nicely formatted way.
👉 E-commerce shops building a fulfillment system in spreadsheets.
👉 Traders pull data from various stock APIs and make informed decisions.
👉 People that built a website from a spreadsheet and used KPIBees to populate the data.
Things to Note About KPIBees
👉 It cannot retrieve the entire google results, just limited to the 1st page
User Reviews for KPIBees
I tested the tool and think it has a very huge potential.
It’s fast, simple to use, and the addon has UI, I feel just that the fonts used could be bigger for better readability.
I followed their youtube tutorials to check some extras settings with the XPATH fields and they were clean and super simple to follow.
I tried and worked perfectly these 3 (XML, YOUTUBE, HTMLSCRAPER).
The “beta” (hence not yet FINAL) integration with Google page speed gave me a 500 Error, no matter what, I could not execute the query. But being Beta it is temporary, and for sure will be fixed.
The scheduler part is easy to set up, very basic but helpful to keep things updated and also have a mail alert feature so you’ll be updated for changes.
I am giving 4 stars for these simple reason:
There are 17 integrations coming soon: 13 are “final” and 3 are still BETA (but for example the Youtube one is working flawlessly here), hence I would have given 5 if they had at least the same number of integrations ready.
by digitalfastmind_dot_com | From Appsumo | ⭐⭐⭐⭐ –
The webscraper functionality is really great. It gets the data I need and it can be scheduled. Scraping costs a couple of credits (3 for each scrape with under 100 rows scrape results) but I heard that KPIbees is planning to make this deal stackable.
This is a real timesaver for me. Only the webscraping functionality makes it worthwile for me. But I saw that it has a lot of integrations available with which one should be able to make a customized digital marketing dashboard into Google Sheets. And the great part of it that you can make your own calculations in Google Sheets. This is something I will defnitely check out in the future.
by EZni | From Appsumo | ⭐⭐⭐⭐⭐
Some days ago I was looking for a solution to copy XML files into Google Sheets and I found KPIBees.
It works perfectly and I’m using it in combination with SimpleSpread to create a website for a client so:
👉 XML is always up to date
👉 Thanks to KPIBees the Google Sheet is always up to date
👉 Thanks to SpreadSimple the website is always up to date!
I think it’s an amazing combination.
Also, it can be used for reports (also in combo with Oviond for data that are not directly available) and for Scraping, so it’s a super useful Tool for every person who use Google Sheet!
by Alessandro | From Appsumo | ⭐⭐⭐⭐⭐
Don’t be intimidated, its really easy to add to Google Sheets and the tutorials are short and very clear.
Its great just in Sheets but when combined with WP Ninja Tables plugin, WpDatatables, SpreadSsimple or tons of other WordPress plugins which can publish Google Sheets data live to WordPress sites the possibilites are truly endless.
by Nicolai | From Appsumo | ⭐⭐⭐⭐⭐
I’m an avid user of Google sheets for tracking our marketing activities, content calendar, SEO etc.
The tedious part has always been updating the number which most of the time required someone in my team to manually input all the data each month.
Some activities were plain simple impossible as they would have required too much data entry and overall work.
Few minutes after playing with KPIBee I’m already in love and managed to get some kick-ass sheets with all my data in sync with our data sources. Can’t wait for them to add more and more connectors to have a unified view of everything!
by DivByZero | From Appsumo | ⭐⭐⭐⭐⭐
Find more Software Lifetime Deals with us!
Join our Facebook group of more than 6000 entrepreneurs to discuss about software lifetime deals and find more amazing deals like this!