I would love to see an example of sending data to a Google Spreadsheet.

Hey @whampus , can you tell us more about your use case? What are you working on? I’m not familiar with the Google Spreadsheet API, and whether it is possible to send data into a spreadsheet from an external service, although it seems like a fun and Google-y thing to do.

I would like my students to make their own wireless sensors for science class/projects. Data would automatically be sent to a pre-made google spreadsheet. It would even update a premade graph with the new data as it’s collected! It would be a lot of fun for long term projects like measuring plant…

Very cool! If you do start experimenting with Google API 3.0, please share your findings here; this sounds like a great way to collect data for analysis.

the easiest way to do this is to use google spreadsheet and create an entry form. once you have a form linked to the spreadsheet, you can use a traditional POST method. this is the way ive seen it done. its scrappy, but it works. here is a link to someone who’s done it this way for an arduino with …

The code listing on that open-electronics page uses Ethernet.h for the Arduino Ethernet Shield. Will the spark core be able to use this library directly or will a port be necessary? I, too, am looking to do an HTTP POST directly from the device to google spreadsheets.

@ke5in it will need to be ported, and they are working on that currently. It should be ready for release by or before the time they are shipping Cores for the kickstarter fulfillment :wink:

@ke5in it will require a small port; we are doing something very similar to Ethernet but it will be called TCP.h instead of Ethernet.h (because of course you’re not using Ethernet!) However you will likely find it easier to do things like this through the Spark Cloud.

@zach ok, I’ll look for TCP.h when it’s out. Question: Would I be able to contact the Cloud from the device and have the Cloud POST to Google docs OR will I have to have a second computer poll the device through the Cloud and then have the computer do the POST once i get the data from the device v…

I’m not terribly familiar with the Google Docs API but if all it needs is a POST request, then you should be able to register a callback and have it drop the data directly into Google Docs.

I believe you can do this with Google API v3.0, I am just worried about the security/oauth handling that would be necessary to access Google’s API. The only other way that I can think of without having to authenticate is by using a Google Form (as suggested by @avidan ). Does Google now require outh…

Sending data to google docs

Getting Started

NisseDILLIGAF January 27, 2014, 9:56am 12

Any news on this?

I found a way to post stuff to a google spreadsheet here…
(…see first answer)

Sending http request to enter data into a google spreadsheet

Topic		Replies	Views
Sending http request to enter data into a google spreadsheet Firmware	2	6877	February 15, 2014
Particle Electron send data to google spreadsheet Cloud electron	2	885	January 3, 2020
Pushing data to Google Docs Project Share	2	2504	January 7, 2021
Particle Photon + Wireless Temperature sensor + Google Spreadsheet Cloud	3	903	November 19, 2018
HTTPS POST to Google Sheets for Low (no) Power Spark applications Cloud	13	6667	February 1, 2016

Sending data to google docs

Related topics