The everyday apps automation reads from and writes to — and the first connectors anyone wires up.
Pick this whenYou need a destination that a non-technical person can already open. A Sheet is a database everyone can read.
What makes it different
Universally available as both MCP connectors and n8n nodes
Sheets works as a stand-in CRM — BC6's post-call data landed there with drag-and-drop column mapping
Docs as a workflow terminal: create and append, verified live in BC3
What it does
Receives scraped and generated content (Docs create/update, Sheets append-row)
Supplies calendar and mail context to assistants via connectors
Acts as the human-readable end of an automated pipeline
What it does not do
Common wrong expectationsDoesn't scale as a database — a Sheet is a stand-in, not a system of record
Doesn't send bulk mail safely through the Gmail node
Where it sits in a stack
The endpoints of most workflows in the course: read from Calendar and Gmail, write to Docs and Sheets.
ShelfProductivity & source apps
Our status · not-usingThe pipeline's outputs are local files and static HTML.
For your projectsA Sheet mirroring extraction progress is the cheapest possible dashboard if Paul ever wants to check status without opening the site.
| Session | Coverage | Moment | What happened |
|---|
| Basecamp 3: Introduction to n8n — I | demonstrated | 2:46:31 | Terminal node of the demo workflow — doc created and scraped data appended, verified live |
| Basecamp 4: Introduction to n8n — II | demonstrated | 1:45:01 | Create + update document nodes, drive folder selection, expression-based titles |
| Basecamp 4: Introduction to n8n — II | demonstrated | 1:53:09 | Send-message delivery node; hardcoded-vs-expression subject discussion |
| Basecamp 6: Voice Agents | demonstrated | 2:45:20 | Stand-in CRM; columns mirror post-call properties; document by ID/URL |
| Basecamp 6: Voice Agents | demonstrated | 2:21:00 | Connected through cal.com; live booking landed in it during the test call |
| Session 6: Building an AI-Powered Lead Gen Machine | demonstrated | 1:17:21 | The factory spine: row-added trigger, intermediate logging ('before you lose the data'), context columns appended per station |
| Session 17: Facebook Ads Competitor Research & Replication | demonstrated | 1:35:29 | Two roles: hosting the product image (where the share-link HTML-viewer trap surfaced) and receiving generated ads for the human-review gate |
| Session 26: Product-Led Activation & Lifecycle Growth — Turning a Free Tool into a Growth Machine | demonstrated | 0:58 | Resource folder auto-generated by his resource-generator skill |
| Session 27: Lead Magnets as Proof Artifacts — the Mega-Prompt Build, Four Live Magnets, and the Skill That Packages the Workflow | demonstrated | | Resource pack destination |
| Generative Media in AI Studio: Imagen Images, Veo Video on a Free Quota, and Multi-Speaker Speech Generation | demonstrated | | |
| Day 3: n8n From Zero — Triggers, Fixed vs Expression, an AI Spam Classifier, and Your First Lead-Routing Workflow | demonstrated | | Append Row into Spam/Genuine tabs |
| Day 6: Voice Agents That Talk Like Humans — the 5-Step Pipeline, Retell Settings That Matter, the 5-Section Prompt, cal.com Booking, and Call Logging | demonstrated | | Connected to cal.com; booking verified |
| Day 6: Voice Agents That Talk Like Humans — the 5-Step Pipeline, Retell Settings That Matter, the 5-Section Prompt, cal.com Booking, and Call Logging | demonstrated | | Per-call row destination |
| Day 7: Building 'Jerry' — Master Agent, Sub-Agents as Tools, the List-Then-Act Pattern, and Calling Any API from n8n | demonstrated | | Calendar Agent tools incl. Get Availability |
| Day 13: Front End Meets Backend — Lovable to n8n by Webhook and .env, the Lovable<->n8n MCP Connector, Respond to Webhook, and GitHub for Teams | demonstrated | | Expense tracker data verified |
| Day 3: Markdown Prompting, Content DNA and Skills, MCP Everywhere (Vapi Call, Zomato, Apify), Goose and Local Models, a Voice Agent, and the Full n8n Customer-Support Build | demonstrated | | Audit log |
| Section 6: Four Full Builds — a Faceless Hook in 20 Minutes, a '$300,000 Ad for Under $30', an Animated Music Video, and a Viral AI-Clone Action Sequence | demonstrated | | Storyboard; Web Page export |
| Day 2: Story Design — the Logline Filter and the 90/10 Rule, Harmon's Story Circle, the Five-Step Scene Formula ('No Scene That Doesn't Turn'), and the Script Page | demonstrated | | Scene Design template |
| Days 3-5: The Director Places the Camera — the Kuleshov Effect, Beats as Verbs, Casablanca's Duel of the Anthems, Mamet's Nail, and the Shot List | demonstrated | | Free shot-list template |
| AI Automation Mastery I: Trigger-Logic-Action, Zapier vs Make vs n8n, and Four Live n8n Builds (Form to Email, AI-Personalised Email, Sheets and Data Tables, Scheduled LinkedIn Poster) | demonstrated | | |
| AI Automation Mastery II: an AI LinkedIn Pipeline with Human-in-the-Loop Approval and Nano Banana Images, Apify Lead Scraping to Personalised Cold Drafts, an AI Job-Match Scorer, Telegram Bots, and the Six-Level AI Generalist Roadmap | demonstrated | | |
| AI Automation Mastery II: an AI LinkedIn Pipeline with Human-in-the-Loop Approval and Nano Banana Images, Apify Lead Scraping to Personalised Cold Drafts, an AI Job-Match Scorer, Telegram Bots, and the Six-Level AI Generalist Roadmap | demonstrated | | |
| Four Ways to Never Run Out of Ideas: Expertise Mining, the 5-Year Reflection Interview, Audience-Question Mining in Perplexity, and Competitor Analysis | demonstrated | | Positioning canvas |
| Claude Artifacts, Integrations and Styles: a Published Interactive Content Calendar, Calendar and Gmail Search, and a Custom "Sardonic Wit" Voice | demonstrated | | |
| Numerous AI: ChatGPT Inside Google Sheets - Sentiment, Keywords and Issue Buckets on Amazon Reviews | demonstrated | | |
| AI for Designers: Product Research - Personas, Jobs to Be Done, Competitors and a Locked Value Proposition in Claude and ChatGPT | demonstrated | | |
| Gemini Overview: Multimodal Uploads, @-Tagging Google Apps, Saved Info Personalisation, and Honest Weaknesses | demonstrated | | |
| Gemini Deep Research and Multimodal Analysis: Role-Task-Constraint Prompts, Editing the Research Plan, Export to Docs, and a Competitor Poster | demonstrated | | |
| Gemini Canvas and Google Workspace Apps: Infographics and Docs in a Side Panel, Tone Slider, Export to Docs, and Calendar and Gmail Queries | demonstrated | | |
| Gemini Canvas and Google Workspace Apps: Infographics and Docs in a Side Panel, Tone Slider, Export to Docs, and Calendar and Gmail Queries | demonstrated | | |
| Triggers, Actions, Data Flow and Mapping: Google Forms to Google Sheets | demonstrated | | |
| Your First Real Scenario: Router, Search Rows, Filters (the Upsert Pattern), Functions, and History | demonstrated | | |
| Zapier for Marketers: Trigger-Action Zaps to Post Drive Uploads to LinkedIn and File Email Attachments | demonstrated | | |
| An n8n Content-Repurposing Workflow: Google Sheet Paragraph to Tweet, LinkedIn Post and Shorts Script | demonstrated | | |
| Day 2 (afternoon): MCP as the USB Port for AI, Building a Server in Two Lines, the Four Orchestration Shapes, and CRUD as the Security Model | demonstrated | | Free-slot check via connector |
| Bonus Session (Day 3): No-Code Automation in Make.com - Form to Sheet to Email, the 7-Step Process, and a Daily AI Image-and-Caption Poster for Instagram and LinkedIn | demonstrated | | Trigger source |
| SuperJoin Deep Dive: AI Data Analysis Inside Google Sheets - Connectors, Prompt-Driven Reports, and In-Cell SuperGPT Formulas | demonstrated | | |
| Zapier Overview: Trigger and Action, Start from Templates, and Filters, Formatter and Multi-Step Zaps | demonstrated | | |
| Zapier Dashboard, Zaps, Triggers and Actions: the Canvas, Setup-Configure-Test, and a Gmail-to-Sheets Zap | demonstrated | | |
| Zapier Copilot: Ask It to Explain and Fill Fields, Gmail Search Operators, and the Built-In Filter and Formatter Apps | demonstrated | | |
| Office Hours XIV: Story Before Landing Page, Scoping an Agentic-Web Pitch, the Cost of Compute, Automating Past Google, and the Idea Bank | explained | 0:18 | Draft the story before touching the page |
| Day 4: Your First AI Employee — Brain/Memory/Tools/Prompt, a Pinecone RAG Support Agent in n8n, and When NOT to Use an Agent | explained | | Expense-tracker workbook tool |
| Understanding Jev, the AI Built for Decisions (Sprint Day 2): Two Second-Brain Systems - a Leadership Self-Review Built Problem-First, and a Tag-Classifying Knowledge Base Where a Cheap Decision Model Replaces a Chat Model | explained | | Connector read big files only partially |
| Session 14: Claude Code — Advanced Workflows | mentioned | 0:35:48 | 'The most used CLI' — full Google Workspace control; promised for a later session |
| Finalize: The 80/20 Prune to Version 2.0, Read It Aloud Six Times, Never Write Alone, the Live Write-Through of the 1 Day Script Ad, and 14 Day Filmmaker as Bonus and Funnel | mentioned | | Sharing the recorded storyboarding session |
| Claude Artifacts, Integrations and Styles: a Published Interactive Content Calendar, Calendar and Gmail Search, and a Custom "Sardonic Wit" Voice | mentioned | | |
| Gemini Overview: Multimodal Uploads, @-Tagging Google Apps, Saved Info Personalisation, and Honest Weaknesses | mentioned | | |
| Manus Threads and Multimodal Input: Rename and Favourite, Share as a Replay, and Analysing an Image | mentioned | | |
| Claude for Marketing Analytics and Content Calendars: Long Context, CSV Analysis Like an Intern Brief, and MCP-Powered Planning | mentioned | | |
| Notion AI Overview: AI Inside Your Workspace - Summarise, Translate and Brainstorm Inline, Templates, and Where It Falls Short | mentioned | | |
| Notion AI Chat Across Your Workspace, Filters, and Meeting Notes: Make Shorter and Action Items from a Transcript | mentioned | | |
| AI Sprint: AI Evals & Reliability — Day 2 (Testing Systems That Never Answer Twice) | mentioned | | Where the audience agent writes its drafts |
| Zapier Copilot: Ask It to Explain and Fill Fields, Gmail Search Operators, and the Built-In Filter and Formatter Apps | mentioned | | |
| Zapier Task Usage and Zap History: Plan Limits, Polling Costs, Four Ways to Cut Usage, and Reading a Run | mentioned | | |
Google Docs / Sheets / Gmail / Calendar