Arduino Data Logging to Google Docs (Spreadsheet)

Using Arduino and Ethernet Shield to send temperature data (LM35) to Google Spreadsheet.

Project 5 - Eksp. Jaringan Komputer kelas B
Aditya Riska Putra - PA/14450
Ahmed Reza Rafsanzani - PA/15030
Ryan Eko Saputro - PA/14638

[rza]

@OM M: We need to use pushingbox because the Arduino Ethernet shield can handle http but unable to handle https (googlescript uses https) and pushingbox resolved that problem.

[PDAControl]

Works perfect ... thanks for this great

[anmorgul]

I have aswer: for what "pushingbox", if googlescript work alone? may be write to scetch "GET" to the googlescript?

[RTRallyZone]

Hi, i'm trying to implement the same. However i get a 'bad value' instead of 'Ok' at minute 2:54. I'm sure I followed everything as how you did it. Any advice? Thanks

[Growlicole]

Thanks for sharing this awesome project!!!  I got the bad value line 25 error too. but then it works after I opened a new script file and changed '< spreadsheetid >' to " spreadsheetid " .

[fauzifirmansyah]

selamat malam, saya fauzi dr polban sy sudah melakukan percobaan sampai mendownload program ke arduino, lalu pada serial monitor arduino hanya menampilan connecting, connected, disconnecting dan temperature sent, dan pada google spreadsheet data yg muncul tidak terupdate, bagaimana solusinya terimakasih, regard

[NicholasGebinskiMachado]

There's a mistake, when you show us the http request to proc pushingbox, theres a ? after the devid, when you test the request you used a &.

That's what went wrong for me at least.

[ryanmchargue]

Do you think if I used a WiFi dongle it would work the same instead of using the shield?

[carltonleeful]

Hi trying to get this to work for pushing dust sensor data from Arduino to Google Docs. When I try to test the app, get:

TypeError: Cannot find function CreateTextOuput in object ContentService. (line 37, file "Code", project "Dust Sensor Data Pusher")

Any thoughts?

[abhi-ib]

it is saying " Bad DevID " everytime am running the url.. the id is the same as it is to the scenario ... what could be the problem ?

[ArielRCesped]

Hello! I am sending some values less than zero (i.e 0.01 volt), however, the Spreadsheet only sends 0.00. What's wrong?

[codewithyogapratama]

Assalamu'alaikum
Mohon maaf mas sebelumnya.
gi mana caranya saya mau ngirim 2 data dari arduino.
saya udah coba make kodingan yang dibawahnya.

case'column_C':
rowData[2]=value ;
break;

yang pushingBox udah saya tambahin di scenario nya masih gagaljuga mas
mohon bantuannya mas..
Terimakasih

Wassalamu'alaikum

[markstroemberg]

Hello, Thank you for your video, it was very helpful.
I have a question. Given that there is an API request limit for pushingbox (1000 requests/24h),
would it be possible to have arduino record the data on an SD card (every ~10 seconds),
and then upload the larger "packet" of data every certain amount of time
(say ~2 min, as this would be below the daily limit).
I've never used an SD card with the ethernet module on arduino,
so any comment regarding this issue would be appreciated!

[faisalisa]

how do i read other value for example from A3 and get the data to the new row? which part should i change?

[zonghong]

Hi, im using PIR sensor to obtain the sensor reading and send it to the spreadsheet. What can I do to reduce the time for each value to upload to speadsheet ? Currently, It took me roughly 7 seconds to send a value.

[tanmaygadekar]

Hi, I have successfully sent data from Arduino to Google Sheets. Is it possible to receive data from Google Sheets to Arduino via Pushing Box or any other similar method? Please explain the steps if possible.
Thanks.

[ParanoidAndroid]

could it be, that one needs A Google Cloud Platform account??
I don't see the "my apps" thing

i can edit scripts, but i still get the "line 25" thing when I paste the link to the app
and if I "Execute the app as: me" and Who has access to the app: "anyone" I get the "bad value" thinG

the file is set to edit and see public

any idea?

[waihokwok]

i copy the code to ardunio and change int baca_ADC = '1';
However, it doesn't work.


Arduino: 1.5.6-r2 (Windows 7), Board: "LinkIt ONE"

C:\Program Files In member function 'void W5100Class::init()':
C:\Program Files error: no matching function for call to 'SPIClass::begin(int)'
C:\Program Files note: candidates are: void SPIClass::begin()
C:\Program Files error: no matching function for call to 'SPIClass::setClockDivider(int, int)'
C:\Program Files note: candidates are: void
C:\Program Files error: no matching function for call to 'SPIClass::setDataMode(int, int)'
C:\Program Files note: candidates are: void
C:\Program Files In static member function 'static uint8_t W5100Class::write(uint16_t, uint8_t)':
C:\Program Files error: 'SPI_CONTINUE' was not declared in this scope
C:\Program Files error: no matching function for call to 'SPIClass::transfer(int, uint8_t&)'
C:\Program Files note: candidates are: byte SPIClass::transfer(uint8_t)
C:\Program Files In static member function 'static uint16_t W5100Class::write(uint16_t, const uint8_t*, uint16_t)':
C:\Program Files error: 'SPI_CONTINUE' was not declared in this scope
C:\Program Files error: no matching function for call to 'SPIClass::transfer(int, const unsigned char&)'
C:\Program Files note: candidates are: byte SPIClass::transfer(uint8_t)
C:\Program Files In static member function 'static uint8_t W5100Class::read(uint16_t)':
C:\Program Files error: 'SPI_CONTINUE' was not declared in this scope
C:\Program Files error: no matching function for call to 'SPIClass::transfer(int, int)'
C:\Program Files note: candidates are: byte SPIClass::transfer(uint8_t)
C:\Program Files In static member function 'static uint16_t W5100Class::read(uint16_t, uint8_t*, uint16_t)':
C:\Program Files error: 'SPI_CONTINUE' was not declared in this scope
C:\Program Files error: no matching function for call to 'SPIClass::transfer(int, int)'
C:\Program Files note: candidates are: byte SPIClass::transfer(uint8_t)

This report would have more information with
"Show verbose output during compilation"
enabled in File > Preferences.

[anwarbasher]

I've worked on a program to receive the data from the Arduino board to another Arduino board via serial to serial
Then the other Arduino linked me to the ethrnet board to send data to Google sheet.
When a connection TX and RX, I receives data in serial monitor but does not send anything to google sheet
void loop(){
if (Serial.available() > 0) {
suhu = Serial.readString();
}

[shrikantnikam]

Is it possible to send real time data on one cell update contioneously if possible then how? Plz help