🚀 Overview:
The Bulk LOI Sender Google Sheets™ add-on turns your spreadsheet into a reliable LOI mail-merge system. 

Generate professional and personalized letters of intent from a Google Docs™ template, attach each as a unique PDF, and send them via Gmail™, all in safe, quota-aware batches. Save yourself hours of work and stop copying, pasting, and attaching one-by-one; create, preview, and send at scale in minutes. 

Convert your leads with ease and make professional LOI outreach a repeatable, 5-minute task instead of an all-day chore!

👨‍💻 Who It's For:
Perfect for sales, partnerships, real estate, M&A, recruiting—anyone who needs to send many professional LOIs or emails with unique PDF attachments fast without leaving Sheets™.

🧪 Key Features: 
    ✔️Save hours of manual work (Template → Personalized LOIs → Email in one flow)
    ✔️Auto-PDF from Google Docs™ or send as plain text
    ✔️Safe batching & credit awareness (respects Gmail™ daily limits)
    ✔️Test sends to your inbox before going live
    ✔️Queue management: pause, resume, retry, clear sent
    ✔️Up to 26 merge fields: map columns to placeholders
    ✔️Status tracking (queued/processing/sent/failed) right from Sheets™
    ✔️Attachment controls: include PDF or use Docs™ body as email text

⭐ How It Works:
1. Import or paste your leads (or upload CSV) into Sheets™
2. Select a Google Docs™ LOI template with merge placeholders (e.g., {{Company}})
3. Create jobs & send: review test emails, then batch-send with quota-aware controls

📊 Limits & performance
- Typical send caps: ~100/day for consumer Gmail™; up to 1,500/day for premium Google Workspace™ accounts.
- The add-on batches and paces your sends to avoid timeouts and quota errors.

🔒 Privacy & Permissions:
- Creates and stores LOIs in your own Drive™. You control your data.
- Requests minimal scopes needed for Sheets™, Docs™, Drive™ (file-level) and Gmail™ sending.

🏷️ Pricing:
Use is free with a reasonable daily send limit. Premium subscription unlocks higher limits and advanced features (e.g., unlimited LOIs per sheet). No credit card required to try.

📘 Change log:
10/31/2025: Improve overall UIUX, improve job creation speed
10/29/2025: Improve loading UIUX, add placeholder detection for email body
10/22/2025: Fix Gmail line wrap bug
10/14/2025: Improve file management
10/13/2025: Fix payment link
10/1/2025: Initial publish