Data from Google sheets
Is there a way to acquire data from Google sheets? We have a steady stream of data coming from an OPCUA server - like Canary was designed for. There is also a bit of manual data that would useful to plot on top of this automation data. It is a data point that is calculated in a Google sheet from manually inputted data entered maybe once a day at the most, maybe every couple of days.
-
Hi glenn
We do not have a direct method for reading data from a Google sheet but we do have a CSV Collector if you could generate a CSV file with that data.
https://helpcenter.canarylabs.com/t/q6hj7k2/how-to-configure-the-csv-collector-version-22
We also have a Data Entry tool in Axiom which allows a user to manually enter values that get stored in the historian. If the values need to exist in the Google sheet then this would be another step in the process to enter the value in Axiom.
https://helpcenter.canarylabs.com/t/q6hj7fn/data-entry-control-version-22
Print this page