Section 6: Credentials, OAuth2 and API Keys
- API keys, basic auth and OAuth2 explained simply
- Creating and storing credentials in n8n securely
- Setting up Google OAuth2 in the Google Cloud Console
- Least privilege, and separate accounts for automation
- Lab: connect n8n to your own Google account
Section 7: Lab: Automating Google Workspace
- Google Sheets: read, append and update rows
- Gmail: send templated emails and read incoming mail
- Google Drive: store and move files automatically
- Google Calendar: create appointments from form data
- Lab: an application system that records data, stores files and sends confirmation emails
Section 8: Lab: HTTP Request and External APIs
- Read API documentation and import cURL commands into the HTTP Request node
- Headers, query parameters, bodies and paginated results
- Handling rate limits with Wait and batching
- Sending alerts through a Telegram bot and the LINE Messaging API
- Lab: pull data from a public API and post a summary to a chat group
Section 9: Lab: Databases and Data Tables
- Connect MySQL and PostgreSQL: select, insert, update and upsert
- Query parameters to prevent SQL injection
- n8n data tables for small datasets without a separate database
- An introduction to connecting Microsoft SQL Server and MongoDB
- Lab: sync customer data from Google Sheets into a database
Section 10: Workshop: Automated Customer Data Management
- Receive new customer details from a form or webhook
- Check for duplicates, group customers and save them to the database
- Notify the sales team in chat and send a welcome email
- Send a weekly summary report to management automatically