Route Tally affiliate leads to Google Sheets and notify teams in Slack
UnknownWhat this workflow does
This workflow has 11 nodes and runs on Tally events. Along the way it connects Slack, Google Sheets, Google Drive and Tallyforms (community).
How it runs
Trigger: On Tally events.
- Extract Form Fields (Edit Fields (Set)): sets 6 fields: Name, Email Address, Phone Number…
- Find Affiliate Sheet (Google Drive): work with file folder
- Sheet Exists? (If): checks a condition and branches into true / false
- Append Data (Existing Sheet) (Google Sheets): append
- Create Affiliate Sheet (Google Sheets): work with spreadsheet
- Build Slack Message (Code): runs custom JavaScript code
- Move to Target Folder (Google Drive): move
- Send Lead Notification (Slack): uses Slack
- Format Row Data (Code): runs custom JavaScript code
- Append Data (New Sheet) (Google Sheets): append
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-tallyforms is verified or supports 3.0 (used in Submission Trigger).
Nodes used (7)
- Slack
n8n-nodes-base.slack - Tally Trigger
n8n-nodes-tallyforms.tallyTrigger - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - Google Drive
n8n-nodes-base.googleDrive - If
n8n-nodes-base.if - Code
n8n-nodes-base.code
From the author
Who’s it for Affiliate managers, partner programs, and teams collecting leads via public forms who want automated, error-free routing to separate spreadsheets per affiliate — no more manual copying or sheet hunting. What it does This workflow captures new…