Daily Task Reminder Automation from Google Sheets - n8n Workflow

Project Managers needing automated reminders for their team's daily tasks.
Content Creators tracking publication deadlines in a shared Google Sheet.
Users seeking a reliable, low-code n8n workflow to manage time-sensitive operational data.
Anyone looking for practical n8n templates leveraging scheduled events and data filtering.

Managing daily deadlines and ensuring timely task execution can be difficult when relying solely on static spreadsheets. This powerful n8n workflow eliminates manual tracking by automatically checking a designated Google Sheet every day for tasks marked due today.

This robust n8n template provides immense value by acting as a proactive assistant. It uses a scheduled n8n trigger to initiate the process, pulls the data using the Google Sheets n8n node, and uses flow control to intelligently route only the necessary information. Finally, it uses an SMTP n8n node to dispatch personalized reminder emails. After sending, the n8n workflow ensures data integrity by updating the sheet, confirming the reminder has been sent, preventing duplicates.

This efficient n8n workflow operates in six sequential steps:

1. Scheduled n8n Trigger: The process begins with the Daily Reminder Trigger (a Cron n8n node), set to execute at a specific time daily.


2. Data Retrieval: The next n8n node, Read Content Calendar (Google Sheets), securely fetches all rows from the specified spreadsheet.


3. Filtering: The Filter Today's Tasks n8n node processes the incoming data, checking a designated date column to isolate only the items scheduled for the current day. This is the core logic of the n8n workflow.


4. Email Dispatch: For every filtered task, the Send Reminder Email n8n node uses the configured SMTP credentials to construct and dispatch a personalized reminder notification.


5. Data Preparation: A Code n8n node runs custom logic. This node prepares the unique row identifier and the status update payload required for the subsequent sheet update step.


6. Status Update: The final n8n node, Update row in sheet (Google Sheets), uses the data processed in the previous step to mark the corresponding row in the original spreadsheet as 'Reminder Sent,' completing the execution of this particular n8n workflow run.

To install and utilize this n8n template, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON code and import it directly into your n8n instance via the 'Workflows' section using the 'New' -> 'Import from JSON' option.


2. Credential Setup: You must configure two primary credentials for this n8n workflow to function:

1. Node Configuration: Adjust the following n8n nodes:

1. Activation: Once configurations are complete, activate the n8n workflow to start receiving daily reminders.

Daily Reminder Trigger (Cron n8n node):
Function: Serves as the primary n8n trigger, initiating the entire n8n workflow on a fixed schedule (daily).
Key Configuration: Schedule setting (e.g., Run every day at 8:00 AM).
Read Content Calendar (Google Sheets n8n node):
Function: Connects to Google Drive to fetch the task list data.
Key Configuration: Operation set to 'Read', specifying the target spreadsheet ID and sheet name.
Filter Today's Tasks (Filter n8n node):
Function: Filters the array of tasks retrieved from Google Sheets, allowing only those where the due date matches the current day's date to proceed down the n8n workflow path.
Key Configuration: Condition set to check the date column against a calculated current date variable.
Send Reminder Email (Email Send n8n node):
Function: Sends the reminder notification using configured SMTP credentials for each item passed by the Filter n8n node.
Key Configuration: Specifies recipient email, subject, and dynamic body text referencing the task details.
Code (Code n8n node):
Function: Custom scripting used to manipulate the data payload, specifically preparing the 'Row Index' and the new 'Status' required for the update step.
Update row in sheet (Google Sheets n8n node):
Function: Marks the task in the spreadsheet as completed or 'Reminder Sent' to ensure logging and prevent repeated reminders on subsequent runs of the n8n workflow.
* Key Configuration: Operation set to 'Update', using the row index passed from the Code n8n node.