Makers Blog

Send PLCnext data to Google Sheets

Sidnei Marcondes 04 November 2021 min. read
616 views 4 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. Use them at your own risk.

Discussion

Please login/register to comment

Login/Register

Leave a Reply

Marcel PLCnext Team 02.12.2021

Interesting idea, well done. 👍

Login / Register to reply
EliKa 01.03.2022

I did use it its perfect , well done

Login / Register to reply
Michael89 29.04.2022

Just what I'm looking for. Thank you! Fyi, link is bad. This one works: https://www.plcnextstore.com/us/app/1332

Login / Register to reply
Martin PLCnext Team 03.05.2022

I have updated the link in the main post. It should now work for everyone.

Login / Register to reply
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