Connecting n8n to Google Sheets; Your Google Cloud Checklist
- Essential Google Cloud Requirements
- Enable Necessary APIs
- Configure the OAuth Consent Screen
- Create OAuth 2.0 Client Credentials
- Register the Authorized Redirect URI
- Define Scopes
Integrating n8n with Google Sheets unlocks powerful automation, but the foundation must be set in the Google Cloud Console. You need to enable the correct APIs and set up secure OAuth 2.0 credentials. Follow this checklist to ensure your connection is ready.
Essential Google Cloud Requirements
For n8n to successfully access your Google Sheets, the following must be enabled or configured in the Google Cloud Console.
1. Enable Necessary APIs
- Google Sheets API; This must be explicitly enabled in your project’s API Library. It grants permission for data access, including reading and writing cells.
- Google Drive API; This is also essential and must be enabled. Since Sheets are files stored in Drive, the Drive API allows n8n to interact with the underlying file structure such as listing, identifying, and opening the sheet file.
2. Configure the OAuth Consent Screen
- This screen must be set up with an App Name and a Support Email.
- The User Type is typically set to External.
- If your application is in the Testing phase and not yet verified, the Google Account you use to connect n8n must be added as a Test User.
3. Create OAuth 2.0 Client Credentials
- You must create credentials of the type Web Application.
- This step generates the unique Client ID and Client Secret that you will copy and paste into n8n.
4. Register the Authorized Redirect URI
The specific callback URL provided by your n8n instance must be added to the list of Authorized Redirect URIs for your OAuth 2.0 Client ID. This is a crucial security step for the connection process to complete.
Example format; https://[your-n8n-url]/rest/oauth2-credential/callback
5. Define Scopes
Ensure your OAuth configuration requests the correct permission scopes for Google Sheets and Google Drive such as spreadsheets and drive scopes to grant n8n the necessary access.