Email Follow-Up Sequence Agent

Automated Lead Follow-Up Sequence Agent

What This Agent Does

This powerful automation agent manages a multi-stage email follow-up sequence for your sales leads, eliminating manual tracking and ensuring no prospect falls through the cracks. Running daily at 9 AM, it automatically reads your lead list from Google Sheets, evaluates each prospect's stage, and sends perfectly-timed follow-up emails at Day 1, Day 3, Day 7, and Day 14 intervals. The agent then intelligently updates your spreadsheet with sent dates, progression stages, and next follow-up dates—creating a self-managing sales pipeline.

Key benefits include:

• Saves 5-10 hours weekly by automating repetitive follow-up emails
• Increases response rates through consistent, timely touchpoints
• Eliminates human error in tracking follow-up dates and lead stages
• Scales effortlessly from 10 to 1,000+ leads without additional effort
• Maintains data integrity with automatic spreadsheet updates

Target use cases: Sales teams managing lead nurturing sequences, business development professionals handling multiple prospects, agencies coordinating client outreach, and any organization needing systematic follow-up workflows.

Who Is It For

This agent is ideal for:

• Sales professionals juggling multiple leads and follow-up timelines
• Small to mid-size teams without dedicated CRM infrastructure
• Entrepreneurs bootstrapping their sales process
• Account executives wanting to focus on high-value conversations rather than administrative tasks
• Marketing teams nurturing inbound leads through automated sequences
• Agencies managing client outreach at scale

No coding experience required—just a Google Sheet and Gmail account!

Required Integrations

Google Sheets

Why it's needed: Google Sheets serves as your lead database and tracking system. The agent reads lead information from your sheet and updates it with follow-up history, ensuring a single source of truth for your pipeline.

Setup steps:

1. Create a Google Sheet with the following columns (minimum):

   • email - Lead's email address
   • name - Lead's full name
   • first_name - Lead's first name (for personalization)
   • stage - Current follow-up stage (Day 1, Day 3, Day 7, Day 14, or Complete)
   • last_sent_date - Date of last email sent
   • next_follow_up_date - Calculated next follow-up date
   • status - Current status (Active, Completed, or Skipped)

2. Share your Google Sheet with edit permissions (you'll need the shareable link)

3. Copy your sheet URL from the browser address bar—it will look like:

   https://docs.google.com/spreadsheets/d/YOUR_SHEET_ID/edit
   

4. In TaskAGI, navigate to Integrations and select Google Sheets

5. Authenticate by clicking "Connect" and granting TaskAGI permission to access your Google account

6. Paste your sheet URL into the sheet_url parameter fields (you'll see this in multiple nodes)

7. Verify column names match exactly—the agent references email, name, first_name, stage, etc.

Gmail

Why it's needed: Gmail delivers your personalized follow-up emails to prospects at the right time, maintaining your professional communication channel.

Setup steps:

1. Use your existing Gmail account (no separate setup required if you already have Gmail)

2. In TaskAGI, navigate to Integrations and select Gmail

3. Click "Connect" and authenticate with your Gmail account

4. Grant permissions when prompted—TaskAGI needs permission to send emails on your behalf

5. Verify sender address shows your correct Gmail address (this is what recipients will see)

6. Enable "Less secure app access" if using a personal Gmail account (Google will prompt you, or enable in your Google Account settings under Security)

7. For Gmail Business accounts, ensure your administrator hasn't blocked third-party app access

Configuration in TaskAGI:

• The Gmail nodes are pre-configured with email templates
• Verify the to field references [[nodes.7.email]] (the parsed lead email)
• Subject lines use dynamic fields like [[nodes.7.name]] for personalization
• Email bodies contain your follow-up messaging (customize these to match your voice)

Configuration Steps

Step 1: Review Agent Name and Purpose (Nodes 1-3)

These informational nodes help you document your workflow:

• Agent Name Options: Name your agent something descriptive like "Lead Follow-Up Sequence" or "Sales Pipeline Automation"
• Category & Industry: Select your industry (SaaS, Real Estate, Services, etc.) for organizational purposes
• Workflow Overview: Add a brief description of what this automation accomplishes

No configuration needed—these are reference nodes.

Step 2: Set Your Daily Trigger (Node 4)

Daily Schedule (9 AM)

• Parameter: schedule_interval
• Set to: 9:00 AM (or your preferred time)
• Timezone: Select your local timezone
• Frequency: Daily

This ensures your follow-up sequence runs automatically every morning, checking for leads that need outreach.

Step 3: Connect Your Lead Source (Node 5)

Read Follow-Up Leads

• Node type: googlesheets.getSheetFromUrl
• Parameter: sheet_url = Your Google Sheet URL (from integration setup)
• Expected output: A list of all leads from your sheet

Configuration:

sheet_url: https://docs.google.com/spreadsheets/d/YOUR_SHEET_ID/edit

This node reads your entire lead list each morning, pulling fresh data.

Step 4: Loop Through Each Lead (Node 6)

Process Each Lead

• Node type: core.loop
• Input: Output from Node 5 (your lead list)
• Action: Processes one lead at a time through the sequence

The loop ensures every lead gets evaluated and processed individually.

Step 5: Extract Lead Information (Node 7)

Parse Lead Data

• Node type: core.function
• Input: Current lead from loop
• Output: Structured data with fields: email, name, first_name, stage, last_sent_date

This node extracts and formats lead information for use in subsequent steps.

Step 6: Validate Lead (Node 8)

Check if Should Process

• Node type: core.if_condition
• Condition: Verify lead has required fields (email, name, stage)
• True path: Continue to routing
• False path: Skip lead

This prevents errors by ensuring leads have complete information before processing.

Step 7: Route by Follow-Up Stage (Node 9)

Route by Stage

• Node type: core.switch
• Input: Lead's current stage field
• Cases:
  • Case 0: stage == "Day 1" → Send Day 1 Email (Node 10)
  • Case 1: stage == "Day 3" → Send Day 3 Email (Node 11)
  • Case 2: stage == "Day 7" → Send Day 7 Email (Node 12)
  • Case 3: stage == "Day 14" → Send Day 14 Email (Node 13)

This intelligent routing ensures each lead receives the appropriate email for their stage.

Step 8: Send Stage-Specific Emails (Nodes 10-13)

Send Day 1 Email

• To: [[nodes.7.email]] (parsed lead email)
• Subject: Quick Follow-Up - [[nodes.7.name]]
• Body: Customize with your opening message
• Example: "Hi [[nodes.7.first_name]], I wanted to follow up on our conversation..."

Send Day 3 Email

• Subject: Thought You'd Find This Helpful - [[nodes.7.name]]
• Body: Share valuable content or insights relevant to their needs

Send Day 7 Email

• Subject: Last Check-In - [[nodes.7.name]]
• Body: Gentle reminder with clear next steps

Send Day 14 Final Email

• Subject: Final Note - Leaving This Open for You
• Body: Professional closing message, mark as final touchpoint

Customization tips:

• Replace placeholder text with your authentic voice
• Include specific value propositions relevant to your industry
• Add links to resources, calendars, or case studies
• Keep tone professional but personable

Step 9: Consolidate Results (Node 14)

Merge After Send

• Node type: core.merge
• Input: All four email paths converge here
• Output: Unified data stream for updates

This node brings all pathways back together for consistent processing.

Step 10: Calculate Next Stage (Node 15)

Calculate Next Stage

• Node type: core.function
• Logic: Advances lead to next stage
  • Day 1 → Day 3
  • Day 3 → Day 7
  • Day 7 → Day 14
  • Day 14 → Complete
• Output: Updated stage value

Step 11-14: Update Your Spreadsheet (Nodes 16-19)

These nodes update your Google Sheet with follow-up history:

Update Last Sent Date (Node 16)

• Parameter: last_sent_date = Today's date
• Purpose: Track when email was sent

Update Stage (Node 17)

• Parameter: stage = Next calculated stage
• Purpose: Progress lead through sequence

Update Next Follow-Up Date (Node 18)

• Parameter: next_follow_up_date = Calculated date (3, 7, or 14 days from today)
• Purpose: Plan future touchpoints

Update Status (Node 19)

• Parameter: status = "Active" (or "Completed" if Day 14 sent)
• Purpose: Track overall lead status

Testing Your Agent

Pre-Launch Checklist

Before running your agent in production:

1. Verify integrations are connected

   • Google Sheets shows "Connected" status
   • Gmail shows "Connected" status

2. Test with sample data

   • Add 2-3 test leads to your Google Sheet
   • Include all required columns with sample values
   • Use a test email address you control (or your own email)

3. Review email templates

   • Read through all four email messages
   • Ensure personalization fields are correct
   • Verify tone matches your brand

Running a Test Execution

1. Navigate to your workflow in TaskAGI
2. Click "Test Run" or "Execute Now" button
3. Select test leads from your sheet (or run against all)
4. Monitor execution in real-time:
   • Watch each node process
   • Verify no errors appear in logs
   • Confirm emails send successfully

What to Verify at Each Step

Expected Results and Success Indicators

✅ Successful execution shows:

• All test leads processed without errors
• Emails arrive in inbox within 2 minutes
• Google Sheet updates with today's date in last_sent_date
• stage column advances to next stage (Day 1 → Day 3, etc.)
• next_follow_up_date calculates correctly (3, 7, or 14 days ahead)
• status shows "Active" for ongoing sequences

❌ Troubleshoot if you see:

• "Sheet URL not found" → Verify URL is correct and sheet is shared
• "Gmail authentication failed" → Reconnect Gmail integration
• "Email not sent" → Check recipient email format in sheet
• "Column not found" → Ensure column names match exactly (case-sensitive)

Going Live

Once testing succeeds:

1. Remove test leads from your production sheet
2. Add your real leads with complete information
3. Schedule the workflow to run daily at your preferred time
4. Monitor first week to ensure smooth operation
5. Adjust email templates based on response rates

Your lead follow-up automation is now ready to scale your sales pipeline! 🚀