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! 📚