{"product_id":"n8n-weekly-google-sheets-shift-reminders-via-gmail","title":"n8n Weekly Google Sheets Shift Reminders via Gmail","description":"\u003ch3\u003eAutomate Monday morning security shift reminders from Google Sheets to Gmail—automatically\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n Weekly Google Sheets Shift Reminders via Gmail\u003c\/strong\u003e workflow reads your shift schedule every Monday morning and sends personalized \u003cstrong\u003eHTML reminder emails\u003c\/strong\u003e to each security agent for all \u003cstrong\u003econfirmed\u003c\/strong\u003e shifts that haven’t been notified yet. After emailing, it updates your Google Sheets to mark those shifts as \u003cstrong\u003eNotified\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 weekly:\u003c\/strong\u003e scheduled to execute every Monday at \u003cstrong\u003e07:00\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your shift schedule:\u003c\/strong\u003e pulls all rows from your configured \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters eligible shifts:\u003c\/strong\u003e keeps only rows where \u003cstrong\u003eStatus\u003c\/strong\u003e is \u003cstrong\u003e\"Confirmed\"\u003c\/strong\u003e and the \u003cstrong\u003eNotified\u003c\/strong\u003e field is empty.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends agent-specific email reminders:\u003c\/strong\u003e for each matching agent, sends an \u003cstrong\u003eHTML shift reminder\u003c\/strong\u003e via \u003cstrong\u003eGmail\u003c\/strong\u003e, using the row’s \u003cstrong\u003edate\u003c\/strong\u003e, \u003cstrong\u003estart\/end times\u003c\/strong\u003e, and \u003cstrong\u003esite\u003c\/strong\u003e details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicate notifications:\u003c\/strong\u003e updates the corresponding Google Sheets row by setting \u003cstrong\u003eStatus\u003c\/strong\u003e to \u003cstrong\u003e\"Notified\"\u003c\/strong\u003e and writing today’s date to the \u003cstrong\u003eNotified\u003c\/strong\u003e column.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSecurity teams who maintain availability in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and need reliable Monday reminders to agents.\u003c\/li\u003e\n  \u003cli\u003eOperations managers using \u003cstrong\u003en8n automation\u003c\/strong\u003e to reduce manual emailing and ensure confirmed assignments are communicated.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators or automation engineers standardizing reminder workflows for shift-based schedules.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule Trigger:\u003c\/strong\u003e runs every Monday at 07:00.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets node:\u003c\/strong\u003e reads all shift rows and updates notified rows.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilter logic:\u003c\/strong\u003e selects shifts with \u003cem\u003eStatus = \"Confirmed\"\u003c\/em\u003e and an empty \u003cem\u003eNotified\u003c\/em\u003e field.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail node:\u003c\/strong\u003e sends \u003cstrong\u003eHTML\u003c\/strong\u003e emails to each agent’s email address.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirements:\u003c\/strong\u003e configure Google Sheets OAuth2 and Gmail OAuth2 credentials, set the workflow’s \u003cstrong\u003esheetUrl\u003c\/strong\u003e, and ensure your sheet includes columns for \u003cstrong\u003eAgent_Name, Email, Shift_Date, Shift_Start, Shift_End, Site, Status, Notified\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45761012990131,"sku":"N8N-17811","price":75.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/hxh1YYTNlKwD2hn4CUJbf_nUUeepFf.png?v=1785921426","url":"https:\/\/buyflowscripts.com\/products\/n8n-weekly-google-sheets-shift-reminders-via-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}