{"product_id":"n8n-weekly-timesheet-reminder-gmail-google-sheets","title":"n8n Weekly Timesheet Reminder: Gmail + Google Sheets","description":"\u003ch3\u003eAutomate weekly timesheet reminders—automatically email Active agents and log it in Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThe \u003cstrong\u003en8n Weekly Timesheet Reminder: Gmail + Google Sheets\u003c\/strong\u003e workflow runs every Friday at 16:00 to read your agent roster from Google Sheets, email each \u003cem\u003eActive\u003c\/em\u003e agent a personalized HTML reminder via Gmail, and then write the reminder date back to the sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules the automation\u003c\/strong\u003e with a \u003cem\u003eschedule trigger\u003c\/em\u003e to run every Friday at 16:00.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your roster\u003c\/strong\u003e from Google Sheets using the configured spreadsheet URL.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrepares for accurate updates\u003c\/strong\u003e by adding a row number to each record so the correct sheet row can be updated later.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters agents\u003c\/strong\u003e to only those where \u003cstrong\u003eStatus equals \"Active\"\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends reminders by email\u003c\/strong\u003e using Gmail: each active agent receives a personalized HTML timesheet reminder addressed to them and referencing the \u003cstrong\u003emanager email\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs activity\u003c\/strong\u003e in Google Sheets by updating today’s date in the \u003cstrong\u003eLast_Reminded\u003c\/strong\u003e column for each emailed agent.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eOperational teams who need a reliable \u003cstrong\u003eweekly timesheet collection\u003c\/strong\u003e process without manual follow-ups.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators managing distributed agents and wanting an audit trail of when reminders were sent.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers standardizing HR\/ops reminders using \u003cstrong\u003en8n automation workflows\u003c\/strong\u003e with Gmail and Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes \/ integrations:\u003c\/strong\u003e schedule trigger, Google Sheets, filter, set, Gmail, sticky note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired Google Sheets columns:\u003c\/strong\u003e \u003cem\u003eAgent_Name\u003c\/em\u003e, \u003cem\u003eEmail\u003c\/em\u003e, \u003cem\u003eStatus\u003c\/em\u003e, \u003cem\u003eLast_Reminded\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup:\u003c\/strong\u003e connect Google Sheets OAuth2 credentials for roster access, connect Gmail OAuth2 for the sending mailbox, then configure the spreadsheet URL and manager email address.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBehavior:\u003c\/strong\u003e only agents with \u003cstrong\u003eStatus = \"Active\"\u003c\/strong\u003e receive the reminder email, and only those rows are updated with the send date.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45761012367539,"sku":"N8N-17815","price":31.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/DDPCb8vPc6yHQWGDbEo5R_AoZIwM84.png?v=1785921329","url":"https:\/\/buyflowscripts.com\/products\/n8n-weekly-timesheet-reminder-gmail-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}