Credentials error on google sheets

Leonardo_Achilli · May 28, 2025, 2:35pm

Hey. I’m trying to use a free template for automatic invoice management that i found here on community templates. I’m having a constant error about credentials related to the Google Sheet “append rows”.
I just started to use this app, but following instructions i’ve never encountered problems that seem so easy but yet impossible to find a solution.
Google sheet api is enabled, the credentials are correct, i have only one mail, and i enabled n8n to access and modify files, plus i’ve shared publicly the file on google sheet. please help me. here is the link of the free template:

thank you everyone for your support

julianmoreno · May 28, 2025, 3:13pm

Hello Leonardo!
Could you please tell me where are you hosting you n8n account? I mean, is it an n8n cloud account or a self-hosted?
the way to resolve your question would depends on the account type, please let me know

zacktm · May 28, 2025, 3:13pm

The main reason for your issue is missing permissions,
You need to click on edit “Credential to connect with” on the “Send Invoice Data”, Reconnect your Google Account to get the needed permissions for Google Sheets.