Go Down

Topic: Webhook - How does it work? (Read 282 times) previous topic - next topic

annikaze

Hi! I am relatively new to Arduino so this might be a stupid question, but it would be great if someone could help me.

I've successfully connected MKR WIFI 1010 to the cloud and receive sensor data on the dashboard. Now I want to send this data (updates every 30 seconds) to a Google spreadsheet.

I've tried:

- A Google Script, following this tutorial: https://create.arduino.cc/projecthub/Arduino_Genuino/arduino-iot-cloud-google-sheets-integration-71b6bc?ref=part&ref_id=64347&offset=9

- A IFTTT webhook

- A Zapier webhook

I pasted the respective webhook link into the provided field in the IOT cloud but with all three options, I don't receive any data and I don't understand why. Do I also have to change something in the Arduino code to actually send the data?

jld13

I was able to get it to work with the following changes:

Change lines 22-26 from:

Code: [Select]
// get active spreasheet
var ss = SpreadsheetApp.getActiveSheet();

// get sheet named RawData
var sheet = ss.getSheetByName('RawData');


to:

Code: [Select]
// get sheet named RawData
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("RawData");


Note the name "RawData" is the name of the sheet in the spreadsheet where you want the data to fill.  Make sure they match.  I was not able to get this to update and had to delete the project and make another.  If you put the url into your browser the only error you should get is "Script function not found: doGet" because we haven't coded for a GET just a POST.

Go Up