This add on will upload the state change values of given entities to a google sheet on a timer. I built this so that i could use Google Data Studio for further analysis of the data and you get unlimited storage for google sheets. https://datastudio.google.com
Currently it only logs the state changes and not the attributes.
I installed your component, followed the guide for the credentials and shared the spreadsheet with the email in the .json file.
As soon as I share the sheet I receive an email “Delivery Status Notification (Failure)” the email address can’t be found? I have tried several times with different projects in the API console but with the same result.
However, in the sheet, a new tab is created with the name of the entity I have configured, but no data is exported to the sheet? If the sheet is created by the component there must be connection?