Please Help! Google Sheets Question

1

Can someone please help me with my code, how do i get this into my Google Sheets integration so that:

  1. Each time the counter is increased for any of the sensor’s it UPDATES the prior value instead of adding a new line.

  2. The output i am looking for is 4 category columns (one for each sensor) and a new row for each date.

  3. Ultimately I am hoping that it updates each category in my sheet replacing the old value against the current date row.

Thank you so much for your help:

alias: Frigate - Road Statistics
description: “”
trigger:

  • platform: state
    entity_id:
    • sensor.road_car_count
      from: null
      id: Private Road Car
  • platform: state
    entity_id:
    • sensor.road_person_count
      id: Private Road Person
  • platform: state
    entity_id:
    • sensor.oldmans_road_car_count
      from: null
      id: Oldmans Car
  • platform: state
    entity_id:
    • sensor.oldmans_road_person_count
      id: Oldmans Person
      from: null
      condition:
      action:
  • choose:
    • conditions:
      • condition: trigger
        id:
        • Private Road Car
          sequence:
      • service: counter.increment
        metadata: {}
        data: {}
        target:
        entity_id: counter.private_road_daily_car_count
    • conditions:
      • condition: trigger
        id:
        • Private Road Person
          sequence:
      • service: counter.increment
        metadata: {}
        data: {}
        target:
        entity_id: counter.private_road_daily_people_count
    • conditions:
      • condition: trigger
        id:
        • Oldmans Car
          sequence:
      • service: counter.increment
        metadata: {}
        data: {}
        target:
        entity_id: counter.oldmans_daily_car_count
    • conditions:
      • condition: trigger
        id:
        • Oldmans Person
          sequence:
      • service: counter.increment
        metadata: {}
        data: {}
        target:
        entity_id: counter.oldmans_daily_people_count
        mode: single
2