Schedule Gmail Emails from Google Sheets & Auto-Update Status

Automatically send Gmail messages from your Google Sheets—then auto-update the status

This n8n workflow checks your Google Sheets every minute, finds rows scheduled for today that are marked “Waiting for sending”, sends the email through Gmail, and then updates each matching row to “Sent successfully”.

What this workflow does

• Runs on a schedule (every minute) using an n8n schedule trigger.
• Reads rows from Google Sheets using your specified spreadsheet and sheet tab(s).
• Filters for eligible recipients where:
  • Status equals “Waiting for sending”
  • Required fields exist: Title, Subject, Email, Name, Date
  • Date matches today (use yyyy/MM/dd formatting)
• Sends a plain-text Gmail email:
  • Recipient: the sheet’s Email
  • Subject: the sheet’s Title
  • Body: the sheet’s Subject
• Updates the original Google Sheets record (matched by ID) to set Status to “Sent successfully”.

Use cases

• Send daily outreach or notifications to a list maintained in Google Sheets.
• Automate scheduled follow-ups without manually copying contacts into an email tool.
• SaaS operations teams can track message delivery state directly in the spreadsheet.

Technical details

• Nodes / tech stack: set, gmail, merge, filter, sticky note, google sheets
• Integrations: Google Sheets (read + update) and Gmail (send email)
• Required columns: ID, Email, Title, Subject, Name, Date, Status

Setup checklist

Connect your Google Sheets credentials (for both read and update steps), connect a Gmail account permitted to send emails, then ensure your rows use Status = “Waiting for sending” and Date = yyyy/MM/dd for messages you want sent today.