Google sheet as json endpoint for sensor?


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
    value_template: '{{ value_json.Value1 }}'
    unit_of_measurement: 'value1'

Thanks for helping