Weekly Google Calendar Schedule Preview via Email - n8n Workflow

Busy professionals who need a reliable weekly overview of their schedule.
Anyone utilizing n8n templates for personal productivity and scheduling.
Users looking to leverage the n8n node ecosystem for Google Calendar and Gmail automation.
Technical users wanting a practical example of the Function n8n node for data transformation.

Managing a complex schedule often involves manually reviewing the calendar at the start of the week. This n8n workflow eliminates that tedious task by proactively sending you a comprehensive weekly schedule summary every Sunday evening.

This robust automation uses a simple Cron n8n trigger to initiate the process, calculates the exact dates for the upcoming Monday-Sunday period, fetches all relevant Google Calendar events, formats them into a clean, human-readable summary (even handling cases where you have no meetings), and dispatches the final summary using a Gmail n8n node. It's a prime example of effective personal n8n automation, saving time and ensuring better preparedness for the week ahead. Importing this pre-built n8n templates solution gets your weekly summary running quickly.

This automation operates in a linear sequence, triggered by time:

1. Initiation: The n8n workflow is started by the Cron n8n trigger, set to execute automatically every Sunday at 7:00 PM (19:00).


2. Date Calculation: A Function n8n node runs custom JavaScript, utilizing Luxon's DateTime capabilities, to determine the exact ISO start time (Monday 00:00:00) and end time (Sunday 23:59:59) for the next seven days.


3. Data Extraction: The Google Calendar n8n node uses the calculated date range (startDate and endDate) to retrieve all scheduled events from the primary calendar.


4. Formatting and Transformation: A second Function n8n node processes the potentially numerous calendar items. It groups events by day, sorts them chronologically, extracts key details (time, title, location), and compiles them into a single, structured Markdown-formatted text variable, ready for email.


5. Final Delivery: The Gmail n8n node receives the formatted summary content, constructs the email using a dynamic subject line that includes the date range, and sends the personalized weekly schedule email to the specified recipient. This completes the weekly execution of the n8n workflow.

To deploy this automation using these powerful n8n templates:

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


2. Credentials - Google Calendar: Locate the 'Get Calendar Events' n8n node. You must set up a Google Calendar OAuth2 API credential. Follow the n8n instructions to connect your Google account, ensuring the Google Calendar API is enabled in your Google Cloud Project.


3. Credentials - Gmail: Locate the 'Send Summary Email' n8n node. Set up a Gmail API credential, connecting the Gmail account you wish to send from.


4. Configuration: In the 'Send Summary Email' n8n node, modify the To Email parameter from YOURRECIPIENT[email protected] to your actual email address, and update From Email to your authenticated Gmail address.


5. Activation: Save the n8n workflow and activate it by toggling the 'Active' switch on the top right. Test the flow by executing it manually starting from the 'Sunday Evening Trigger' n8n node.

Sunday Evening Trigger (Cron n8n node): This acts as the essential n8n trigger. It is configured to run on a fixed schedule: Every Sunday at 19:00 (7:00 PM) server time, initiating the entire n8n workflow.
Calculate Week Dates (Function n8n node): Uses JavaScript to dynamically calculate the startDate (next Monday) and endDate (next Sunday) required for the calendar query, ensuring the correct week is targeted regardless of when the workflow runs.
Get Calendar Events (Google Calendar n8n node): Fetches up to 20 single events from the 'primary' calendar. It uses expressions (={{ $json.startDate }}) to dynamically pull the time boundary parameters calculated in the preceding n8n node.
Format Meeting Summary (Function n8n node): The core data transformation component. This n8n node processes the array of events, grouping them by day, handling all-day events, and formatting the output into a clean, organized string variable (summaryEmailContent) using basic Markdown styling.

• Send Summary Email (Gmail n8n node): The final action node. It sends the email using the summaryEmailContent generated previously. Key configuration involves setting the recipient and sender emails and defining the dynamic subject line using the DateTime library.