Send the right email at the right time with a simple sheet driven system. Teams keep contacts and messages in Google Sheets, and emails go out from Gmail on the date you set. It fits small marketing teams and customer facing roles that plan follow ups in a spreadsheet.

A schedule runs every minute and pulls rows from a Google Sheet. A filter lets through only records with Status set to Waiting for sending and a date that matches today in year month day format. Gmail then sends each message using the sheet fields, with Title as the email subject and Subject as the email body. Results are merged back with the row data, needed fields are prepared, and the sheet is updated to mark Status as Sent successfully using the row ID. This creates a light email queue without manual copy and paste.

You need access to Gmail and Google Sheets in the same Google account and a sheet with columns for ID Email Name Title Subject Date and Status. Expect faster send times, fewer missed follow ups, and a clear audit trail in the sheet. Common uses include campaign drips, event reminders, onboarding check ins, and payment nudges scheduled for the exact day.

• Schedule trigger checks the sheet every minute for items to send.
• Google Sheets read pulls contact and message data from a selected sheet and tab.
• Filter passes only rows with Status Waiting for sending and a date equal to today in yyyy/mm/dd.
• Gmail sends emails using Title for the subject and Subject for the body, to the Email field.
• Merge aligns send results with the original rows to keep context for updates.
• Set node extracts email name and ID to prepare the update payload.
• Google Sheets update marks rows as Sent successfully using the ID column.
• Loose type validation in the filter helps handle common data format issues.

• Reduce manual email sending from 2 hours to 5 minutes per day
• Automate 90 percent of repetitive outreach steps
• Improve data accuracy by 80 percent with automatic status updates
• Connect Gmail and Google Sheets in one flow
• Handle up to 10 times more messages by running every minute
• Keep a clear audit trail by writing results back to the sheet

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets and Gmail. See the Tools Required section above for links to create accounts with these services.
3. Prepare your Google Sheet with columns for ID, Email, Name, Title, Subject, Date, and Status. Use the date format year/month/day, for example 2025/08/26.
4. In the n8n canvas, double click the Google Sheets nodes. In the Credential to connect with dropdown, click Create new credential, then follow the on screen instructions to connect your Google Sheets account.
5. Open the Retrieve Customer Messages Data node. Select the correct Spreadsheet and Sheet. Confirm it points to the tab that holds your outreach data.
6. Double click the Gmail node. In the Credential to connect with dropdown, click Create new credential, then follow the on screen steps to authorize your Gmail account.
7. In the Gmail node, verify field mappings: To uses the Email column, Subject uses the Title column, and Message uses the Subject column from your sheet data.
8. Open the Filter Status node and confirm the condition checks Status equals Waiting for sending and that the date condition matches today. Keep case sensitivity consistent with your sheet values.
9. Open the Update Message Status node. Set the operation to Update and map ID to the ID column. Set Status to Sent successfully so updates are written back to the same row.
10. Share the Google Sheet with the same Google account connected in n8n if it is owned by a different user, so n8n has read and write access.
11. Test the flow: Add a sample row with today’s date and Status Waiting for sending, then click Execute on the Schedule Trigger or wait one minute. Check Gmail for the sent email and confirm the sheet row now shows Sent successfully.
12. Troubleshoot common issues: If no emails send, check the date format and time zone. If updates fail, make sure the ID exists and is unique. If Gmail blocks sending, review account access and sending limits.