Bulk Email Sender and Tracker using Gmail, Google Sheets and Slack Notification

Automated Email Sender & Tracker with Google Sheets

Summary

This workflow automates your email sending process using a Google Sheet as a command center. It sends emails via Gmail using the exact subject and body you define for each contact in the spreadsheet. Afterward, it automatically updates the sheet to track who has been contacted and when, preventing duplicate sends.

What It Does

• Runs on a Schedule: Automatically triggers at an interval you define (e.g., every 4 hours).
• Fetches Queued Emails: Reads your Google Sheet, looking for any row where the Email Sent column is marked as "No".
• Sends User-Defined Emails: For each of those contacts, it sends an email using the specific text from the Email Subject and Email Body columns in their row.
• Tracks Everything: After sending, it updates the row by changing Email Sent to "Yes", logging the send time, and adding the unique Gmail Message ID for your records.
• Sends Safely: A short, built-in pause between each email protects your account's reputation and ensures reliable delivery.
• Confirms Completion: Notifies you on Slack once the entire batch of emails has been sent.

Use Cases

• Customized Outreach: Send unique follow-up emails to a list of leads, each with different content.
• Targeted Campaigns: Run email campaigns where you can manually set a different message or offer for each recipient.
• Sequential Replies: Manage sending pre-written, individual responses to a large number of inquiries.
• Systematic Internal Communications: Distribute specific updates or information to different team members from one master list.

Who is it For?

• Marketing & Sales Teams who need full control over the content of each email in a campaign.
• Solopreneurs & Small Business Owners wanting to automate sending non-identical emails.
• Support & Operations Staff who need to send templated but distinct replies to a list of users.

How to Set It Up

1. Prepare Your Sheet: Make a copy of the new Google Sheet Template. Add your contacts. For each person, write the exact subject and body of the email you want to send in the Email Subject and Email Body columns. Put No in the Email Sent column to queue it for sending.
2. Connect Credentials: Link your Google account in the Google Sheets and Gmail nodes. Then, connect your Slack account in the Slack node for notifications.
3. Link Your Sheet: In both Google Sheets nodes ("Google Sheets8" and "Google Sheets9"), select the spreadsheet file and sheet name you prepared in the first step.
4. Activate: Customize the schedule in the "Schedule Trigger" node, then toggle the workflow to "Active" in the top-right corner.