Automatically capture affiliate lead submissions and route them to dedicated Google Sheets — with zero manual effort.
- Manual copy-paste of form submissions to spreadsheets
- Data entry errors and misrouted affiliate information
- Delayed data availability for affiliate partners
- Administrative overhead increases with each new affiliate
An end-to-end automation that:
- Listens for new form submissions via webhook
- Extracts and validates lead information
- Routes data to the correct affiliate-specific sheet
- Creates new sheets automatically when needed
- Sends instant notifications on every submission
💡 Once deployed, new affiliates are handled automatically without configuration changes.
- 📝 Public Form Capture — Collect leads via shareable Tally.so forms (Name, Email, Affiliation Code, Phone)
- ⚡ Instant Webhook Processing — Submissions trigger the workflow in real-time, zero delays
- 🔍 Smart Affiliate Routing — Automatically detects and routes data to the correct sheet by affiliation code
- 📊 Auto Sheet Generation — Seamlessly creates new affiliate-specific sheets when none exists
- 📁 Centralized Drive Storage — All sheets organized in a single designated Google Drive folder
- 🔔 Real-Time Slack Alerts — Instant channel notifications with lead details on every submission
- 🐳 Dockerized Local Setup — One-command deployment using Docker Compose
- 💸 100% Free Stack — Built entirely on free-tier services with no ongoing costs
| Category | Technology | Description | Link |
|---|---|---|---|
| Workflow Automation | n8n Community Edition | Local workflow orchestration for form processing, sheet management, and notifications | n8n.io |
| Form Handling | Tally.so | Free form builder for public submissions (Name, Email, Affiliation Code, optional Phone) | tally.so |
| Data Storage | Google Sheets | Dynamic spreadsheet creation and row appending based on affiliation code | Google Sheets API |
| Cloud Storage | Google Drive | Folder-based search and storage for spreadsheets | Google Drive API |
| Notifications | Slack | Real-time channel notifications with lead submission details | Slack API |
| Containerization | Docker + Docker Compose | Container orchestration for n8n via docker-compose.yml on localhost |
Docker / Compose |
Form Submit → Trigger → Extract Fields → Search Sheet → Exists? ─┬─→ [YES] → Append Data ──────────────────────┬─→ Build Message → Send Notification
│ │
└─→ [NO] → Create Sheet → Move to Folder → Append Data
Before you begin, make sure you have the following set up:
| Software | Version | Installation Guide |
|---|---|---|
| Docker | 28.5.1+ | Install Docker |
| n8n | 1.121.3 (latest) | n8n Docker Setup |
Verify Installation:
# Check Docker
docker --version
# Expected: Docker version 28.5.1 or higher| Service | Free Tier | Signup / Setup |
|---|---|---|
| Tally.so | ✅ Yes | Create Account |
| Google Cloud Console | ✅ Yes (with limits) | Setup Guide |
| Google Drive | ✅ Yes | Enabled via Google Cloud |
| Google Sheets | ✅ Yes | Enabled via Google Cloud |
| Slack | ✅ Yes | Create Workspace |
Ensure you have the following credentials ready before configuring n8n:
- Form ID (from your created form's URL)
- API Key (for webhook authentication)
📘 Guide: Getting your Tally API Key
- OAuth 2.0 Client ID
- OAuth 2.0 Client Secret
- Enabled APIs: Google Drive API, Google Sheets API
📘 Guide: Setting up Google OAuth for n8n
- Slack App with Bot Token (
xoxb-...) - Bot scopes:
chat:write,channels:read - Target Channel ID
📘 Guide: Creating a Slack App
# Clone the repo
git clone https://github.com/Neloy-Barman/Affiliate-Submission-Hub-Form-to-Sheets-Automation.git
# Navigate to the project directory
cd Affiliate-Submission-Hub-Form-to-Sheets-AutomationEnsure Docker Desktop is running in the background, then start the n8n container:
# Start the container in detached mode
docker compose up -d💡 Check container logs in Docker Desktop GUI to confirm successful startup.
Open your browser and navigate to:
http://localhost:5678
Create an account or log in if prompted.
- Click the
...menu in the top-right corner - Select Import from File
- Choose
Affiliate-Submission-Hub.jsonfrom theworkflowsdirectory
Set up the required credentials in n8n:
| Credential | Navigation | Required Values |
|---|---|---|
| Tally.so | Settings → Credentials → Add → Tally | API Key |
| Google Drive | Settings → Credentials → Add → Google Drive (OAuth2) | Client ID, Client Secret |
| Google Sheets | Settings → Credentials → Add → Google Sheets (OAuth2) | Client ID, Client Secret |
| Slack | Settings → Credentials → Add → Slack | Bot Token (xoxb-...) |
📘 Refer to Prerequisites for credential setup guides.
Open the imported workflow and update these nodes:
| Node | Parameter | Value |
|---|---|---|
| Submission Trigger | Form | Select your Tally form |
| Find Affiliate Sheet | Folder ID | Your Affiliate_Submissions folder ID |
| Create Affiliate Sheet | Folder ID | Your Affiliate_Submissions folder ID |
| Send Lead Notification | Channel | Your Slack channel ID |
- Toggle the Active switch in the top-right corner
- Status should show Active (green)
Your automation is now live. Head over to 📘 Usage to learn how to use and test the workflow.
💡 To stop or restart the workflow later, see Managing the Workflow in Usage.
| User Type | Entry Point | Purpose |
|---|---|---|
| Lead/Visitor | Tally.so Form URL | Submit lead information |
| Admin | n8n Interface (localhost:5678) |
Monitor and manage workflow |
| Affiliate | Google Drive Folder | View their submission data |
| Team | Slack Channel | Receive real-time notifications |
Share your Tally.so form URL publicly. Users fill in the following:
| Field | Type | Required | Example |
|---|---|---|---|
| Name | Text | ✅ Yes | John Doe |
| ✅ Yes | [email protected] |
||
| Affiliation Code | Text | ✅ Yes | Beast2025 |
| Phone Number | Phone | ❌ No | +1 234 567 8900 |
💡 The Affiliation Code determines which Google Sheet receives the data.
To verify everything works correctly:
- Open n8n interface at
http://localhost:5678 - Open the Affiliate Submission Hub workflow
- Click on each node sequentially
- Click Test Step to execute individually
- Verify outputs at each stage
Sample Test Data:
Name: John Doe
Email Address: [email protected]
Phone Number: +1 234 567 8900
Affiliation Code: Beast2025
After a successful submission:
| Output | Location | What to Expect |
|---|---|---|
| Google Sheet | Affiliate_Submissions folder |
New row in {affiliation_code}_Submissions sheet |
| Slack Message | Configured channel | Notification with submission details |
Sheet Naming Convention:
{affiliation_code}_Submissions
Example: beast2025_Submissions
Sheet Structure:
| Name | Phone Number | Submission Date | Submission Time | |
|---|---|---|---|---|
| John Doe | [email protected] | +1 234 567 8900 | 12/18/2025 | 10:30 |
Slack Notification:
🎉 New Lead Received!
👤 Name: John Doe
📧 Email Address: [email protected]
📞 Phone Number: +1 234 567 8900
Affilated from beast2025
Automated with this n8n workflow
✅ Submission successful when:
- New row appears in
{affiliation_code}_Submissionssheet - Slack notification received with submission details
- Sheet created automatically (if new affiliation code)
- All fields populated correctly
❌ Something went wrong if:
- No new row in Google Sheet
- No Slack notification
- Error shown in n8n execution log
Check Workflow Status:
- Open n8n interface at
http://localhost:5678 - Locate Affiliate Submission Hub workflow
- Check the toggle — Green = Active, Gray = Inactive
Stop the Workflow:
docker compose downRestart the Workflow:
docker compose up -dView Logs:
docker compose logs -fThis project is licensed under the MIT License — see the LICENSE file for details.
Neloy Barman – AI Agent Builder | Automation Engineer | Chatbot Developer
- 💼 LinkedIn: Neloy Barman
- 🐙 GitHub: Neloy-Barman
- ✍️ Medium: @neloyupwork018
- 🌐 Portfolio: neloy-barman.github.io
- 📧 Email: [email protected]
Built with ☕ and automation in mind by Neloy Barman
📝 Documentation crafted with assistance from Claude AI
