Import virtual pin in google sheet with restful api

Hi, I’m trying to have a google sheet where I can visualize some virtual pin data (with a 5 min auto refresh).
I was planning to use the http api:
Does anyone have experience with this thing?

Wouldn’t you be better to use the google docs API to send data to your spreadsheet from your MCU?

Pete. I was thinking on doing something like this but I wasn’t able to get it working…

Just discovered that with curl I get the value… But still no way to automate the import with sheet :roll_eyes: