Automation

To connect to your Google Sheets, n8n can not use a simple “API key.” Instead, you give n8n a special Google service account that has permission to open your spreadsheet. This article walks you through the entire process in a non‑technical, user-friendly way. What you will set up In summary, by the end of this guide, you will: Create a Google Cloud project and turn on the Google Sheets API.

Note: this article is still a Work In Progress (WIP) detailing the steps I took setting up my own n8n local development environment in my Windows machine. The goal for now is for the article to serve as a reference for personal use. I do plan to update and make it readable and helpful as well to readers and other folks who might be trying to do the same thing.