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
- What is FollowUp Pilot?
- Installation
- Initial Setup
- Quick Start Tutorial
- Understanding Your Workspace
- 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
- Visit the Google Workspace Marketplace
- Search for “FollowUp Pilot”
- Click Install
- Grant the required permissions:
- Send email on your behalf — Required to send campaign emails
- View and manage spreadsheets — Required to read/write data
- View and manage Gmail — Required for bounce/reply detection
Step 2: Verify Installation
- Open any Google Sheet
- Look for the Action Plan Manager menu in the top menu bar
- 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:
- Open a new or existing Google Sheet
- Click Action Plan Manager menu → 🚀 Initialize System
- 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
- Click Action Plan Manager menu → ⚙️ Configure Settings
- 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:
- Click Action Plan Manager menu → 🔧 Setup Triggers
- Confirm the trigger setup
- The system creates three triggers:
- Execute Scheduled Activities — Runs every 15 minutes to send due emails
- Check for Bounces — Runs every 15 minutes to detect failed deliveries
- 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
- Click Action Plan Manager menu → 🎯 Action Plans → Create New Plan
- Fill in the form:
- Plan Name: New Seller 3-Day Follow-Up
- Description: Initial outreach sequence for new seller leads
- Category: Seller
- Status: Active
- 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
- In the dialog that appears, or from Activities sheet, add a new activity:
- Activity Name: Initial Contact Email
- Activity Type: Email Campaign
- Trigger Timing: Day 1
- Trigger Hours: 9 (sends at 9:00 AM)
- Email Subject: Quick question about {{propertyAddress}}
- 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
- Click Action Plan Manager menu → 👥 Prospects → Add New Prospect
- Fill in prospect details:
- Name: Jane Homeowner
- Email: jane@example.com
- Phone: (555) 987-6543
- Address: 123 Main Street
- City: Springfield
- State: IL
- ZIP: 62701
- Category: Seller
- Click Save Prospect
The system generates a Prospect ID (e.g., PR-000001).
Step 4: Start the Action Plan Execution
- Click Action Plan Manager menu → 🔄 Active Executions → Start New Execution
- Select:
- Action Plan: New Seller 3-Day Follow-Up
- Prospect: Jane Homeowner
- 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
- Click Action Plan Manager menu → 📋 Dashboard
- 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 →