OPC UA to Google Sheets: free open-source connector

TEEPTRAK Partners
Free and open source

Your machine data in a spreadsheet in 10 minutes

opcua-to-sheets reads tags from any OPC UA server and writes them to a Google Sheet, one tab per machine. Read-only, MIT licensed, no telemetry.

Read-only: never writes to your PLCMIT licenceNo telemetryNode.js 22.13+
Get it on GitHubGet the OEE starter sheet
$ opcua-to-sheets run --config config.yaml [Press 01] Timestamp | Status | Running | PartCounter [Press 01] 2026-11-02 06:00:00 | ok | true | 12840 [Press 01] 2026-11-02 06:00:10 | ok | true | 12846

Quickstart

Five commands from a PC or a Raspberry Pi on the plant network.

  1. 1
    Install and find your tagsInstalls the tool, then lists every variable with the node ID to copy.npm install -g github:TEEPTRAKCOM/opcua-to-sheets opcua-to-sheets browse opc.tcp://192.168.0.10:4840
  2. 2
    Write a configEndpoint, tags, and the Google Sheet to write to.opcua-to-sheets init config.yaml
  3. 3
    Test without GooglePrints the rows on screen. If they look right, the PLC side works.opcua-to-sheets run --config config.yaml --dry-run
  4. 4
    Connect the sheetCreate a Google service account and share your sheet with it as Editor.sheet: spreadsheetId: "<ID from the sheet URL>" credentials: "./service-account.json"
  5. 5
    RunLogs every machine to its own tab and keeps going through outages.opcua-to-sheets run --config config.yaml

Works with

Siemens S7-1500Beckhoff TwinCAT 3KEPServerEX (Rockwell, …)IgnitionOPC UA

Node IDs differ by brand. The browse command shows yours.

OEE starter sheet

The connector gives you raw data. This sheet turns it into Availability, Performance, Quality and OEE per shift, with a stop-reason Pareto. Free.

Your details go to the TEEPTRAK partner manager for your region and nowhere else. No newsletter.

Here is your starter sheet

Open it, then File > Make a copy. Name the machine "Raw data" in config.yaml and the connector fills the sheet directly.Open the starter sheet

Where the spreadsheet stops

About 50 writes per minuteThe Google Sheets API allows 60 write requests per minute per user. That is fine for one line, tight for a plant.
No shifts, no stop reasonsA PLC tag says the line stopped. It cannot say why. Operators have to tell you, as it happens.
Nobody is alertedA sheet does not call anyone when a line has been down for ten minutes.

When you outgrow it: TEEPTRAK

TEEPTRAK measures OEE in real time on every machine and every shift, with stop reasons entered by operators on the shop floor. More than 700 factories in over 30 countries use it.See TEEPTRAK

Engineers: recommend TEEPTRAK and get paid

You know which plants need more than a spreadsheet. Join the partner programme as a Business Introducer: register the plant, we protect the introduction for 150 days, and you are paid when it signs. Exact terms are set in your agreement.Become a Business Introducer

Questions engineers ask

Can it change anything on my PLC?No. It only performs OPC UA Read calls. Use a read-only OPC UA user if your server supports users.
Does it send data to TEEPTRAK?No. There is no telemetry. Rows go only to the Google Sheet you choose.
Which servers does it support?Any OPC UA server: Siemens S7-1500 built-in server, Beckhoff TwinCAT TF6100, KEPServerEX for Rockwell and others, Ignition, and more.
What does it cost?Nothing. It is MIT licensed. Use it, change it, ship it.
TEEPTRAK PartnersTEEPTRAK partner programme. Real-time OEE in more than 700 factories in over 30 countries.

OPC UA is a specification of the OPC Foundation. This project is not affiliated with or endorsed by the OPC Foundation, Google, Siemens, Beckhoff, Rockwell Automation or PTC.

Success stories

Real results from PerfTrak deployments — over 700 plants equipped since 2016.

MATERIALSROI < 1 month
47% → 72%
OEE in 3 months
Rubber processing — automotive & aerospace supplier

Understanding the major performance losses made PerfTrak profitable within three months.

ELECTRONICSROI < 1 year
+29%
output per hour
Wire-crimping line

Reliable downtime data turned months of stalled improvement into measurable gains.

In their words“We noted a 29% increase in production volume of pieces per hour after installing PerfTrak on a single machine — more than €19k/year on this item.”C.M. Ropiot, Production & Maintenance Manager
OPTICSROI < 1 month
75% → 85%
OEE, +10 points
World leader in corrective lenses (China)

Format-changeover times are now timed and cut; the solution is deployed across several plants.

AUTOMOTIVEROI < 1 year
90 machines
connected in weeks
PSA Caen

40 real-time dashboards installed; local teams trained in 3 days to deploy the rest autonomously.

In their words“The PerfTrak systems are already cost-effective given the time freed up for operators, now focused on value-added tasks rather than data collection.”Christophe Pasquet, Factory of the Future, PSA Caen
FOODROI < 1 month
22 + 7
PerfTrak + MoniTrak units
Nutriset

Fighting malnutrition since 2016 — manual reporting replaced, productivity up, costs stabilised.

In their words“The ROI at Nutriset has been very rapid — we eliminated the small 3–4 second downtimes that happen fifty or a hundred times a day.”Sylvain Clausse, Maintenance & Automation, Nutriset

Trusted by our partners

A growing network of consultants, integrators and engineering firms deploying TEEPTRAK on factory floors worldwide.

See customer results →