send data to ESP (from google sheets/script)?

[2000ede]

Hello,

What way is there to send value from the internet or google sheets to the ESP so that it has it available as a variable (other than mqtt)?

I ask because HTTP/S Get probably doesn't work.

So how can I send, for example, football results or values ​​from Google Sheets (I know the Google Sheets/Script Programming). I need how ESP Easy can receive it.

The ESP should then show it on a display.

Thanks

[2000ede]

found it

Example:
http://192.168.178.133/control?cmd=event,Verbrauch=2343

[2000ede]

How is it possible to pass a string using this method? And if that doesn't work, is there another option?

[Ath]

How is it possible to pass a string using this method? And if that doesn't work, is there another option?

That's documented in this paragraph, include a wildcard (*) in the event handler like "on event#name=* do"

[bidrohini]

I think you can check IFTTT. You can check this out: https://www.theengineeringprojects.com/ ... esp32.html

You can publish multiple sensor readings from ESP32 to Google sheets via the IFTTT web service. To do the opposite, it requires a bit more setup compared to sending data from the ESP32 to Google Sheets using IFTTT. You can create a web server on the ESP32 using Arduino IDE or ESP-IDF, which can receive HTTP requests.
Handle the incoming HTTP request from Google Sheets in a specific endpoint on the ESP32.
Extract the data sent from Google Sheets and process it accordingly.