You can try this comand_line from google sheets
- sensor:
scan_interval: 30
name: bd sheets
command: "curl -L 'https://docs.google.com/spreadsheets/d/jhwenfw92901203123nnm31902130/export?gid=816578980&range=A5:W5000&exportFormat=csv' | jq --raw-input '{data: [inputs | split(\",\") | {Date_of_delivery: .[0], Installation_date: .[1], Model: .[2], Power: .[4], Serial_number: .[5], MAC: .[6], IP: .[7] , Status: .[8]| gsub(\"[\\r]\"; \"\") }] }'"
value_template: "{{ now() }}"
json_attributes:
- data
You can also see examples here:
You can use these examples. And adapt it to your needs.
1 Like