Webhook Returns Undefined Values into Google Sheets

[JeffThor]

I am relaying values from an ultrasonic range detector to Google Sheets using a webhook. I have had success using Gustavo Gonnet’s tutorial. My values are being filled into Google Sheets but all the values (except timestamp) are shown as undefined. I haven’t found a solution yet. If you need any screenshots, or code, I am happy to post.

Thanks!

[gusgonnet]

Hi Jeff,

have you looked at some other tips given by the community on this thread?

Uploading Electron Data to Google Drive

hey, I found the way to save data pushed from your particle into a google sheet. I followed these instructions for the google sheet configuration: http://railsrescue.com/blog/2015-05-28-step-by-step-setup-to-send-form-data-to-google-sheets/ Then created a particle webhook with: event name: googleDocs full url: what you get from google docs (example: https://script.google.com/macros/s/1236278936489127634-2876348/exec) POST form: key=name value={{my-name}} headers: “Content-Type”: “app…

You mention you had success on this, so is this a new project? a new spreadsheet?
One thing to note is that the columns have to match what is being pushed in the webhook...

[JeffThor]

The man himself!

I did read this over, and as far as I can tell, I can't see anything that would solve my problem. I am new, so it is possible that it is something that I am overlooking. This is my first project with Particle, and I created the spreadsheet as per these instructions. I have had success in terms of all the other steps leading up to this.

This is the header in my spreadsheet.

This is the line in my code that publishes my data:

Particle.publish("MySensor", String(finalRange));

Is this what you meant by...

@gusgonnet

the columns have to match what is being pushed in the webhook…

I have mostly kept everything else unchanged from what was in your tutorial.

[gusgonnet]

hehe, Hi Jeff,

cell B1 shows MySensor but the original page shows name:

unless you know how to change the javascript code, I’ll leave a name there
That is usually the cause of the undefined…
Hope it helps!

EDIT: I remember changing column names once but never came back to modify the write up. Maybe in 2019?

[JeffThor]

@gusgonnet

cell B1 shows MySensor but the original page shows name:

I changed it from name to MySensor while trying to fix the original problem. I put original column names back and still seeing undefined results come in.

@gusgonnet

EDIT: I remember changing column names once but never came back to modify the write up. Maybe in 2019?

Not exactly sure what this means, sorry!

[gusgonnet]

Hey Jeff,
I must admit this is a very difficult topic to troubleshoot since it contains many moving parts.
What I would suggest is to re-do the whole thing, carefully, making sure not to miss a step.
I know, not pleasant, but might save you a lot of troubleshooting time.
Gustavo.

[JeffThor]

After going through again, I realized that I did not exactly replicate the form data.

After realizing that that is what ties it to the column, it is now working! Thank you Gus! Legend!

[gusgonnet]

@JeffThor

it is now working! Thank you Gus!

ultra excellent to hear that, Jeff, and congrats to you for trying the whole thing again and finding the mistake!