讀取的連結方法如下
步驟1:取出 json 檔 GET https://sheets.googleapis.com/v4/spreadsheets/spreadsheetId/values/Sheet1!A1:D5?key=API金鑰 步驟2:組態檔設定如下 sensor: - platform: rest resource: https://sheets.googleapis.com/v4/spreadsheets/xxxx/values/Sheet2!A1:E2?key=API金鑰 name: '資料1' value_template: "{{ value_json['values'][1][0] }}" - platform: rest resource: https://sheets.googleapis.com/v4/spreadsheets/xxxx/values/Sheet2!A1:E2?key=API金鑰 name: '資料2' value_template: "{{ value_json['values'][1][1] }}" - platform: rest resource: https://sheets.googleapis.com/v4/spreadsheets/xxxx/values/Sheet2!A1:E2?key=API金鑰 name: '資料3' value_template: "{{ value_json['values'][1][2] }}"