This guide will help you set up AI Mail to send personalized emails to your contact list.
- A Gmail account
- A Google Sheet with your contacts
- An API key for AI (Gemini or OpenAI)
AI Mail uses Gmail App Passwords for secure email sending. To use app passwords, you need 2-Factor Authentication (2FA) enabled.
- Go to Google Account Security
- Under "How you sign in to Google", click 2-Step Verification
- Click Get Started
- Follow the on-screen instructions to set up 2FA
- You'll need your phone to receive verification codes
- Can use SMS, Google Authenticator, or other methods
Once 2FA is enabled, you can create an app password.
-
Go to Google App Passwords
- Or: Google Account → Security → 2-Step Verification → App Passwords
-
You may need to sign in again
-
Under "Select app", choose Mail
-
Under "Select device", choose Windows Computer (or Other)
-
Click Generate
-
Google will display a 16-character password like:
abcd efgh ijkl mnop -
Copy this password - you'll need it in Step 5
Note: You can't view this password again, but you can always generate a new one.
Your contact list must be in a Google Sheet with specific columns.
| Column A | Column B | Column C | Column D |
|---|---|---|---|
| Email Address | First Name | Last Name | Team Member |
Example:
| Email Address | First Name | Last Name | Team Member |
|---|---|---|---|
| john@example.com | John | Doe | |
| jane@example.com | Jane | Smith |
- Open your Google Sheet
- Click the Share button (top right)
- Click Change to anyone with the link
- Set permission to Viewer
- Click Copy link
- Save this link - you'll need it in Step 5
Why Viewer? The app only needs to read contacts. You'll manually update the "Team Member" column after sending emails.
The app uses AI to generate personalized emails. Choose one:
- Go to Google AI Studio
- Click Create API Key
- Select a project (or create new)
- Click Create API key in existing project
- Copy the API key - you'll need it in Step 5
Cost: Free tier includes generous quota
- Go to OpenAI Platform
- Sign up or sign in
- Click Create new secret key
- Name it "AI Mail"
- Copy the API key - you'll need it in Step 5
Cost: Pay-as-you-go, approximately $0.01-0.05 per email
Now you're ready to set up the application!
-
Open AI Mail application
-
Go to Configuration Tab (should open automatically)
-
Enter User Information:
- Full Name: Your name (will appear in emails)
- Gmail Address: Your Gmail address
- Gmail App Password: Paste the 16-character password from Step 2
- Click Test Gmail Connection to verify
-
Enter Google Sheets Information:
- Sheet URL: Paste the share link from Step 3
- Click Test Sheet Connection to verify
-
Enter LLM Configuration:
- Provider: Choose Gemini or OpenAI
- API Key: Paste the key from Step 4
- Model: Leave default (optional)
-
Configure Email Settings:
- Subject Line Template: e.g., "Hello {{firstName}}"
- Use
{{firstName}}and{{lastName}}to personalize
- Use
- Email Signature: Your closing (e.g., "Best regards,\nJohn")
- Subject Line Template: e.g., "Hello {{firstName}}"
-
Click Save Configuration
-
Go to Context Template Tab
-
Click "Open File" to create or load a template
-
Write your email template:
Hi {{firstName}}, I hope this email finds you well. I wanted to reach out because... [Your message here] Looking forward to hearing from you! -
Use
{{firstName}}and{{lastName}}to personalize -
Template auto-saves every 2 seconds
-
Go to Send Emails Tab
-
You'll see the first unsent contact from your sheet
-
Click "Generate Email"
- AI creates a personalized email based on your template
- Variables are replaced with contact's name
-
Review the email:
- Edit subject and body as needed
- Check for accuracy
-
Click "Send Test to Self" (recommended first time)
- Sends to your email so you can preview
- Doesn't update the sheet
-
Click "Send Email" when ready
- Confirms before sending
- Sends via Gmail
- Shows success/error status
-
After sending:
- Manually update "Team Member" column in Google Sheet with your name
- Click "Next" to move to next contact
- Repeat steps 3-7
- ✅ Always send a test to yourself first
- ✅ Review each email before sending
- ✅ Take breaks - don't rush
- ✅ Keep track in your Google Sheet
⚠️ Gmail has daily sending limits (typically 100-500/day)
- Keep it personal and conversational
- Be clear about why you're reaching out
- Include a call-to-action
- Test different approaches
- Contact data is NOT sent to AI (privacy protected)
- Only the template goes to AI, names filled in locally
- Include unsubscribe option in emails
- Follow CAN-SPAM Act guidelines
- Respect recipients who ask to be removed
- ✓ Check your Gmail address is correct
- ✓ Verify app password (16 characters, no spaces)
- ✓ Make sure 2FA is enabled
- ✓ Generate a new app password if needed
- ✓ Check sheet URL is correct
- ✓ Verify sheet is shared with "Anyone with link"
- ✓ Make sure permission is at least "Viewer"
- ✓ Try opening the link in a private browser window
- ✓ Check "Team Member" column is empty for unsent contacts
- ✓ Verify column headers match exactly (A: Email Address, B: First Name, C: Last Name, D: Team Member)
- ✓ Make sure there's data below the header row
- ✓ Check API key is correct
- ✓ Verify you have credits/quota with provider
- ✓ Check internet connection
- ✓ Try the other provider (Gemini vs OpenAI)
If you continue having issues:
- Check the error message carefully
- Verify each setup step above
- Try restarting the application
- Check your internet connection
- Gmail 2FA: https://myaccount.google.com/security
- App Passwords: https://myaccount.google.com/apppasswords
- Google Gemini API: https://makersuite.google.com/app/apikey
- OpenAI API: https://platform.openai.com/api-keys
- Share Google Sheet: Click Share button in your sheet
Ready to start? Follow Step 1 above and you'll be sending personalized emails in no time!