Im trying to send sensor data from a power meter periodically to a google sheets spreadsheet via ifttt.
can someone please enlighten me where i am wrong, the following json gets me the numerical value of the sensor in templates but purely sends it as text in the automation.
- id: '1573218181707'
alias: Sensor to ifttt
description: ''
trigger:
- hours: ''
minutes: '1'
platform: time_pattern
seconds: ''
condition: []
action:
- data:
event: event_name
value1: "{{ states('sensor.main_board_ct1_watts')}}"
service: ifttt.trigger