Skip to content

About

Automatically capture affiliate lead submissions and route them to dedicated Google Sheets — with zero manual effort.

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Latest commit

 

History

1 Commit

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

🔗 Affiliate Submission Hub

Form to Sheets Automation

n8n Docker Tally.so Google Sheets Google Drive Slack

Status License

📖 Overview

Automatically capture affiliate lead submissions and route them to dedicated Google Sheets — with zero manual effort.

❌ The Problem

  • 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

✅ The Solution

n8n Workflow Preview

n8n workflow: Form submission → Sheet management → Slack notification

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.

✨ Key Features

  • 📝 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

🛠️ Tech Stack

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

🔄 Automation Flow

Form Submit → Trigger → Extract Fields → Search Sheet → Exists? ─┬─→ [YES] → Append Data ──────────────────────┬─→ Build Message → Send Notification
                                                                 │                                             │
                                                                 └─→ [NO] → Create Sheet → Move to Folder → Append Data

📋 Prerequisites

Before you begin, make sure you have the following set up:


🖥️ Software Requirements

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

🔐 Account & API Requirements

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

🔑 Credentials Checklist

Ensure you have the following credentials ready before configuring n8n:

Tally.so

  • Form ID (from your created form's URL)
  • API Key (for webhook authentication)

📘 Guide: Getting your Tally API Key

Google (Drive & Sheets)

  • 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

  • Slack App with Bot Token (xoxb-...)
  • Bot scopes: chat:write, channels:read
  • Target Channel ID

📘 Guide: Creating a Slack App


🚀 Quick Start

1️⃣ Clone the Repository

# 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-Automation

2️⃣ Start the Environment

Ensure 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.


3️⃣ Access n8n Interface

Open your browser and navigate to:

http://localhost:5678

Create an account or log in if prompted.


4️⃣ Import the Workflow

  1. Click the ... menu in the top-right corner
  2. Select Import from File
  3. Choose Affiliate-Submission-Hub.json from the workflows directory

5️⃣ Configure Credentials

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.


6️⃣ Update Workflow Parameters

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

7️⃣ Activate the Workflow

  1. Toggle the Active switch in the top-right corner
  2. Status should show Active (green)

✅ Setup Complete!

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.

📘 Usage

🎯 User Entry Points

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

1️⃣ Submitting a Lead

Share your Tally.so form URL publicly. Users fill in the following:

Field Type Required Example
Name Text ✅ Yes John Doe
Email Email ✅ 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.


2️⃣ Testing the Workflow

To verify everything works correctly:

  1. Open n8n interface at http://localhost:5678
  2. Open the Affiliate Submission Hub workflow
  3. Click on each node sequentially
  4. Click Test Step to execute individually
  5. Verify outputs at each stage

Sample Test Data:

Name: John Doe
Email Address: [email protected]
Phone Number: +1 234 567 8900
Affiliation Code: Beast2025 

3️⃣ Expected Outputs

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 Email 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

4️⃣ Success Indicators

✅ Submission successful when:

  • New row appears in {affiliation_code}_Submissions sheet
  • 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

5️⃣ Managing the Workflow

Check Workflow Status:

  1. Open n8n interface at http://localhost:5678
  2. Locate Affiliate Submission Hub workflow
  3. Check the toggle — Green = Active, Gray = Inactive

Stop the Workflow:

docker compose down

Restart the Workflow:

docker compose up -d

View Logs:

docker compose logs -f

📄 License

This project is licensed under the MIT License — see the LICENSE file for details.

👤 Author

Neloy Barman – AI Agent Builder | Automation Engineer | Chatbot Developer


Built with ☕ and automation in mind by Neloy Barman


📝 Documentation crafted with assistance from Claude AI

About

Automatically capture affiliate lead submissions and route them to dedicated Google Sheets — with zero manual effort.

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors