Webhook / Arduino IOT Cloud to Google Sheets configuration

Hi, I need some advice, so first, this is what I have right now:

  1. I have Arduino IOT cloud Thing and it works very good, more than a year now.
  2. These are the Cloud variables I`m using :
    cloudVariables
    and all the variables are set to update onChange.
  3. Following this tutorial https://docs.arduino.cc/arduino-cloud/features/webhooks , I`ve managed to set a webhook, and now my Cloud variables are stored in Google sheet, BUT not in the order I want to.. This is how it looks now :
    sheet_example

So as you can see, every time any of the variables are changed, new data row is added to the sheet, but all the different variables are in the same column.
Finally the question, I need every cloud variable to be stored in it`s own column of the sheet, is that possible and how?

No suggestions on this?

Well I`ve done what I needed with the help from chatGTP :wink:
Google sheets are edited with "google script" so this was no question for Arduino forum after all.

1 Like

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.