Overview
This lesson is part of the n8n AI Automation - Zero to Hero course, Section: 3. Deep Dive Concepts.
Watch the video above for the full tutorial, or read the written guide below.
What is n8n's role when connecting multiple business apps?
n8n acts as a universal translator for disconnected business apps. Most software tools , Google Sheets, Airtable, HubSpot, Slack, Notion , do not talk to each other natively. n8n sits in the middle: a trigger fires when something happens in one app, and n8n performs sequential actions across the others, moving data without code or a programmer. The HTTP node covers any app that lacks a dedicated built-in node.
How to build a lead management workflow connecting Google Forms, Google Sheets, Slack, Notion, and Airtable
The Webhook node is the entry point for this workflow. Configure it with HTTP method POST (not GET, because you are receiving and processing data, not fetching it), then copy its test URL into each Google Form's Apps Script. A single Webhook node can receive submissions from multiple forms at once, replacing the daily manual task of browsing survey responses.
The Google Sheets node handles lead storage, and the IF node replaces manual qualification. Use the "Append Row" operation in Google Sheets, not "Append or Update Row," which errors without a match-column ID. After the row is saved, the IF node evaluates two conditions: company name "is not empty" and email "does not end with gmail.com" or "hotmail.com." Leads meeting all conditions route to the True branch; others go to False and stop.
On the True branch, three sequential nodes handle the qualified lead. A Slack node (resource: Message, operation: Send) posts a "New Lead Alert" with the contact's first and last name dragged from the Webhook output into the message text. A Notion node (resource: Database Page, operation: Create) adds a follow-up task to the sales team's task tracker. To wire up Notion, create an internal integration at notion.so/my-integrations, copy the API secret into n8n credentials, then invite that integration to the specific page via the page's three-dot menu and Connections. Finally, an Airtable node logs the lead in the CRM.
Key Takeaways
- The Webhook node serves as a single listener for multiple Google Forms: configure each form's Apps Script to POST to the same webhook URL, eliminating manual data collection.
- Use "Append Row" in the Google Sheets node, not "Append or Update Row"; the latter requires a match-column ID and throws a configuration error when adding new records.
- The IF node replaces a human reviewer: combining a company-name "is not empty" check with email-domain conditions routes only business leads to the sales pipeline.
- Notion's internal integration requires three distinct steps: create the integration at notion.so/my-integrations, paste the API secret into n8n, then invite the integration to the target page via that page's Connections menu.
- The HTTP node extends n8n to any REST API not covered by a built-in node, making the Slack, Notion, Airtable, and Google pattern reachable for nearly any business software.
Related Lessons
- Lesson 11: How Branching works in n8n Workflows | Smart Automations with Multiple Paths
- Lesson 12: How to Use Merge Node in n8n | Combine Data Like a Pro
- Lesson 13: How to Use Set Node in n8n | Edit Fields Node | Add, Edit, Clean Data
- Lesson 14: How to Use Aggregate Node in n8n | Combine & Summarize Data
- Lesson 15: How to Use Remove Duplicates Node in n8n | Clean Your Data Fast
Next Steps
Continue your n8n journey with the full n8n AI Automation - Zero to Hero course.
