Webhooks
According to the Arduino document library listing :
Webhooks allow you to send and receive automated messages to and from other services. For example, you can use webhooks to receive a notification when a property of your Thing changes. To do this, there are third party platforms that link the properties from your Arduino Cloud projects to the desired trigger action.
( https://docs.arduino.cc/arduino-cloud/features/webhooks/ )
So, yeah, I am thrilled to say that I found the webpage where I first read up on using the cloud to update my spreadsheet, as I thought it was lost! Funny enough it was from the document library on the arduino website, and it contains instructions on how to write/use a message applet that will upload sensor data to my spreadsheet.
Iām going to dig into this for now, and will post up a follow up once I see how well it works.