Calculate energy per day

I have a shelly P1 in my garage. I get power from my neighbour.
I want 2 things.

1 calculate per 24h the total KWh i used
2 link with IFTTT Google spreadsheet so the power Usage wil be inserted in the document

Is that possible ?

The easiest way is to use the App Power by the Hour.
If you want no extra App is it also possible with variables.

With point 2 I can’t help.

For 2nd point, you can downlod csv data directly from shelly device. At least from shelly 3EM its possible. Just log directly to device via its IP addres and you will see download icon next to the actual consumption.