KPIBees

By KPIBees

Pull data from databases, APIs, files, and marketing tools into Google Sheets on a schedule.

Google SheetsData ConnectorsScheduled RefreshMarketing Data
Overview

What is KPIBees?

KPIBees is a Google Sheets add-on that imports data from databases, APIs, files, web pages, and marketing platforms into spreadsheets. It runs in a Sheets sidebar, supports custom SQL queries, and refreshes data hourly, daily, or weekly without Apps Script. Connectors include MySQL, PostgreSQL, SQL Server, Oracle, MongoDB, Google Analytics, Google Ads, and Facebook Ads. Marketers, agencies, analysts, and small business owners use KPIBees to build live reports and dashboards in Sheets.

Best for
Digital MarketersMarketing AgenciesData AnalystsSmall Business OwnersOperations Teams
Product snapshot
Category
Data Extraction & Collection
Best for
Sheets reporting automation
Deployment
Cloud
Free trial
Yes (free plan)
Integrations
Google Ads, MySQL, PostgreSQL, Analytics
AI features
No
Key features

Key features of KPIBees

Database connectors

Query MySQL, PostgreSQL, SQL Server, Oracle, and MongoDB from Sheets.

Marketing data imports

Pull Google Ads, Analytics, Search Console, and Facebook Ads data.

Scheduled refresh

Refresh queries hourly, daily, or weekly to keep reports current.

API and file imports

Load JSON, XML, CSV, and TSV from URLs or cloud storage.

Custom SQL queries

Write your own SQL to shape data before it lands.

Error notifications

Receive email or Slack alerts when a scheduled job fails.

Reviews

KPIBees reviews

20 reviews

Overall

4.7/5

  • Ease of use4.6/5
  • Features4.4/5
  • Value for money4.6/5
  • Customer support4.7/5

What users like

  • Quick setup inside Google Sheets
  • Many data sources in one place
  • Responsive and helpful support team
  • Scheduled pulls save weekly hours

What users dislike

  • Missing social media connectors
  • Interface feels rough at first
  • Free plan has tight limits
  • Database queries require SQL knowledge

Neels V.

Owner

“Liked the simple setup, intuitive interface, and wide range of connectors in one place. Found the Facebook Ads connector offers only a limited set of data points.”

Marine S.

CEO

“Liked the easy setup and maintenance, compatibility with many sources including APIs, and fast support. Found it needs more integrations, such as Instagram and Twitter.”

David N.

AVP Digital Marketing

“Liked the good value, key martech integrations, and easy monthly re-runs of reports. Found it is a newer tool with some rough edges and a user interface that could improve.”

Simon L.

CEO

“Liked the easy setup, strong support, and scheduled pulls from multiple connections. Found it cannot yet use pulled data to make follow-up requests, a feature listed on the roadmap.”

Write a review

Sign in with your account to review KPIBees.

Sign in to review
Integrations

KPIBees integrations

KPIBees connects Google Sheets to databases including MySQL, PostgreSQL, Microsoft SQL Server, Oracle, and MongoDB, with support for custom SQL queries. Marketing connectors cover Google Analytics, Google Analytics 360, Google Ads, Google Search Console, and Facebook Ads, and the product also lists Intercom, Typeform, and Wix. For other sources, KPIBees imports JSON and XML from REST APIs using JSONPath and XPath, CSV and TSV files from URLs or cloud storage, and HTML tables and sitemaps from web pages. Scheduled refreshes run hourly, daily, or weekly, and job alerts can be sent by email or Slack. Sheets data can then feed Looker Studio dashboards.

FAQ

Frequently asked questions about KPIBees