How to Connect Oracle to Google Sheets – Stream Live Enterprise Database Data

Connect · Oracle to Google Sheets

Get data from Oracle into Google Sheets

Pull live rows from your Oracle database into Google Sheets and refresh them whenever you like. No CSV uploads, no Apps Script, no copy-paste. About ten minutes the first time, and the Free plan covers it.

About 10 minutes No coding needed Data stays on your network Any browser, any device

What you’ll end up with

A Google Sheet showing the live results of a SQL query against your Oracle database, with a button that pulls the latest rows whenever the data changes. Like this:

Sales Saved to Drive

FileEditViewInsertFormatDataToolsExtensionsHelp

	A	B	C	D	E
1	customer_id	first_name	last_name	country	total
2	1042	Maria	Alvarez	USA	1,284.50
3	1043	Daniel	Okafor	USA	612.00
4	1047	Priya	Nair	USA	2,090.75
5	1051	Thomas	Berg	USA	338.20
6	1056	Lucía	Ferreira	USA	1,455.00
7	1060	Kenji	Sato	USA	874.10
8

+ customers Sheet1 Live from Oracle

Oracle holds your data on a server you or your team run. Getting it into Google Sheets usually means CSV exports that are stale the moment they land, or scripts nobody wants to maintain. Query Streams skips that: a small helper program called the Agent runs the query where your data is, and a Google Sheets add-on asks it for the rows you want. Only the results travel, over an encrypted link, and Google Sheets can be anywhere: any browser on any device.

What you’ll need

A Query Streams account

The Free plan is enough for this guide. Sign up at my.querystreams.com.

The Agent on a computer that can reach the server

A small program that runs in the background and queries the database when Google Sheets asks. Often the database server itself, or any always-on computer on the same network.

Your Oracle connection details

The server name, the database name, and a username and password that can read it. If someone else manages the database, this is the bit to ask them for.

Connect it in five steps

1. Create your account

   Go to my.querystreams.com and sign up. Pick the Free plan. It is a real plan, not a trial, and it covers connecting your Oracle database and running queries from Google Sheets.

2. Install the Agent on a computer that can reach the server

   Sign in, open Download, and install the Agent on a machine that can already reach your Oracle database: often the database server itself, or any always-on computer on the same network. It takes a minute and starts on its own from then on.

   Why a small program instead of a driver? The Agent is one install for Windows, Mac or Linux (about 85 MB on Windows, a little over 100 MB on Mac and Linux) that runs quietly in the background. It makes one outbound, encrypted connection to Query Streams, the same way a browser does, so you open no firewall port and set up no VPN. Your database stays on your network, and the rows travel to wherever you are, across the internet if need be. The only thing on your side is the add-on.

   The Download page shows Your Access Key. Paste it into the Agent when it asks, and wait for the badge to read Connected to Query Streams. That is the only thing you do on the Agent itself.

   Full walkthroughs if you want them: Windows, Mac, Linux.

3. Point it at your Oracle database

   Back in your browser, open Data Agents (under Data in the top menu). Your Agent is listed there. Click Add connector, choose Oracle, and fill in the details you gathered earlier:

   Connection name

   Any name you will recognise later, like Sales database.

   Server/Host

   The Oracle server name or IP address, like erp-db.company.com.

   Port

   The Oracle listener port; leave it at 1521 unless your admin changed it.

   Service Name

   The Oracle service name your admin gives you, like ORCL; fill this in, or the SID below.

   SID (if no Service Name)

   An older style of Oracle database name; only use it if you were not given a Service Name.

   Username

   An Oracle login that is allowed to read the data.

   Password

   The password for that Oracle login.

   Click Test connection. When it reads Connected (or Signed in), click Next. The next screen, Which databases do you want to work with?, lists the databases this login can see: tick yours. No list? Type the name under Type a database name and click Verify. Then click Next through Data realm and finish with Create connector. The connection reaches your Agent within a few seconds.

   Open Data Agents

   Test failed? Usually the server name or a firewall between the Agent’s computer and the database. Try the same details from that computer with your usual database tool; if that fails, the Agent will too.

4. See your data in Query Builder Optional

   You can look at your Oracle database before Google Sheets is involved at all. Open Query Builder in the portal and pick the connection you just made. The Schema tab lists your tables and columns, and clicking one puts its name in the editor, so you can write a query without remembering exact names. Click Run and the rows appear under Results. Query Builder is on every plan, Free included.

   On Business plans you can also ask Nova in plain English (“show me customers in the USA”) and it writes the SQL for you. When the query looks right, save it: from Personal Core up it shows in the add-on’s Saved Queries list, and on any plan you can copy the SQL into the next step.

5. Add Query Streams to Google Sheets

   Open any Google Sheet, go to Extensions → Add-ons → Get add-ons, search for Query Streams, and click Install. Or install it straight from Query Streams on the Google Workspace Marketplace. Google will ask you to allow the add-on; that is normal.

   Afterwards it is in every Google Sheet you open: a Query Streams icon in the side panel on the right, also listed under Extensions. There is no separate sign-in. It recognises the Google account you are already using, so that email needs to be the one on your Query Streams account.

6. Pull in your first table

   Click the Query Streams icon in the side panel on the right of the sheet (or find it under Extensions). Choose Query Streamer and pick the connection you just made.

   Type the query you want to run. This one pulls a few columns from a CUSTOMERS table:

   Example · SQL

   SELECT customer_id, cust_name, city
   FROM customers
   ORDER BY cust_name
   FETCH FIRST 100 ROWS ONLY;

   Under Destination Sheet pick the tab the rows should land in, then click Run Query. The rows land in that tab in a second or two. Click Run Query again any time the data has changed and the tab updates in place.

   Don’t know SQL? Build it in Query Builder first and paste it here, or pick it from Saved Queries if you saved it.

Good next moves

• Save the query in the portal so you can run it again with one click, from Google Sheets or Excel.
• Add a filter such as a date range, so the same query can answer “this month” without editing.
• Share the results with a colleague. They see the rows, not your credentials.

Questions people ask

Related guides

• Oracle to Microsoft Excel
• Microsoft SQL Server to Google Sheets
• PostgreSQL to Google Sheets
• MySQL to Google Sheets
• Power Query for Google Sheets
• All guides