Skip to content

posting sensor

.

WIZnet

Published February 21, 2023

694 UCC

229 VAR

Original source (new tab)

posting sensor

Project description

DETAILS

posting sensor

 

This project is an example of an Ethernet shield.
The user can monitor sensors easily by using the Arduino platform through the Web.
This project would be included in the Sensing & Gathering category of WIZnet Museum.

Let us get right into this. I was logging temperature of a room to an Excel sheet via Serial.print commands, then importing CSV files and yada yada. I couldn’t get to the data unless I was at home, and also I had to leave my computer running in order to log the data. I needed a better way to log temperature (or anything for that matter) and be able to access it from anywhere.

Google Docs is a great free service that fits the bill perfectly. There are tons of tutorials showing how to do this HOWEVER they are all out of date due to Google changing things up on their forms. So I am here to re-write everything I learned to help you get started and logging real time to the internet. You will need: Arduino R3 Ethernet shield (probably can be done with a YUN or WiFi, but I used Ethernet.) ** I added a screenshot of my dashboard which displays all the data that I am collecting. This is all based on 3 temperature sensors.

Get the Required Account

Get the required accounts:

1. Google. Get a google account. You should probably have one by now. FREE

2. Get a pushingbox account via pushingbox.com. FREE and it uses your google account for user info.

 

Create a Google Form and Get FORM KEY

Picture of Create a Google Form and Get FORM KEY

 

 
  • Inside of Google Drive you can create a ‘Form’ . For the sake of making this simple, I will create a single question select the short answer response form as shown. When that is complete, click send form.
  • A screen will pop up which will have an option to show URL. Click that(shorten URL) then Copy the URL that spits out.
  • Past that into your web browser and you will find yourself in the form you created.
  • From here you will need to right click and select ‘Inspect Elements‘. This will load the HTML code for the form. You are looking for the line of code that is defining the Text input box. You will find a section of the code that is “entry.1315919601

” (numbers are dependent on you)Take note of this. I will be referring to this as “FORM KEY”

Comments

Comments