Quick Reference Guide

Quick Reference Guide

Fast lookup for common tasks, menu paths, merge fields, and keyboard shortcuts.


Common Tasks

Getting Started

Task Menu Path
Initialize system (first time) Action Plan Manager → 🚀 Initialize System
Configure basic settings Action Plan Manager → ⚙️ Configure Settings
Set up automation triggers Action Plan Manager → 🔧 Setup Triggers
View system status Action Plan Manager → 🔧 System → System Status

Action Plans

Task Menu Path
View all action plans Action Plan Manager → 🎯 Action Plans → View All Plans
Create new action plan Action Plan Manager → 🎯 Action Plans → Create New Plan
Edit action plan Open Action Plans sheet, edit directly
Add activities to plan Open Activities sheet, add rows

Prospects

Task Menu Path
View all prospects Action Plan Manager → 👥 Prospects → View All Prospects
Add single prospect Action Plan Manager → 👥 Prospects → Add New Prospect
Import prospects from CSV Action Plan Manager → 👥 Prospects → Import CSV
Edit prospect Open Prospects sheet, edit directly

Templates

Task Menu Path
View template library Action Plan Manager → 📧 Email Templates → Template Library
Create new template Action Plan Manager → 📧 Email Templates → Create New Template
Import from Google Drive Action Plan Manager → 📧 Email Templates → Import from Drive
Import from text/CSV Action Plan Manager → 📧 Email Templates → Import from Text/CSV
AI generate templates (Pro) Action Plan Manager → 📧 Email Templates → 🤖 AI Generate Templates

Executions

Task Menu Path
Start campaign for one prospect Action Plan Manager → 🔄 Active Executions → Start New Execution
View active campaigns Action Plan Manager → 🔄 Active Executions → View Active Plans
View execution reports Action Plan Manager → 🔄 Active Executions → Execution Reports
Pause campaign Open Plan Executions sheet, change Status to “Paused”
Resume campaign Open Plan Executions sheet, change Status to “Active”

Monitoring

Task Menu Path
View dashboard Action Plan Manager → 📋 Dashboard
Check activity log Open Activity Log sheet
View sent emails Open Activity Log sheet, filter Status = “Sent”
Check for bounces Open Email Tracking sheet
Find replies Open Plan Executions, filter Auto Paused by Reply = TRUE

Billing

Task Menu Path
Check usage and limits Action Plan Manager → 💳 Billing → View Plan & Usage
Upgrade to Pro Action Plan Manager → 💳 Billing → Upgrade to Pro
Configure AI settings (Pro) Action Plan Manager → 💳 Billing → ⚙️ AI Settings

Sheet Reference

Core Sheets

Sheet Name Purpose Key Columns
Action Plans Stores action plan templates Plan ID, Plan Name, Description, Category, Status
Activities Individual steps in each plan Activity ID, Plan ID, Sequence Number, Activity Type, Trigger Timing
Prospects Contact database Prospect ID, First Name, Last Name, Email, Phone, Address, City, State
Plan Executions Active campaigns Execution ID, Plan ID, Prospect Name/Email, Status, Progress, Next Action Date
Activity Log History of all sent emails Log ID, Execution ID, Activity ID, Scheduled Date, Executed Date, Status, Reply Detected
Email Tracking Delivery monitoring Message ID, Recipient Email, Bounce Status, Retry Attempts
Settings Configuration Agent Name, Agent Email, Company Name, Time Zone

Status Values

Action Plan Status:
– Active
– Inactive
– Archived

Execution Status:
– Active (campaign running)
– Paused (temporarily stopped)
– Completed (all activities done)
– Cancelled (permanently stopped)

Activity Log Status:
– Scheduled (queued to send)
– Sent (sent successfully)
– Delivered (confirmed delivery)
– Failed (send error)
– Hard Bounce (permanent failure)
– Soft Bounce (temporary failure)
– Retrying (attempting resend)
– Skipped (manually skipped)

Bounce Status (Email Tracking):
– Pending (just sent, awaiting confirmation)
– Delivered (successful delivery)
– Soft Bounce (temporary failure, will retry)
– Hard Bounce (permanent failure, won’t retry)


Merge Fields Reference

Prospect Fields

Merge Variable Description Example Value
{{firstName}} Prospect’s first name Jane
{{lastName}} Prospect’s last name Homeowner
{{prospectName}} Prospect’s full name Jane Homeowner
{{prospectEmail}} Prospect’s email address jane@example.com
{{prospectPhone}} Prospect’s phone number (555) 123-4567
{{propertyAddress}} Prospect’s street address 123 Main Street
{{city}} Prospect’s city Springfield
{{state}} Prospect’s state IL
{{zip}} Prospect’s ZIP code 62701

Agent/System Fields

Merge Variable Description Example Value
{{agentName}} Your name (from Settings) John Smith
{{agentEmail}} Your email (from Settings) john@example.com
{{agentPhone}} Your phone (from Settings) (555) 987-6543
{{companyName}} Your company (from Settings) Acme Real Estate
{{currentDate}} Today’s date March 21, 2026

Important Rules:
– ✅ Merge fields are case-sensitive: {{firstName}} works, {{firstname}} doesn’t
– ✅ No spaces inside braces: {{firstName}} works, {{ firstName }} doesn’t
– ✅ Use exact spelling from reference above


Activity Timing Reference

Timing Format

Format: Day X where X is the number of days after campaign start

Examples:
– Day 1 — Sends on the same day as campaign start
– Day 3 — Sends 3 days after campaign start
– Day 7 — Sends 7 days after campaign start
– Day 14 — Sends 14 days after campaign start

Trigger Hours

Format: 0-23 (24-hour clock)

Hour Value Time (12-hour) Common Use
0 12:00 AM Midnight sends
6 6:00 AM Early morning
9 9:00 AM Most common — business hours start
10 10:00 AM Mid-morning
12 12:00 PM Noon
14 2:00 PM Early afternoon
17 5:00 PM End of business
20 8:00 PM Evening

Best practice: Send during business hours (9 AM – 5 PM) for B2B, anytime for B2C.


Plan Limits Reference

Free Plan Limits

  • Action Plans: 10
  • Prospects: 25
  • Emails per Month: 50
  • AI Generator: ❌ Not available
  • Support: Community (48-72 hours)

Pro Monthly ($29/month)

  • Action Plans: ✅ Unlimited
  • Prospects: ✅ Unlimited
  • Emails per Month: ✅ Unlimited
  • AI Generator: ✅ Included (requires your API key)
  • Support: ✅ Dedicated (24 hours)

Pro Lifetime ($249 one-time)

  • Action Plans: ✅ Unlimited
  • Prospects: ✅ Unlimited
  • Emails per Month: ✅ Unlimited
  • AI Generator: ✅ Included (requires your API key)
  • Support: ✅ Lifetime dedicated
  • Future Updates: ✅ All included

Gmail Sending Limits

Important: These are Gmail’s limits, not FollowUp Pilot’s limits.

Account Type Daily Limit Hourly Guideline
Regular Gmail 500 emails/day ~50 emails/hour
Google Workspace 2,000 emails/day ~200 emails/hour

What happens if you exceed limits:
– Gmail temporarily blocks sending
– You’ll see error: “Service invoked too many times for one day”
– Limit resets after 24 hours

How to avoid:
– Spread campaigns over multiple days
– Start small (10-20/day) and ramp up gradually
– Upgrade to Google Workspace for higher limits


Trigger Schedule

All automation triggers run every 15 minutes:

Trigger Function What It Does
Execute Scheduled Activities Checks for emails due to send, sends them
Check for Bounces Scans Gmail for bounce notifications, updates status
Check for Replies Detects prospect replies, auto-pauses campaigns

Important:
– Changes take up to 15 minutes to process
– Emails scheduled for 9:00 AM might send between 9:00-9:15 AM
– You don’t need to keep the spreadsheet open — triggers run automatically


Common Formulas

Pull Prospect Data into Executions

In Plan Executions sheet, to auto-fill prospect email from Prospects sheet:

=VLOOKUP(A2, Prospects!A:E, 5, FALSE)

Where:
– A2 = Prospect ID in current row
– Prospects!A:E = Range in Prospects sheet
– 5 = Column number (Email is 5th column)
– FALSE = Exact match

Count Active Executions

=COUNTIF('Plan Executions'!G:G, "Active")

Where G:G is the Status column.

Count Emails Sent Today

=COUNTIFS('Activity Log'!G:G, "Sent", 'Activity Log'!G:G, ">="&TODAY())

Where G:G is Executed Date column.

Calculate Reply Rate

=(COUNTIF('Activity Log'!M:M, TRUE) / COUNTIF('Activity Log'!H:H, "Sent")) * 100

Where:
– M:M = Reply Detected column
– H:H = Status column


Keyboard Shortcuts

Google Sheets General:
| Shortcut | Action |
|———-|——–|
| Ctrl + F (Win) / Cmd + F (Mac) | Find in sheet |
| Ctrl + H (Win) / Cmd + Shift + H (Mac) | Find and replace |
| Ctrl + / (Win) / Cmd + / (Mac) | Show keyboard shortcuts |
| Alt + Shift + F | Open filter menu |
| Ctrl + Alt + = | Insert row above |
| Ctrl + Alt + - | Delete row |

FollowUp Pilot Specific:
– No custom keyboard shortcuts (use menu instead)


Quick Troubleshooting

Problem Quick Fix
Emails not sending Check: Triggers installed? Agent Email set? Status = Active?
Merge fields not working Check spelling (case-sensitive), check Prospect data filled in
System won’t initialize Try: Close and reopen sheet, clear cache, use Chrome browser
Triggers stopped working Delete and reinstall: Action Plan Manager → Setup Triggers
Hit free plan limit Upgrade to Pro or wait until next month (email limit resets monthly)
Emails going to spam Remove spam words, personalize subject, authenticate domain

Support Resources

Resource Link / Path
Full User Guide Index 00-INDEX.md
Getting Started Guide 01-GETTING-STARTED.md
Troubleshooting & FAQ 08-TROUBLESHOOTING-FAQ.md
Email Support support@hunterfisherllc.com
Support Portal https://software.hunterfisherllc.com/apps/followup-pilot/support/
Privacy Policy https://software.hunterfisherllc.com/privacy-policy/
Terms of Service https://software.hunterfisherllc.com/terms-of-service/

Tips & Best Practices

✅ DO:
– Test campaigns on yourself before sending to prospects
– Start with small batches (10-20 prospects)
– Respond to replies immediately
– Remove hard bounces from your list
– Keep emails under 150 words
– Use merge fields for personalization
– Monitor Activity Log daily

❌ DON’T:
– Send all 500 prospects in one day (hit Gmail limits)
– Use ALL CAPS or spam trigger words
– Ignore bounce notifications
– Buy email lists (low quality, high bounce rate)
– Send without testing merge fields first
– Keep emailing unsubscribers (illegal)


Bookmark this page for quick reference! 📚

← Back to Troubleshooting | Back to Index →