Google sheet as json endpoint for sensor?

1

Hi

I am planning to integrate a sensor based on data from a google sheet. I tried to use the rest sensor platform to import the data, but I can not get it to work. The sensor shows, but no data. What am I doing wrong, and is this the best approach to get data from a google sheet to Home Assistant?

  - platform: rest
    name: testSensor
    resource: https://spreadsheets.google.com/feeds/cells/1oCTitrsU9BkzxugD4mRYxjRG4RONFKlmGCmQLHbHNbc/1/public/full?alt=json
    value_template: '{{ value_json.Value1 }}'
    unit_of_measurement: 'value1'

Thanks for helping