Google Sheets Action is not picking up a list of available Sheets despite seeing the document itself

[Sergey_Komardenkov]

Describe the problem/error/question

I am testing a workflow where the final action is addition of a row into a Google sheet. I have created a new sheet, I gave it Edit permissions by link just in case, and of course I added Google Sheet credentials that actually pull a list of documents from my account, including the document I created.

I am able to choose that document in the “Document” drop-down of the setup modal window for Google Sheets. But the very next dropdown, titled “Sheet”, gives me “Could not load list” error when I choose the “From list” option. Entering sheet’s name using the “By Name” option doesn’t work either - the following “Mapping Column Mode” form field is not populated with any options (I created columns in that sheet) and “No columns found in Google Sheets” error message is displayed.

What is the error message (if any)?

“Could not load list”

Please share your workflow

1. Add a new action “Google Sheets”
2. Select “Append row in sheet” option
3. Select the credential in the “Credential to connect with” dropdown
4. Select “Sheet within document” as the Resource option
5. Keep the “Append Row” selected as the operation
6. In the “Document” form field, use the “From list” option and observe selection being fetched from the credential
7. In the list of files selected, pick the one where you need the new row to get added
8. In the “Sheet” form field select “From list” option and observe selection being fetched from the credential
9. [ERROR] - “Could not load list”

[n8n]

It looks like your topic is missing some important information. Could you provide the following if applicable.

• n8n version:
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app):
• Operating system:

[barn4k]

hello @Sergey_Komardenkov

Does it work via the ID reference? If not, then it may be an issue with permissions (e.g. API can’t access sheets within the document)

[Sergey_Komardenkov]

Turns out when I was creating the Google Sheets credential I did not check one of the three permissions, namely the “See, edit, create and delete all your Google Sheets spreadsheets”. I did select “See, edit, create and delete only the specific Google Drive files that you use with this app” initially and thought that would be enough.

Adding the “… all your Google Sheets spreadheets” one solved the problem.