Sensor data to a readable text file

how to make a automation to read the data of a sensor after each and every hour to a separate single text file or a specified readable file ?

what i need is i have a ultrasonic sensor connected with esphome which tells the water in a tank in litre,

now what i need is a automation which can send the water in that tank after every hour to a single file which can be readable .

how to do that

In the link provided, change this:

minutes: '/5'
seconds: 00

to this:

hours: '/1'

and it will trigger every hour. This is explained in the Time Pattern Trigger.

Then change this:

message: "{{ states.sensor.qubino_zmnhxdx_3phase_smart_meter_energy_2.state }}"

so it contains the name of your ultrasonic measuring sensor.

You’ll probably also want to modify the file name defined here:

notify:
  - name: filenotify
    platform: file
    filename: hybelpower.csv
    timestamp: true

after using the configuration i am able to get the details per hour in a file ,
but one problem i am facing
the time in that file is not according to my location

the time it shows is UTC +0 whereas i am living in UTC +5.30

how can i resolve this time problem ?