Google Sheets in template always returns permission denied

[Pats]

Thanks for creating this super useful and amazing template.

Gmail campaign sender: Bulk-send emails and follow up automatically if no...

I am facing an issue in update last contacted time google sheets node.

It always returns me Permission Denied. I have tried with Service accounts with the owner role, providing sheet access to service accounts etc.

Attaching an image for your reference.

Looking forward to hearing from you!

Thanks,

Prathamesh

[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:

[aya]

Welcome to the community @Pats

It’s hard to say without knowing how you’ve set up your credentials, but a good place to start would be to take a look at the docs here Google: Service Account and
check if you haven’t missed anything. e.g. have you enabled Google Drive API as well as Google Sheet API? (something I overlooked when setting this up)

[Pats]

Thanks @aya for your reply. I have followed those steps exactly. There is another sheets node (Get emails) just before update last contacted time google sheets node., it works well there. For this node. it is still throwing me the error.