{"product_id":"schedule-gmail-emails-from-google-sheets-auto-update-status","title":"Schedule Gmail Emails from Google Sheets \u0026 Auto-Update Status","description":"\u003ch3\u003eAutomatically send Gmail messages from your Google Sheets—then auto-update the status\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow checks your Google Sheets every minute, finds rows scheduled for \u003cstrong\u003etoday\u003c\/strong\u003e that are marked \u003cem\u003e“Waiting for sending”\u003c\/em\u003e, sends the email through \u003cstrong\u003eGmail\u003c\/strong\u003e, and then updates each matching row to \u003cstrong\u003e“Sent successfully”\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule (every minute)\u003c\/strong\u003e using an n8n schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads rows from Google Sheets\u003c\/strong\u003e using your specified spreadsheet and sheet tab(s).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters for eligible recipients\u003c\/strong\u003e where:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eStatus\u003c\/strong\u003e equals \u003cem\u003e“Waiting for sending”\u003c\/em\u003e\n\u003c\/li\u003e\n      \u003cli\u003eRequired fields exist: \u003cstrong\u003eTitle, Subject, Email, Name, Date\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eDate matches today\u003c\/strong\u003e (use \u003cstrong\u003eyyyy\/MM\/dd\u003c\/strong\u003e formatting)\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a plain-text Gmail email\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eRecipient: the sheet’s \u003cstrong\u003eEmail\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003eSubject: the sheet’s \u003cstrong\u003eTitle\u003c\/strong\u003e\n\u003c\/li\u003e\n      \u003cli\u003eBody: the sheet’s \u003cstrong\u003eSubject\u003c\/strong\u003e\n\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates the original Google Sheets record\u003c\/strong\u003e (matched by \u003cstrong\u003eID\u003c\/strong\u003e) to set \u003cstrong\u003eStatus\u003c\/strong\u003e to \u003cem\u003e“Sent successfully”\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSend daily outreach or notifications to a list maintained in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eAutomate scheduled follow-ups without manually copying contacts into an email tool.\u003c\/li\u003e\n  \u003cli\u003eSaaS operations teams can track message delivery state directly in the spreadsheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ tech stack:\u003c\/strong\u003e \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003egmail\u003c\/em\u003e, \u003cem\u003emerge\u003c\/em\u003e, \u003cem\u003efilter\u003c\/em\u003e, \u003cem\u003esticky note\u003c\/em\u003e, \u003cem\u003egoogle sheets\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets (read + update) and Gmail (send email)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired columns:\u003c\/strong\u003e \u003cstrong\u003eID, Email, Title, Subject, Name, Date, Status\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup checklist\u003c\/h3\u003e\n\u003cp\u003eConnect your Google Sheets credentials (for both read and update steps), connect a Gmail account permitted to send emails, then ensure your rows use \u003cstrong\u003eStatus = “Waiting for sending”\u003c\/strong\u003e and \u003cstrong\u003eDate = yyyy\/MM\/dd\u003c\/strong\u003e for messages you want sent today.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45785612091571,"sku":"N8N-17925","price":13.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/RIwqE5FphrW0VGYmFO0ZX_LvEmGZqf.png?v=1786179868","url":"https:\/\/buyflowscripts.com\/products\/schedule-gmail-emails-from-google-sheets-auto-update-status","provider":"N8N Commerce","version":"1.0","type":"link"}