January 22, 2026

Tally to Google Sheets, SendGrid welcomes every lead

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Leads come in, and then the mess starts. Someone copies fields into a sheet, someone forgets to tag the lead, and the “I’ll email them later” promise quietly turns into “they went cold.”

This is where marketing consultants feel the pain first, but agency owners and busy founders run into it too. With this Tally lead automation, every form submission lands in your Google Sheets CRM already tagged, scored, and welcomed by email.

Below, you’ll see exactly what the workflow does, what you get out of it, and how to run it without turning your spreadsheet into a chaotic dumping ground.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Tally to Google Sheets, SendGrid welcomes every lead

Click to explore

flowchart LR

    subgraph sg0["Flow 1"]
        direction LR
        n0["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/webhook.dark.svg' width='40' height='40' /></div><br/>Receive Lead from Tally Form"]
        n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Generate Unique Lead ID"]
        n2["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Auto-Tag Lead by Services"]
        n3["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Calculate Follow-up Date & L.."]
        n4@{ icon: "mdi:database", form: "rounded", label: "Save Lead to CRM Sheet", pos: "b", h: 48 }
        n5@{ icon: "mdi:database", form: "rounded", label: "Log Activity to Tracker", pos: "b", h: 48 }
        n6["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Generate Personalized Welcom.."]
        n7["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/sendGrid.svg' width='40' height='40' /></div><br/>Send Welcome Email via SendG.."]
        n8@{ icon: "mdi:database", form: "rounded", label: "Update Lead Status to Nurtur..", pos: "b", h: 48 }
        n4 --> n5
        n4 --> n6
        n1 --> n2
        n2 --> n3
        n0 --> n1
        n6 --> n7
        n6 --> n8
        n3 --> n4
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n4,n5,n8 database
    class n0 api
    class n1,n2,n3,n6 code
    classDef customIcon fill:none,stroke:none
    class n0,n1,n2,n3,n6,n7 customIcon

The Problem: Leads Fall Through the Cracks in Spreadsheets

Capturing leads with a form is the easy part. The real work starts after the submission: cleaning the data, adding a lead ID, figuring out what service they actually want, and deciding how soon you should follow up. When that work lives in someone’s head (or in a half-finished spreadsheet), it becomes inconsistent fast. One lead gets a thoughtful welcome email, another gets nothing for two days, and your “CRM” turns into a list you don’t trust. Honestly, the worst part is the mental load. You keep re-checking the sheet because you know something got missed.

The friction compounds. Here’s where it usually breaks down.

You end up reformatting columns and fixing typos after every batch of submissions.
Service interest stays vague, so follow-ups are generic and less likely to convert.
Without a score and next follow-up date, “priority” becomes whoever emailed you last.
Welcome emails get delayed or skipped, which makes your brand look slower than it is.

The Solution: Auto-Tag, Score, Log, and Welcome Every New Lead

This workflow turns your Tally submission into a structured CRM entry in Google Sheets, then immediately kicks off a personalized welcome email through SendGrid. It starts the moment a lead hits your form webhook. n8n generates a unique lead ID and a timestamp so you can track conversations without confusion later. Then it analyzes the submission to apply “smart” service tags (like Podcast Lead or Video Editing Lead) and calculates an initial score based on interest level. From there, it sets a next follow-up date automatically, appends everything into your Google Sheets CRM with consistent formatting, logs the action in a separate tracker sheet, and sends a welcome email that matches what the lead said they want. Finally, it updates the lead status to “Nurturing,” so your sheet reflects reality, not hope.

The workflow begins with the Tally webhook and builds a clean lead record. Tagging and scoring happen before anything is written to Google Sheets, so your CRM stays organized. Once the lead is stored and logged, SendGrid sends the welcome email and the status updates automatically.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

Capturing Tally submissions via webhook and standardizing fields.
Generating a unique lead ID, timestamps, and a follow-up date.
Assigning service tags and an initial lead score from form answers.
Appending the lead to Google Sheets, logging activity, and sending a SendGrid welcome email.

Most teams get about 2–5 hours back each week by eliminating copy-paste and cleanup.
Your sheet stays “CRM-clean,” which means you can actually filter and act on it.
Leads receive a welcome email in minutes, not “whenever you remember.”
Follow-ups get clearer because every lead has tags, a score, and a next date.
You build a simple nurturing pipeline without paying for HubSpot or Salesforce.

Example: What This Looks Like

Say you get 20 new leads a week from Tally. Manually, it’s easy to spend about 6 minutes per lead copying fields, adding tags, choosing a follow-up date, and writing a quick first email, which is roughly 2 hours weekly. With this workflow, the “work” is basically submitting the form (which the lead does) and letting n8n process for a minute or two. You still choose how to reply later, but the intake, organization, and welcome message happen automatically.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Tally to capture lead form submissions.
Google Sheets for a lightweight CRM database.
SendGrid API key (get it from your SendGrid dashboard)

Skill level: Intermediate. You’ll connect accounts, copy a Sheets structure, and edit a few tagging/email fields.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

A Tally submission hits your webhook. The workflow starts when someone completes your lead capture form and Tally posts the response into n8n.

The lead gets organized immediately. n8n generates a unique ID and timestamp, then evaluates the submission to apply service tags and compute a first-pass score plus a next follow-up date.

Your Google Sheets CRM gets updated in the right places. The lead is appended to your main “Leads” sheet, while an activity entry is also recorded so you have a trail of what happened and when.

SendGrid welcomes the lead and your status changes automatically. A personalized welcome email is created based on what they asked for, sent via SendGrid, and the lead status in Sheets updates to “Nurturing.”

You can easily modify the service tags and scoring rules to match your offers and how you qualify leads. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Webhook Trigger

Set up the entry point so new lead submissions can start the workflow.

Add the Inbound Lead Webhook node as your trigger.
Set HTTP Method to POST.
Set Path to 953a8fef-50bf-46a6-b17c-305d79a6ee07.
Set Response Mode to lastNode to return the final output to the webhook caller.

If you embed this webhook in a form tool, submit a test payload before proceeding to verify the data structure under body.data.fields.

Step 2: Connect Google Sheets

Connect your CRM and activity log spreadsheets to store new leads and activity records.

Open Append Lead to CRM Sheet and set Operation to append.
Set Document to [YOUR_ID] and Sheet Name to Leads.
Map the columns using expressions such as Name → {{$json.name}}, Tags → {{$json.tags}}, Lead ID → {{$json.leadId}}, and Next Touch → {{$json.nextTouch}}.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Append Lead to CRM Sheet.
Open Record Activity Entry and set Operation to append.
Set Document to [YOUR_ID] and Sheet Name to Activity Log, then map Timestamp → {{$now.toISO()}} and Details → =Form submission with tags: {{ $json['Tags'] }}.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Record Activity Entry.
Open Set Lead to Nurturing and set Operation to update with Matching Columns set to Lead ID.
Set Document to [YOUR_ID] and Sheet Name to Leads, then map Status → Nurturing and Last Email Sent → {{$now.format('YYYY-MM-DD')}}.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Set Lead to Nurturing.

⚠️ Common Pitfall: Make sure your Google Sheets column headers exactly match the mapped fields (e.g., Lead ID, Next Touch, Lead Score) or the append/update will fail.

Step 3: Set Up Lead Processing Logic

These code nodes normalize the inbound payload, apply tags, and compute follow-up metadata.

In Assign Lead Identifier, keep the JavaScript that generates the LEAD- ID and extracts fields like What's your Name and email address from body.data.fields.
In Apply Service Tags, verify the serviceTagMap and keyword logic align with your service offerings and tag taxonomy.
In Compute Follow-up & Score, confirm the logic for nextTouch and leadScore matches your pipeline rules, such as setting Status to New Lead and Nurture Stage to 0.
Confirm the execution order: Inbound Lead Webhook → Assign Lead Identifier → Apply Service Tags → Compute Follow-up & Score → Append Lead to CRM Sheet.

If your form field labels change, update the helper lookup labels in Assign Lead Identifier to avoid blank Name or Email values.

Step 4: Configure Email Output and Parallel Branches

Send a customized welcome email and update CRM status while logging activity in parallel.

In Craft Welcome Email, keep the template logic that builds emailSubject and emailBody using the detected tags.
In Dispatch Welcome Email, set Subject to {{ $json.emailSubject }}, To Email to {{ $json['Email'] }}, and Content to {{ $json.emailBody }}.
Credential Required: Connect your sendGridApi credentials in Dispatch Welcome Email.
Note the parallel execution: Append Lead to CRM Sheet outputs to both Record Activity Entry and Craft Welcome Email in parallel.
Also note: Craft Welcome Email outputs to both Dispatch Welcome Email and Set Lead to Nurturing in parallel.

⚠️ Common Pitfall: The email address in Dispatch Welcome Email uses {{ $json['Email'] }}. Ensure your earlier nodes output the Email field (capitalized) or adjust the expression to match your data.

Step 5: Test and Activate Your Workflow

Validate the full lead intake flow and turn it on for production use.

Click Execute Workflow and send a test POST request to the Inbound Lead Webhook URL with a sample body.data.fields payload.
Confirm a new row appears in the Append Lead to CRM Sheet sheet with populated values like Lead ID, Tags, and Next Touch.
Verify Record Activity Entry logs the event and Dispatch Welcome Email sends a message to the lead.
Check that Set Lead to Nurturing updates the lead status to Nurturing and sets Last Email Sent to today’s date.
When satisfied, toggle the workflow to Active for production use.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

Google Sheets credentials can expire or need specific permissions. If things break, check the n8n Credentials page and confirm the connected Google account still has access to the CRM spreadsheet.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.

Frequently Asked Questions

How long does it take to set up this Tally lead automation automation?

About 30–60 minutes if your Sheets and SendGrid account are ready.

Do I need coding skills to automate Tally lead automation?

No. You’ll mostly connect accounts and edit a few mapping fields. There is some light configuration around tags and the email template.

Is n8n free to use for this Tally lead automation workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in SendGrid costs (often free tier) and any OpenAI usage if you add AI-based writing.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I customize this Tally lead automation workflow for different service lines?

Yes, and you should. You can edit the mapping used in the Apply Service Tags node (the workflow’s serviceTagMap) to reflect your actual offers, then adjust the Compute Follow-up & Score logic so “high intent” leads get earlier follow-ups. Many teams also tweak the Craft Welcome Email node to include a relevant link based on the tag, like a case study for “Video Editing Lead.” If you want to swap SendGrid for another provider, you typically replace the Dispatch Welcome Email step and keep everything upstream the same.

Why is my SendGrid connection failing in this workflow?

Most of the time it’s an API key issue or missing permissions on the key you created. Regenerate the key in SendGrid, then update it in n8n and re-test the SendGrid node. Also check that your sending domain (or single sender identity) is verified in SendGrid, otherwise emails may fail or get suppressed. If you’re testing with the same email repeatedly, look at SendGrid suppression lists too.

How many leads can this Tally lead automation automation handle?

A lot. On n8n Cloud, the practical limit is your plan’s monthly executions, and on self-hosted it’s mostly your server capacity. For typical small teams, hundreds of leads a week is completely reasonable as long as your Google Sheets isn’t overloaded with heavy formulas.

Is this Tally lead automation automation better than using Zapier or Make?

Often, yes. n8n is more flexible when you want branching logic, custom scoring rules, or multi-sheet logging without paying extra for every step. Self-hosting is also a real advantage when lead volume grows and you don’t want your automation bill to balloon. Zapier or Make can still be a great fit if you only need a basic “form → sheet → email” flow and you want the fastest setup. If you’re unsure, Talk to an automation expert and describe your lead volume and process.

Once this is live, lead intake stops being a daily chore. The workflow handles the repetitive organizing and welcoming, so you can focus on real follow-up and closing the deal.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": "",
"meta": {
"instanceId": "e11c509d5257dbab6eeea27a5181e56d930bc92c59a74720ab09b6c31fc81861",
"templateId": "",
"templateCredsSetupCompleted": null
},
"name": "Automated Lead Intake Pipeline",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-11233",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
120,
65
],
"parameters": {
"color": 7,
"width": 1080,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "c72203e4-c483-45ca-9ed2-e35f1d6a471b",
"name": "Inbound Lead Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
120,
170
],
"webhookId": "953a8fef-50bf-46a6-b17c-305d79a6ee07",
"parameters": {
"path": "953a8fef-50bf-46a6-b17c-305d79a6ee07",
"options": [],
"httpMethod": "POST",
"responseMode": "lastNode"
},
"typeVersion": 2.1
},
{
"id": "5cdd29a1-3a33-4114-bd51-809859d8ebe7",
"name": "Assign Lead Identifier",
"type": "n8n-nodes-base.code",
"position": [
380,
225
],
"parameters": {
"jsCode": "const timestamp = Date.now();\nconst randomNum = Math.floor(Math.random() * 1000);\nconst leadId = `LEAD-${timestamp}-${randomNum}`;\n\n// Get fields array\nconst fields = $input.item.json.body.data.fields;\n\n// Helper to get a field by label or key\nfunction getField(label) {\n  return fields.find(f => f.label.includes(label) || f.key === label);\n}\n\n// Extract basic info\nconst name = getField(\"What's your Name\")?.value || \"\";\nconst email = getField(\"email address\")?.value || \"\";\n\n// Business type (multiple choice \u2013 get text)\nconst businessField = getField(\"What type of business\");\nlet businessType = \"\";\nif (businessField?.value?.length) {\n  const selectedId = businessField.value[0];\n  const option = businessField.options.find(o => o.id === selectedId);\n  businessType = option?.text || \"\";\n}\n\n// Interest level (multiple choice \u2013 get text)\nconst interestField = getField(\"How interested\");\nlet interestLevel = \"\";\nif (interestField?.value?.length) {\n  const selectedId = interestField.value[0];\n  const option = interestField.options.find(o => o.id === selectedId);\n  interestLevel = option?.text || \"\";\n}\n\n// Services selected (checkboxes \u2013 use IDs \u2192 text)\nconst servicesField = getField(\"What kind of services\");\nlet services = [];\nif (servicesField?.value?.length) {\n  services = servicesField.value.map(id => {\n    const opt = servicesField.options.find(o => o.id === id);\n    return opt?.text;\n  }).filter(Boolean);\n}\n\n// Return final unified structured lead object\nreturn [{\n  json: {\n    leadId: leadId,\n    name,\n    email,\n    businessType,\n    interestLevel,\n    services\n  }\n}];\n"
},
"typeVersion": 2
},
{
"id": "90b6125e-afb8-4235-b162-cc339340d700",
"name": "Apply Service Tags",
"type": "n8n-nodes-base.code",
"position": [
650,
165
],
"parameters": {
"jsCode": "const data = $input.item.json;\n\nconst serviceTagMap = {\n  \"Podcast Production\": \"Podcast Lead\",\n  \"Social Media Management\": \"Social Content Lead\",\n  \"Video Editing\": \"Video Editing Lead\",\n  \"Website Design\": \"Website Lead\",\n  \"Marketing Strategy\": \"Strategy Lead\",\n  \"Content Creation\": \"Content Lead\"\n};\n\nconst detectedTags = [];\n\n// Tag from selected services\nif (data.services) {\n  const selectedServices = Array.isArray(data.services) \n    ? data.services \n    : data.services.split(',').map(s => s.trim());\n  \n  selectedServices.forEach(service => {\n    if (serviceTagMap[service]) {\n      detectedTags.push(serviceTagMap[service]);\n    }\n  });\n}\n\n// Keyword detection fallback\nconst tagKeywords = {\n  \"Podcast Lead\": [\"podcast\", \"audio\", \"episode\"],\n  \"Social Content Lead\": [\"social media\", \"instagram\", \"facebook\", \"tiktok\"],\n  \"Video Editing Lead\": [\"video\", \"editing\", \"youtube\", \"reel\"],\n  \"Website Lead\": [\"website\", \"web design\", \"site\", \"landing page\"],\n  \"Strategy Lead\": [\"strategy\", \"consulting\", \"growth plan\"]\n};\n\nconst textToAnalyze = [\n  data.businessType || \"\",\n  data.services || \"\"\n].join(\" \").toLowerCase();\n\nfor (const [tag, keywords] of Object.entries(tagKeywords)) {\n  for (const keyword of keywords) {\n    if (textToAnalyze.includes(keyword) && !detectedTags.includes(tag)) {\n      detectedTags.push(tag);\n      break;\n    }\n  }\n}\n\nif (detectedTags.length === 0) {\n  detectedTags.push(\"General Lead\");\n}\n\nconst tagsString = detectedTags.join(\", \");\n\nreturn {\n  json: {\n    ...data,\n    tags: tagsString,\n    detectedTags: detectedTags\n  }\n};"
},
"typeVersion": 2
},
{
"id": "7ac7533b-99c9-4bba-93da-f4a3ae5c32a6",
"name": "Compute Follow-up & Score",
"type": "n8n-nodes-base.code",
"position": [
930,
235
],
"parameters": {
"jsCode": "const data = $input.item.json;\nconst today = new Date().toISOString().split('T')[0];\n\n// Calculate next touch based on interest level\nlet daysToAdd = 7;\nif (data.interestLevel.includes(\"Very Interested\")) {\n  daysToAdd = 1;\n} else if (data.interestLevel.includes(\"Interested\")) {\n  daysToAdd = 3;\n} else if (data.interestLevel.includes(\"Somewhat\")) {\n  daysToAdd = 7;\n} else {\n  daysToAdd = 14;\n}\n\nconst nextTouch = new Date();\nnextTouch.setDate(nextTouch.getDate() + daysToAdd);\nconst nextTouchFormatted = nextTouch.toISOString().split('T')[0];\n\n// Initial lead score\nlet initialScore = 20; // Base score for signing up\nif (data.interestLevel.includes(\"Very Interested\")) initialScore = 40;\nelse if (data.interestLevel.includes(\"Interested\")) initialScore = 30;\n\nreturn {\n  json: {\n    ...data,\n    createdDate: today,\n    lastContact: today,\n    nextTouch: nextTouchFormatted,\n    status: \"New Lead\",\n    nurtureStage: 0,\n    leadScore: initialScore,\n    emailOpens: 0,\n    emailClicks: 0,\n    leadMagnetSent: \"NO\",\n    calendlyClicked: \"NO\",\n    meetingBooked: \"NO\",\n    daysInactive: 0,\n    notes: `New lead from form. Tags: ${data.tags}`\n  }\n};"
},
"typeVersion": 2
},
{
"id": "89b2ee2a-2ba2-45d1-abd6-8f8e5c2d5901",
"name": "Append Lead to CRM Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
700,
390
],
"parameters": {
"columns": {
"value": {
"Name": "={{$json.name}}",
"Tags": "={{$json.tags}}",
"Email": "={{$json.email}}",
"Notes": "={{$json.notes}}",
"Status": "={{$json.status}}",
"Lead ID": "={{$json.leadId}}",
"Services": "={{$json.services.join(\", \")}}",
"Lead Score": "={{$json.leadScore}}",
"Next Touch": "={{$json.nextTouch}}",
"Email Opens": "={{$json.emailOpens}}",
"Lead Source": "={{$json.leadSource}}",
"Created Date": "={{$json.createdDate}}",
"Email Clicks": "={{$json.emailClicks}}",
"Last Contact": "={{$json.lastContact}}",
"Business Type": "={{$json.businessType}}",
"Days Inactive": "={{$json.daysInactive}}",
"Nurture Stage": "={{$json.nurtureStage}}",
"Interest Level": "={{$json.interestLevel}}",
"Meeting Booked": "={{$json.meetingBooked}}",
"Last Email Sent": "={{$json.lastEmailSent}}",
"Calendly Clicked": "={{$json.calendlyClicked}}",
"Lead Magnet Sent": "={{$json.leadMagnetSent}}"
},
"schema": [
{
"id": "Lead ID",
"type": "string",
"display": true,
"required": false,
"displayName": "Lead ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Business Type",
"type": "string",
"display": true,
"required": false,
"displayName": "Business Type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Interest Level",
"type": "string",
"display": true,
"required": false,
"displayName": "Interest Level",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Services",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Services",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Lead Source",
"type": "string",
"display": true,
"required": false,
"displayName": "Lead Source",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Tags",
"type": "string",
"display": true,
"required": false,
"displayName": "Tags",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Lead Score",
"type": "string",
"display": true,
"required": false,
"displayName": "Lead Score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Created Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Created Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Contact",
"type": "string",
"display": true,
"required": false,
"displayName": "Last Contact",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Next Touch",
"type": "string",
"display": true,
"required": false,
"displayName": "Next Touch",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Nurture Stage",
"type": "string",
"display": true,
"required": false,
"displayName": "Nurture Stage",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Email Sent",
"type": "string",
"display": true,
"required": false,
"displayName": "Last Email Sent",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Opens",
"type": "string",
"display": true,
"required": false,
"displayName": "Email Opens",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Clicks",
"type": "string",
"display": true,
"required": false,
"displayName": "Email Clicks",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Lead Magnet Sent",
"type": "string",
"display": true,
"required": false,
"displayName": "Lead Magnet Sent",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Calendly Clicked",
"type": "string",
"display": true,
"required": false,
"displayName": "Calendly Clicked",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Meeting Booked",
"type": "string",
"display": true,
"required": false,
"displayName": "Meeting Booked",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Days Inactive",
"type": "string",
"display": true,
"required": false,
"displayName": "Days Inactive",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Notes",
"type": "string",
"display": true,
"required": false,
"displayName": "Notes",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultName": "Leads"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultName": "Complete Mini CRM"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.7
},
{
"id": "43038ebb-c3a0-4c1c-a38b-79031594ca70",
"name": "Record Activity Entry",
"type": "n8n-nodes-base.googleSheets",
"position": [
410,
450
],
"parameters": {
"columns": {
"value": {
"Name": "={{ $json['Name'] }}",
"Details": "=Form submission with tags: {{ $json['Tags'] }}",
"Lead ID": "={{ $json['Lead ID'] }}",
"Timestamp": "={{ $now.toISO() }}",
"Activity Type": "Lead Captured"
},
"schema": [
{
"id": "Timestamp",
"type": "string",
"display": true,
"required": false,
"displayName": "Timestamp",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Lead ID",
"type": "string",
"display": true,
"required": false,
"displayName": "Lead ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Activity Type",
"type": "string",
"display": true,
"required": false,
"displayName": "Activity Type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Details",
"type": "string",
"display": true,
"required": false,
"displayName": "Details",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1376113895,
"cachedResultName": "Activity Log"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultName": "Complete Mini CRM"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.7
},
{
"id": "fa5f1269-8205-4de4-bf61-a72c29be537d",
"name": "Craft Welcome Email",
"type": "n8n-nodes-base.code",
"position": [
720,
520
],
"parameters": {
"jsCode": "const data = $input.item.json;\nconst tags = data.detectedTags || [];\n\nlet servicesMention = \"\";\nif (tags.includes(\"Podcast Lead\")) {\n  servicesMention = \"I noticed you're interested in podcast production. We help creators launch and grow shows that actually get heard.\";\n} else if (tags.includes(\"Video Editing Lead\")) {\n  servicesMention = \"I see you're looking for video editing support. We transform raw footage into scroll-stopping content that drives results.\";\n} else if (tags.includes(\"Social Content Lead\")) {\n  servicesMention = \"Social media can feel overwhelming, we get it. We help businesses turn social platforms into lead-generating machines.\";\n} else if (tags.includes(\"Website Lead\")) {\n  servicesMention = \"Your website should work as hard as you do. We build sites that convert visitors into customers.\";\n} else if (tags.includes(\"Strategy Lead\")) {\n  servicesMention = \"Great marketing starts with clear strategy. We help businesses cut through the noise and focus on what actually moves the needle.\";\n} else {\n  servicesMention = \"We specialize in digital marketing that gets real results, from content creation to complete campaign management.\";\n}\n\nconst subject = `Welcome, ${data['Name']}! Let's talk about your marketing goals`;\n\nconst emailBody = `Hi ${data['Name']},\n\nThanks for reaching out, I'm glad you found us.\n\nI want to confirm that we received your information and let you know what happens next.\n\n${servicesMention}\n\nHere's what you can expect:\n\n\u2192 We will review your details and put together some initial thoughts\n\u2192 You'll hear back from us within 24-48 hours\n\u2192 We'll schedule a quick call to discuss your specific needs (no pressure, no sales pitch, just a genuine conversation about how we might help)\n\nIn the meantime, feel free to reply to this email with any questions or additional context about what you're trying to achieve. The more I know, the more helpful I can be when we connect.\n\nLooking forward to speaking with you soon.\n\nBest regards,\nFlowpast Team\n\nP.S. Keep an eye on your inbox. Over the next week, I'll send you some helpful insights about building marketing systems that actually work.`;\n\nreturn {\n  json: {\n    ...data,\n    emailSubject: subject,\n    emailBody: emailBody\n  }\n};"
},
"typeVersion": 2
},
{
"id": "057b5ac6-07cd-46cc-9460-e0305a82dfae",
"name": "Dispatch Welcome Email",
"type": "n8n-nodes-base.sendGrid",
"position": [
1080,
440
],
"parameters": {
"subject": "={{ $json.emailSubject }}",
"toEmail": "={{ $json['Email'] }}",
"resource": "mail",
"contentValue": "={{ $json.emailBody }}",
"additionalFields": []
},
"credentials": {
"sendGridApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "0c3d1194-f9f2-4ca9-bbf0-8a91fcb15652",
"name": "Set Lead to Nurturing",
"type": "n8n-nodes-base.googleSheets",
"position": [
1100,
590
],
"parameters": {
"columns": {
"value": {
"Status": "Nurturing",
"Lead ID": "={{ $json['Lead ID'] }}",
"Nurture Stage": " 0",
"Last Email Sent": "={{ $now.format('YYYY-MM-DD') }}"
},
"schema": [
{
"id": "Lead ID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Lead ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Business Type",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Business Type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Interest Level",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Interest Level",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Services",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Services",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Lead Source",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Lead Source",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Tags",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Tags",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Lead Score",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Lead Score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Created Date",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Created Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Contact",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Last Contact",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Next Touch",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Next Touch",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Nurture Stage",
"type": "string",
"display": true,
"required": false,
"displayName": "Nurture Stage",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Email Sent",
"type": "string",
"display": true,
"required": false,
"displayName": "Last Email Sent",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Opens",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Email Opens",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Clicks",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Email Clicks",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Lead Magnet Sent",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Lead Magnet Sent",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Calendly Clicked",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Calendly Clicked",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Meeting Booked",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Meeting Booked",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Days Inactive",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Days Inactive",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Notes",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Notes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Lead ID"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultName": "Leads"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultName": "Complete Mini CRM"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.7
}
],
"active": false,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": "",
"connections": {
"Append Lead to CRM Sheet": {
"main": [
[
{
"node": "Record Activity Entry",
"type": "main",
"index": 0
},
{
"node": "Craft Welcome Email",
"type": "main",
"index": 0
}
]
]
},
"Assign Lead Identifier": {
"main": [
[
{
"node": "Apply Service Tags",
"type": "main",
"index": 0
}
]
]
},
"Record Activity Entry": {
"main": [
[]
]
},
"Apply Service Tags": {
"main": [
[
{
"node": "Compute Follow-up & Score",
"type": "main",
"index": 0
}
]
]
},
"Inbound Lead Webhook": {
"main": [
[
{
"node": "Assign Lead Identifier",
"type": "main",
"index": 0
}
]
]
},
"Dispatch Welcome Email": {
"main": [
[]
]
},
"Set Lead to Nurturing": {
"main": [
[]
]
},
"Craft Welcome Email": {
"main": [
[
{
"node": "Dispatch Welcome Email",
"type": "main",
"index": 0
},
{
"node": "Set Lead to Nurturing",
"type": "main",
"index": 0
}
]
]
},
"Compute Follow-up & Score": {
"main": [
[
{
"node": "Append Lead to CRM Sheet",
"type": "main",
"index": 0
}
]
]
}
}
}