How do I select the sheet or find the 'config_entry' for my Google Sheets integration

I’m trying the Google Sheets integration for the first time. It installed successfully.

Now I’m trying to test it with the google_sheets.append_sheet service, but it is asking me for the config_entry and I have no idea how to find this.

Is this something silly that I’ve overlooked? Thank you for any help.

Screenshot of not being able to pick sheet to add data to.

I have exactly the same problem and the same question. I watch a tutorial on youtube: How to use Google Sheets in Home Assistant - TUTORIAL - YouTube and I see that config_entry should be added automatically by the integration for us. My assumption is that I did not configured correctly the integration or the integration is broken now. Can someone please clarify?

Same issue here!
Any help please??

Here is how I found my config_entry:

  • open /config/.storage/core.config_entries
  • search for “Google Sheets” and find your config_entry under “entry_id” name
3 Likes

Dear @cosmin thanks for the reply.
In File Editor there is no “.storage” folder.

(i confirm that. Maybe it has something to do with config_entries, because when i click the button “call service”, it returns an error saying “…required key not provided @ data[‘config_entry’]”

Any tip?

files and folders starting with “.” are hidden by default. Maybe that’s the reason why you don’t see it. How do you access Homeassistant files?

I’m using File Editor, but tonight i will try to access via file manager, because i have samba installed.
I will give feedback later.

Thanks for the tip

I am not familiar with File Editor. File managers also hide things starting with “.”. Make sure you enable seeing hidden files/folders with your file manager, if needed.

You make my day !!! … Thanks a lot for your tiip… Probably a bug in HA

Guys,

Problem solved. With a new update from HA, the option appears again.
Already configured mine and rolling :sunglasses:

So, problem solved, just by waiting for an HA update.

1 Like