Oracle Database + 
Google Spreadsheets =
Are you looking for an easy way to connect your Oracle Database to Google Sheets? Meet KPIBees, a Google Sheet Add-on that helps you achieve that in just 2 minutes, by enabling you to write SQL queries directly inside the spreadsheet!
Your business Oracle Database dashboards and reports will be filled automatically. This will save you from a ton of copy/pasting!
To connect your Oracle Database to Google Sheets and pull SQL queries directly in the spreadsheet, please follow these steps:
Step 1: Install the KPIBees Gsuite Marketplace Sheets Add-on.
Step 2: Allow KPIBees standard Add-on access to your Google Account.
Step 3: Open any spreadsheet and go to the Add-ons menu. Select KPIBees and click on Launch.
Step 4: Click on the Oracle Database connector.
Step 5: Add your database connection details. Please note that your database server should be opened for connection from our IP 94.130.18.249. It’s always recommended for security reasons to create a read-only user! Once you’ve added the connection details, click on Create.
Step 6: After you’ve connected your database, you can write SQL directly inside Google Sheets and pull any data from your Oracle Database!
Step 7: Besides the Oracle Database connector, KPIBees enables you to pull data from a lot of other sources and you can create reports for your business without any hassle!
Step 9: After you’re done with setting up for your queries, you can also set notifications & data refresh triggers which enable you to refresh your created queries automatically!
KPIBees supports a lot of other integrations that enable you to create incredible business reports that include your Oracle database: Here are all the Google Sheets integrations that KPIBees supports:
