But the value for states.sensor.battery_frontdoor.state isn’t getting passed. I suspect I need to use a template, but I can’t figure out the correct syntax. (I also think I need to put the value in quotes as well).
FutureTense: thanks and yes I did check but I realized that i was using data: instead of data_template which i guess makes sense as we are using template here. It started working for me once i replaced it.
I’m sharing my working configuration and I hope it helps someone jump the hurdles to set this up
Set up IFTTT Webhooks - get the key and add it to configuration.yaml so that you have an entry eg.
ifttt:
key: 6XSjUfwXN6AvTXZwhatever
Set up IFTTT Google Sheets - (my first hurdle: I was using the wrong Google account). Now make an IFTTT app in the form “If Webhook then Google Sheet”. You can change the Eventname or the Spreadsheet name, but I’d keep the rest as it is.
Test the process in HA > Developer tools > Services > ifttt.trigger.
Use Example data to see if data actually gets to your spreadsheet
Write an old-style automation. Don’t use the script editor - instead create a file called eg oil_level.yaml inside the automations folder.
(Your configuration.yaml must have this line:
automation old: !include_dir_merge_list automations
)
btw the DIY automation is stored in /config/automations/oil_level.yaml