I have a Nano 33 iot connected to the Arduino cloud correctly uploading temperature data in float format. All good.
I have created a Google Sheet and associated script.
The script should download data from the Arduino cloud into a sheet.
The Google Run button runs the script without error.
I have generated a web hook https url in google.
The Arduino Things Setup page will not allow the Google scripts web hook generated URL to be entered into the Setup page.
And the question is?
how do i get setup to accept my web hook url
Yes. And i enter the Google Sheets script generated URL into the Setup Webhook edit box
https://script.google.com/a/macros/richardsnet.net/sAKfycbwYO....Qp8w7mz9H5B5ca/exec
but It will not be accepted by Arduino.
Sorry, no idea what could be wrong. I assume your long URL is correct. Is there a log of some sort that may provide clues?
I have multiple devices Things working OK on the Arduino Cloud.
I have not used Web hooks previously.
I have followed the advice on the Arduino web Documentation for web hooks and used Claude to correct some errors in the Google script which runs without error in Google.
What makes the url valid for Arduino?
Did you follow this document
https://docs.arduino.cc/arduino-cloud/features/webhooks/
Yes I followed post #8 and post #4 except that I have generated the url in Google Sheets from the Deploy tab.
I am out of ideas.
I have now created in Google Sheets a Arduino valid URL
I have set the Google web hook settings
options as per attachment
Arduino Setup now says Google Web hook Active but I am not receiving any data into the Google Sheet. Perhaps a Google script issue.
Although the Set Webhooks window accepts the Google Scripts generated URL the next window which opens in the Setup Webhooks merely displays a generic json data format which is not editable. The window also says the URL is now Active!
(Note there is no variable with the name 'humidity' in my sketch). According to the Arduino Webhooks docs there should be another input window which will accept my particular data variables which I wish to Post to the Google Sheet but it never appears!
Why not? I have a paid Arduino subscription and several devices/things uploading the dashboards.
Are Webhooks to a Google Sheet not supported by a Maker Plan?
These are the two windows from Setup Webhooks.
Should there be some specific code in my sketch which explicitly declares there is a webhook?
Where do i enter the cloud variables to be sent to Google Sheets?