Database connectors
Query MySQL, PostgreSQL, SQL Server, Oracle, and MongoDB from Sheets.
Pull data from databases, APIs, files, and marketing tools into Google Sheets on a schedule.
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.
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.”
Adam L.
CMO
“Liked the easy install, many data sources, and how quickly tables can be set up in Sheets. Found the tool not intuitive at first and the interface weak.”
John H.
Analyst
“Liked having all metrics centralized in one place and how easy it is to refresh and manage the data. Noted no major drawbacks.”
Louka C.
Head of Marketing
“Liked the many possibilities and how flexibly it works inside Google Sheets. Found some connectors missing, especially for social networks.”
Ken W.
Product Manager
“Liked how easy it is to use and how quickly it imported and segmented an XML file. Found the free version limited and wanted a visible counter for remaining API credits.”
Yozet Rafael B.
Engineer
“Liked how easily it imports database data into Google Sheets. Found that using it well requires knowledge of SQL, which may limit less technical users.”
Leonardo W.
Founder
“Liked that it is essential for agencies and businesses running multi-channel ads and is easy to use. Found that some integrations need extra setup work.”
Beverly L.
Digital Marketing Manager
“Liked the easier query management and the ability to name queries. Found no bulk delete option, a low monthly query allowance, and no Google Local Services Ads data.”
Mark L.
IT
“Liked the easy setup and fast extraction of Google Analytics data. Found it hard to aggregate multiple Analytics accounts and that queries must be built one at a time.”
Chris C.
Business owner
“Liked that it saves hours of data work each week through an easy interface. Found that only one Google account can be signed in at a time.”
Rafael L.
Growth leader
“Liked connecting databases to Sheets and running custom SQL queries. Found some features do not work as well with other databases as they do with PostgreSQL.”
Ramona M.
Operations Assistant
“Liked the fast loading and the duplicate-query feature that saves setup time. Found that several pending integrations, such as Google My Business, are still needed.”
Piotr K.
Marketing Automation Specialist
“Liked that it imports large XML feeds that Google Sheets cannot handle natively and runs fairly fast. Noted no major drawbacks.”
Majd H.
System Analyst
“Liked the automated jobs, real-time error capture, and email and Slack notifications. Found it lacks automatic CSV or XLSX output delivered by email or Slack.”
Bruna M.
Senior Business Intelligence
“Liked the simple, fast, real-time delivery of data into spreadsheets. Found problems handling fields that contain a large number of characters.”
Frederic H.
Data Scientist
“Liked the many database connectors and one-click data fetching. Found the query editor small and wanted it larger or with syntax coloring.”
Prashant G.
Partner
“Liked the easy connection to Microsoft SQL Server databases. Found pricing based on extraction volume less appealing than a fixed monthly price would be.”
Marketing data reporting
Wide marketing connector library for spreadsheets
Scheduled data imports
Many sources into Sheets and BigQuery
Live spreadsheet data
Syncs CRM and database data into Sheets
Agency client reporting
Marketing connectors with ready report templates