Automation architects and business users who have an AI agent foundation and now need to connect that intelligence to professional productivity suites and messy real-world data.

Familiarity with n8n nodes. Access to a Google Cloud Console account (free tier is fine). A basic understanding of what an API is will be helpful

Course Outline:

1. Data Wrangling: Managing AI’s Input/Output
   1. JSON 101: Understanding the language of the web and AI responses
   2. The “Code Node” Simplified: Using basic JavaScript snippets to map data without being a “coder”
   3. Data Transformation: How to turn a long LLM response into clean rows for a database
   4. Lab: Mapping a sample JSON response into a flat table structure

2. The OAuth Hurdle: Securely Connecting to Google
   1. Google Cloud Console: Creating a project and enabling Gmail/Sheets/Calendar APIs
   2. Credentials and Scopes: Understanding the “handshake” between n8n and Google
   3. Troubleshooting Auth: Common pitfalls in the OAuth consent screen and redirect URLs
   4. Lab: Successfully connecting your n8n instance to a Google account

3. The Inbox Manager: From Email to Action
   1. Intent Categorization: Prompting the LLM to tag emails (e.g., “Urgent,” “Inquiry,” “Spam”)
   2. Connecting the Dots: Building the workflow: Gmail Trigger → AI Processing → Google Sheets Logging
   3. Drafting Responses: Setting up the agent to automatically prepare draft replies
   4. Lab: Deploying a live agent that reads a test email and updates a Google Sheet

Training material provided: Yes (Digital format)

Hands-on Lab: Students will be provided with docker compose file and n8n workflow JSON.