Google Sheets | Create Credentials

Create a new project called "n8n Connector"

Go to "Credentials" and create new credentials

Click on "OAuth client ID"

Click on "Web application"

Set a name for the credential

Copy your n8n callback URL

Add redirect URI to be your n8n instance callback URL.

Copy your Client ID & Client Secret

Enter your Client ID & Client Secret into the n8n connection

Click on "Library"

Search fo the "Google Drive API"

Enable the "Google Drive API"

Search fir the "Google Sheets API"

Click on "Enable Google Sheet API"

Click on "Sign in with Google"

Select your Google Account to grant permisisons.

Review authorization scope and click on "Allow"

Complete!