Automated marketing tools for macOS that send personalized messages through iMessage and email using AppleScript integration with Numbers spreadsheets.
- iMessage Automation: Send bulk personalized iMessages
- Email Automation: Automated email campaigns via Apple Mail
- Spreadsheet Integration: Read contacts and templates from Numbers
- Personalization: Dynamic message customization with recipient names
- Batch Processing: Handle multiple contacts efficiently
- Safety Mode: Messages typed but not auto-sent for review
- macOS 10.14+
- Numbers app
- Messages app (for iMessage script)
- Apple Mail (for email script)
- Configured iMessage/email accounts
Go to System Preferences → Security & Privacy → Privacy:
Accessibility:
- Add and enable Script Editor
Automation:
- Allow Script Editor to control Numbers, Messages, Mail, and System Events
Full Disk Access (if using iCloud files):
- Add Script Editor
Files and Folders:
- Grant access to your spreadsheet location (Desktop, Documents, or iCloud Drive)
Create a Numbers file with two tables:
Addresses Table:
| Column A | Column B |
|---|---|
| Phone/Email | Name |
| +1234567890 | John Smith |
| user@email.com | Jane Doe |
Content Table:
| Cell | Content |
|---|---|
| A2 | Subject line or message template |
| B2 | Email body content (email script only) |
- Download the script you need
- Open in Script Editor
- Update the file path:
set numbersFilePath to "/path/to/your/spreadsheet.numbers"
- Customize the message template in the script
Performance: The iMessage script processes approximately 100 contacts in 5-10 minutes due to built-in delays that prevent system overload and ensure message delivery reliability.
Message Types: This script can send to both SMS and iMessage recipients, provided your Apple ID and phone number are properly configured in Messages app settings. The system will automatically choose the appropriate delivery method based on the recipient's capabilities.
-- Reads from Addresses table (phone numbers) and Content table
-- Sends personalized iMessages through Messages app
-- Messages are typed but not automatically sent-- Reads from Addresses table (email addresses) and Content table
-- Sends emails through Apple Mail
-- Supports immediate sending or draft creationset personalizedContent to "Dear " & contactName & ", " & theContentset personalizedContent to "<html><body><p>Hello " & recipientName & "</p></body></html>"delay 2 -- Increase delay between messages-- Replace 'send' with 'save' to create drafts instead
save├── imessage-automation.applescript # iMessage marketing script
├── email-automation.applescript # Email marketing script
└── README.md # This file
- Data Reading: Scripts parse your Numbers spreadsheet for contacts and message templates
- Message Creation: Personalizes content with recipient names
- Automation: Uses System Events to control Messages/Mail apps
- Safety: iMessage script types messages for manual review; email script can auto-send or save drafts
Permission denied errors:
- Check System Preferences privacy settings
- Restart applications after granting permissions
Can't access iCloud files:
- Enable Full Disk Access for Script Editor
- Verify iCloud Drive sync status
Messages not sending:
- Verify app configurations (Messages/Mail)
- Check internet connectivity
- Ensure valid phone numbers/email formats
- Fork the repository
- Create a feature branch (
git checkout -b feature-name) - Commit changes (
git commit -am 'Add feature') - Push to branch (
git push origin feature-name) - Create a Pull Request
MIT License - see LICENSE file for details
Use responsibly and ensure you have permission to contact recipients. Users are responsible for compliance with applicable messaging laws and regulations.