Unable to access google sheet saying no api access

Questions
1

The API has not been used in project 929368786703 before or it is disabled. Enable it by visiting https://console.developers.google.com/apis/api/drive.googleapis.com/overview?project=929368786703 then retry. If you enabled this API recently, wait a few minutes for the action to propagate to our systems and retry. is showing when i try to get the sheet but i turned api off and on multiple times and re created the sheet credential and nothing is working

2

Hey! I’ve dealt with this before. The error message points to Drive API, not Sheets API - that’s the key.

Google Sheets node needs BOTH APIs enabled:

  1. Google Sheets API
  2. Google Drive API (this one often gets missed)

Go to your Google Cloud Console and make sure both are enabled. After enabling Drive API, wait 5-10 minutes before testing again.

Also quick check - in your OAuth consent screen, make sure you added these scopes:

  • …/auth/spreadsheets
  • …/auth/drive.file

If you’re still stuck after enabling both APIs, delete the credential in n8n completely and create fresh one from scratch.

Here’s Google’s official guide: Node.js quickstart  |  Google Sheets  |  Google for Developers

Let me know if this sorts it!

3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.