Publish to Google Sheets (Community)

[faanskit]

The CheckWatt integration can be used to publish data to a Community Google Spreadsheet and the CheckWattRank service.

This is done by configuring (and restarting) the integration. A browser refresh may be needed to these (Ctrl-F5) after upgrading the component.

Alternatively, this is done by adding data into configurations.yaml and automations.yaml.
This functionality requires that Extra Attributes and Energy Sensors are enabled.

configuration.yaml
REST function used to publish to the Community Google Spreadsheet.

rest_command:
  publish_energy_data:
    url: 'https://checkwattrank.netlify.app/.netlify/functions/publishToSheet'
    method: 'POST'
    headers:
      Content-Type: 'application/json'
    payload: '{"display_name": "{{ display_name }}", "dso": "{{ dso }}", "electricity_company": "{{ electricity_company }}", "electricity_area": "{{electricity_area}}", "installed_power": {{ installed_power }}, "today_gross_income": {{ today_gross_income }}, "today_fee": {{ today_fee }}, "today_net_income": {{ today_net_income }}}'

automations.yaml
This sample automation pulls data from your sensors and publish them to Community Google Spreadsheet.
This example use an Input Button helper function to trigger the automation.

Replace sensor names as per your system.

alias: Test Publish
description: ""
trigger:
  - platform: state
    entity_id:
      - input_button.publish
condition: []
action:
  - service: rest_command.publish_energy_data
    data:
      display_name: "{{state_attr('sensor.your_checkwatt_daily_yield', 'display_name')}}"
      dso: "{{state_attr('sensor.your_checkwatt_daily_yield', 'dso')}}"
      electricity_company: "{{state_attr('sensor.your_checkwatt_daily_yield', 'energy_provider')}}"
      electricity_area: "{{state_attr('sensor.your_spotpris_sensor', 'price_zone')}}"
      installed_power: "{{float(state_attr('sensor.your_checkwatt_daily_yield', 'charge_peak'))}}"
      today_gross_income: "{{float(state_attr('sensor.your_checkwatt_daily_yield', 'today_gross_income'))}}"
      today_fee: "{{float(state_attr('sensor.your_checkwatt_daily_yield', 'today_fees'))}}"
      today_net_income: "{{ states('sensor.your_checkwatt_daily_yield') }}"
mode: single

[flopp999]

funkar kanon

[smefa]

I upgraded and tried to turn it on but I only get this in config.
Not sure if it is working.

[flopp999]

Core 2024.1.2

Supervisor 2023.12.0

Operating System 11.3

Frontend 20240104.0

Same as me and it works for me.
What version of CheckWatt integration?
I have 0.1.5

[smefa]

Looks ok now, might have been a browser refresh or something that was required.
Is there any way to see if it works?

[smefa]

Answer to myself. :) Turned on logging for the integration and got this.
[custom_components.checkwatt] CheckWattRank Push Response: {'message': 'Data published successfully'

[faanskit]

Yea, a Ctrl-F5 or HA reboot will solve that. Restart of integration is not enough.

[faanskit]

...and to confirm it workin, head over to the Google Sheet and look for your system. Can take up to 5 minutes before it appears in the right sheet.
https://docs.google.com/spreadsheets/d/1zccKPgIVVHBvZUGvYNp4mlVlkNWyAiEGOLZtn4j_Ljs/edit#gid=1070177615

[faanskit]

This function may now be broken with v2.0.0-RC.1. The peak power attribute has moved to Battery SoC sensor.
Also, no longer need to use this to anonymize your system name, now configurable in the integration configuration