Hi,
I’m exporting the results out of the states table currently.
Example: select state, attributes, last_changed from states where entity_id = 'sensor.latest_trip' group by state
The idea for the future is:
- Have an automation that fires an event after a trip has completed.
- Collect the GPS information out of the database for the start and end time
- reverse lookup the address for start and end
- take the information and add a line in a google sheet
To the fuelRange problem:
- in the next version I’ll check
availabilitiesand hide unavailable sensors - could you please explain your formula idea a little bit?
Thx
Rene