Getting Started with FollowUp Pilot

Getting Started with FollowUp Pilot

Welcome to FollowUp Pilot — the email follow-up system that lives inside Google Sheets™. This guide will help you set up and start using the system in minutes.


Table of Contents

  1. What is FollowUp Pilot?
  2. Installation
  3. Initial Setup
  4. Quick Start Tutorial
  5. Understanding Your Workspace
  6. Next Steps

What is FollowUp Pilot?

FollowUp Pilot is a Google Workspace™ add-on that turns Google Sheets into a powerful email drip campaign manager. Unlike standalone email marketing platforms, FollowUp Pilot:

  • Lives in Your Spreadsheet — All data stays in Google Sheets where you already work
  • Automates Follow-Up Sequences — Build multi-step drip campaigns that run automatically
  • Personalizes Every Email — 14 merge fields let you customize each message
  • Detects Replies & Bounces — Auto-pause campaigns when prospects respond
  • Works with Gmail™ — Emails send from your Gmail account, not a third-party server

Perfect for: Sales teams, real estate agents, recruiters, consultants, and anyone who needs consistent follow-up with prospects.


Installation

Step 1: Install from Google Workspace Marketplace

  1. Visit the Google Workspace Marketplace
  2. Search for “FollowUp Pilot”
  3. Click Install
  4. Grant the required permissions:
  5. Send email on your behalf — Required to send campaign emails
  6. View and manage spreadsheets — Required to read/write data
  7. View and manage Gmail — Required for bounce/reply detection

Step 2: Verify Installation

  1. Open any Google Sheet
  2. Look for the Action Plan Manager menu in the top menu bar
  3. If you see it, installation was successful!

Initial Setup

Step 1: Initialize Your Workspace

The first time you use FollowUp Pilot in a spreadsheet, you need to initialize it:

  1. Open a new or existing Google Sheet
  2. Click Action Plan Manager menu → 🚀 Initialize System
  3. Wait 10-20 seconds while the system creates the necessary sheets

What happens during initialization:
– Creates 6 core sheets: Action Plans, Activities, Prospects, Plan Executions, Activity Log, Email Tracking, Settings
– Sets up data validation rules
– Configures column formatting
– Creates automation triggers

Step 2: Configure Basic Settings

  1. Click Action Plan Manager menu → ⚙️ Configure Settings
  2. The Settings sheet opens — fill in these required fields:
Setting Value Example
Agent Name Your full name John Smith
Agent Email Your email address john@example.com
Agent Phone Your phone number (555) 123-4567
Company Name Your company name Acme Real Estate
Time Zone Your time zone America/New_York

Optional settings:
– Email Signature — Default signature for all emails
– Default Send Time — Preferred time to send emails (default: 09:00)
– Max Emails Per Hour — Gmail sending limit (default: 50)

Step 3: Set Up Automation Triggers

FollowUp Pilot uses time-based triggers to send emails and check for replies/bounces:

  1. Click Action Plan Manager menu → 🔧 Setup Triggers
  2. Confirm the trigger setup
  3. The system creates three triggers:
  4. Execute Scheduled Activities — Runs every 15 minutes to send due emails
  5. Check for Bounces — Runs every 15 minutes to detect failed deliveries
  6. Check for Replies — Runs every 15 minutes to detect prospect responses

Important: These triggers run automatically in the background. You don’t need to keep the spreadsheet open.


Quick Start Tutorial

Let’s create your first action plan and send your first automated email sequence.

Tutorial: 3-Day Real Estate Follow-Up Sequence

Goal: Create a 3-email sequence for new seller leads.

Step 1: Create an Action Plan

  1. Click Action Plan Manager menu → 🎯 Action Plans → Create New Plan
  2. Fill in the form:
  3. Plan Name: New Seller 3-Day Follow-Up
  4. Description: Initial outreach sequence for new seller leads
  5. Category: Seller
  6. Status: Active
  7. Click Save Plan

The system generates a unique Plan ID (e.g., AP-NEW_SELLER_3_DAY_20260321).

Step 2: Add Activities to Your Plan

Now we’ll add three email activities with specific timing:

Activity 1 – Day 1: Initial Contact

  1. In the dialog that appears, or from Activities sheet, add a new activity:
  2. Activity Name: Initial Contact Email
  3. Activity Type: Email Campaign
  4. Trigger Timing: Day 1
  5. Trigger Hours: 9 (sends at 9:00 AM)
  6. Email Subject: Quick question about {{propertyAddress}}
  7. Email Template: (write email content or select template)

Example email body:

Hi {{firstName}},

I noticed you might be considering selling your home at {{propertyAddress}}. 

I've helped dozens of homeowners in {{city}} sell their properties quickly and for top dollar. I'd love to share a free market analysis that shows what your home could sell for in today's market.

Are you available for a quick 10-minute call this week?

Best regards,
{{agentName}}
{{companyName}}
{{agentPhone}}

Activity 2 – Day 3: Follow-Up

Add another activity:
– Activity Name: Follow-Up – Market Report
– Activity Type: Email Campaign
– Trigger Timing: Day 3
– Trigger Hours: 14 (sends at 2:00 PM)
– Email Subject: Market report for {{propertyAddress}}

Activity 3 – Day 7: Final Touch

Add a third activity:
– Activity Name: Final Follow-Up
– Activity Type: Email Campaign
– Trigger Timing: Day 7
– Trigger Hours: 10

Step 3: Add a Prospect

  1. Click Action Plan Manager menu → 👥 Prospects → Add New Prospect
  2. Fill in prospect details:
  3. Name: Jane Homeowner
  4. Email: jane@example.com
  5. Phone: (555) 987-6543
  6. Address: 123 Main Street
  7. City: Springfield
  8. State: IL
  9. ZIP: 62701
  10. Category: Seller
  11. Click Save Prospect

The system generates a Prospect ID (e.g., PR-000001).

Step 4: Start the Action Plan Execution

  1. Click Action Plan Manager menu → 🔄 Active Executions → Start New Execution
  2. Select:
  3. Action Plan: New Seller 3-Day Follow-Up
  4. Prospect: Jane Homeowner
  5. Click Start Execution

What happens next:

  • The system creates an execution record in the Plan Executions sheet
  • Calculates the exact send times for each activity
  • Schedules all three emails
  • The first email sends immediately (or at the specified time)
  • The subsequent emails send automatically on Day 3 and Day 7

Step 5: Monitor Your Campaign

  1. Click Action Plan Manager menu → 📋 Dashboard
  2. Or open the Activity Log sheet directly

You’ll see:
– Activity Log — Every email that has been scheduled, sent, or failed
– Plan Executions — Current status of each active campaign
– Email Tracking — Delivery status and bounce information


Understanding Your Workspace

After initialization, your spreadsheet contains these sheets:

1. Action Plans

Stores all your drip campaign templates:
– Plan ID, Plan Name, Description, Category, Status
– Total Activities, Created Date, Last Modified

2. Activities

Stores individual steps within each action plan:
– Activity ID, Plan ID, Sequence Number
– Activity Name, Activity Type (Email/To-Do)
– Trigger Timing, Trigger Hours
– Email Subject, Email Template ID, Instructions

3. Prospects

Your contact database:
– Prospect ID, First Name, Last Name, Full Name
– Email, Phone, Address, City, State, ZIP
– Category, Source, Status, Tags, Notes

4. Plan Executions

Tracks active campaigns:
– Execution ID, Plan ID, Prospect Name/Email
– Start Date, Status (Active/Paused/Completed/Cancelled)
– Current Activity, Progress Percentage
– Reply Detection status

5. Activity Log

Detailed history of every action:
– Log ID, Execution ID, Activity ID
– Scheduled Date, Executed Date, Status
– Email Subject, Message ID
– Reply Detection, Bounce Status

6. Email Tracking

Delivery monitoring (created automatically):
– Message ID, Custom Message ID
– Recipient Email, Sent Date
– Bounce Status, Delivery Status
– Retry Attempts

7. Settings

Your configuration preferences:
– Agent Name, Email, Phone
– Company Name, Email Signature
– Time Zone, Send Time, Limits


Next Steps

Now that you’ve completed the setup and tutorial:

1. Explore Advanced Features
– Action Plans Guide — Master multi-step sequences
– Templates Guide — Create reusable email templates
– AI Generator Guide — Auto-generate campaigns with AI

2. Import Your Prospect List
– Prospects Guide — Learn how to bulk import from CSV

3. Understand Automation
– Execution & Monitoring Guide — Track campaign performance
– Bounce & Reply Detection — How automatic detection works

4. Upgrade Your Plan
– Free: 10 action plans, 25 prospects, 50 emails/month
– Pro: Unlimited everything + AI generator
– View Pricing & Upgrade Options


Quick Reference

Common Menu Actions

Menu Path What It Does
Action Plan Manager → 📋 Dashboard View overall system status
Action Plan Manager → 🎯 Action Plans → Create New Plan Build a new drip sequence
Action Plan Manager → 👥 Prospects → Add New Prospect Add a single prospect
Action Plan Manager → 👥 Prospects → Import CSV Bulk import prospects
Action Plan Manager → 🔄 Active Executions → Start New Execution Launch campaign for a prospect
Action Plan Manager → 📧 Email Templates → Template Library Manage email templates
Action Plan Manager → 📧 Email Templates → 🤖 AI Generate Templates Use AI to create campaigns
Action Plan Manager → 💳 Billing → View Plan & Usage Check limits and usage

Personalization Fields

Use these merge variables in any email:

Variable What It Inserts Example
{{firstName}} Prospect’s first name Jane
{{lastName}} Prospect’s last name Homeowner
{{prospectName}} Prospect’s full name Jane Homeowner
{{prospectEmail}} Prospect’s email jane@example.com
{{prospectPhone}} Prospect’s phone (555) 987-6543
{{propertyAddress}} Prospect’s address 123 Main Street
{{city}} Prospect’s city Springfield
{{state}} Prospect’s state IL
{{zip}} Prospect’s ZIP 62701
{{agentName}} Your name (from Settings) John Smith
{{agentEmail}} Your email john@example.com
{{agentPhone}} Your phone (555) 123-4567
{{companyName}} Your company Acme Real Estate
{{currentDate}} Today’s date March 21, 2026

Getting Help

Need assistance?

  • Troubleshooting Guide: See common issues and solutions
  • Support Email: support@hunterfisherllc.com
  • Documentation: Full User Guide Index
  • Privacy Policy: https://software.hunterfisherllc.com/privacy-policy/
  • Terms of Service: https://software.hunterfisherllc.com/terms-of-service/

You’re ready to start automating your follow-up process! 🚀

Continue to: Action Plans User Guide →