Makers Blog

Send PLCnext data to Google Sheets

Sidnei Marcondes 04 November 2021 min. read
1,362 views 1 comments

I would like to share with you another idea for data acquisition using PLCnext

Today, when we need to log data, we can store this data locally on the PLC’s memory card in a CSV or SQLite file format (free solution, but with restricted access and space) or we can send this data to the cloud and store it in some service (which are usually paid but allow remote data access) such as Proficloud, AWS, Azure.

What if we had the best of both worlds?

The proposal is to send the data collected from PLCnext to a Google Sheets spreadsheet. In this way, we will have data with remote access and free of charge up to 15GB (and low cost for expansion)

I created a manual with the Google Sheets setup procedure and a library for PLCnext to send the data. You can find this solution in the PLCnext Store with the name Datalogger_Googlesheets (PLCnext Store | DataLogger_GoogleSheets)

I hope this solution can be useful for you.

Note:

The Makers Blog shows applications and user stories of community members that are not tested or reviewed by Phoenix Contact.

Discussion

Please login/register to comment
Login/Register
Newsletter
Never miss a new article
Sign up for the newsletter
Never miss news about PLCnext Technology
Get interesting content via newsletter four times a year
Receive exclusive information before all other users