Automatic Event Scheduling from Google Sheets to Google Calendar - n8n Workflow

• Event organizers and planners who manage schedules in spreadsheets.


• Administrative assistants needing to automate routine calendar updates.


• Users looking for effective n8n templates to bridge cloud applications.


• Technical users requiring an n8n workflow that handles data transformation (like date formatting) on the fly.

Manual data entry between spreadsheets and calendars is tedious and prone to error. This robust n8n workflow solves this by providing a hands-off automation solution. By using the Google Sheets n8n trigger, the system constantly monitors a designated sheet for new event entries. The core value of this n8n workflow lies in its ability to automatically retrieve the latest data, use a custom n8n node for crucial date formatting, and then seamlessly push the structured information to Google Calendar.

This specific n8n workflow template ensures that all events are created correctly with essential details—summary, description, location, and date—while also pre-setting the calendar event as 'Available' and assigning a specific color for better visual categorization. Implementing this efficient n8n automation significantly improves scheduling accuracy and saves valuable administrative time.

This comprehensive n8n workflow operates in three primary phases, starting with the designated n8n trigger.

1. Trigger and Data Retrieval: The n8n automation begins with the 'New Event Entry Listener' (a Google Sheets n8n trigger). This n8n trigger is configured to activate immediately whenever a new row is added to the specified spreadsheet. It retrieves the complete row data, representing the newest event.

1. Date Formatting (Core Logic): The data then flows to the 'Event Date Formatter' n8n node (a Function node). Because Google Calendar often requires dates in a specific format (especially for all-day events), this n8n node is vital. It isolates the last item received from the trigger, extracts the event name, description, location, and start date. Crucially, it calculates the current year and ensures the raw date string is converted into a standard ISO date format (YYYY-MM-DD), preparing it perfectly for the next step of the n8n workflow.

1. Calendar Event Creation: Finally, the formatted data is passed to the 'Google Calendar Event Creator' n8n node. This node uses expressions (={{ $json.startDate }}) to dynamically input the processed event details (start date, end date, summary, location, and description). It creates an all-day event, sets the event color, and marks the user as 'Available' (transparent), successfully concluding the automated scheduling sequence within the n8n workflow.

To utilize this n8n workflow template effectively, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON data and paste it directly into your n8n instance using the Import from JSON option.


2. Google Sheets Setup: You need existing credentials for Google Sheets. Open the 'New Event Entry Listener' n8n trigger node. Select your Google Sheets credentials and configure the specific Document ID and Sheet Name where your event data resides. Ensure the trigger is set to listen for a 'Row Added' event.


3. Google Calendar Setup: Open the 'Google Calendar Event Creator' n8n node. Select or create your Google Calendar credentials. Specify the Calendar ID where the new events should be created.


4. Activate: Once credentials and document IDs are set in both the n8n trigger and the final action n8n node, ensure the workflow is active in your n8n instance by toggling the switch in the top right corner. The n8n workflow is now operational.

This n8n workflow relies on three main components to achieve seamless automation:

New Event Entry Listener (Google Sheets Trigger)
Function: Acts as the starting n8n trigger, initiating the n8n workflow whenever new data (a new event row) is added to a connected Google Sheet.
Key Configuration: Operation is set to rowAdded. It requires selecting the specific spreadsheet (Document ID) and sheet (Sheet Name) to monitor.

Event Date Formatter (Function n8n Node)
Function: Essential for data cleansing and preparation. It extracts the raw event details and specifically handles the conversion of the input date string (e.g., '11 March') into a strict ISO format (YYYY-MM-DD), which is mandatory for correct event creation in Google Calendar.
Key Configuration: Contains custom JavaScript to select the last item in the array, append the current year if missing, and use startDate.toISOString().split("T")[0] to format the date.

Google Calendar Event Creator (Google Calendar n8n Node)
Function: Takes the formatted data from the previous n8n node and creates the event in Google Calendar, using expressions to map the input fields.
* Key Configuration: Uses expressions for Summary (Event Name), Description, Location, and sets both Start and End dates to the formatted startDate. It is configured as an All-day event, with Show Me As set to 'transparent' (Available) and a specific color code (3).