How To Setup Google Authentication in Local n8n (Google Sheets API Guide)
🔥 Join Our Skool Community & Download the Full Ready-to-Use n8n Workflow:
👉 https://www.skool.com/nocodedad-1488/
If you're running local n8n and want to connect Google Sheets, you must properly set up Google Authentication using Google Cloud Console.
In this step-by-step tutorial, I show you exactly how to:
• Create a Google Cloud project
• Enable Google Sheets API
• Enable Google Drive API
• Configure OAuth consent screen
• Create OAuth client credentials
• Add redirect URL inside n8n
• Connect Google Authentication successfully
• Fix the “unverified app” warning
Once this is done, your local n8n setup can securely read and write Google Sheets — which is essential for AI video workflows, automation systems, and content pipelines.
This is a foundational step before building long-form AI video automations in n8n.
If you're new here…
My name is Prashant.
I spent 15+ years working in the film and animation industry with studios like DreamWorks Animation and Moving Picture Company.
Now through No Code Dad, my daughter and I build AI + automation systems and show how to turn them into real income using tools like n8n.
⏱ Timestamps
00:00 Intro
00:48 Create Google Cloud Project
01:14 Enable Google Sheets API
01:25 Enable Google Drive API
01:34 OAuth Consent Screen Setup
02:00 Create OAuth Client
02:15 Connect Google Auth in n8n
03:30 Test Google Sheets Connection
#n8n
#GoogleSheetsAPI
#GoogleAuthentication
#Automation
#NoCode