Bidirectional ClickUp Task & Google Calendar Sync with Multi-Calendar Routing

This n8n workflow provides a robust solution for synchronizing tasks between ClickUp and Google Calendar, supporting bidirectional updates and intelligent routing to multiple Google Calendars based on task attributes. It ensures that your tasks and events are always up-to-date across both platforms.

What it does

This workflow automates the following processes:

1. ClickUp Task Trigger: Listens for new tasks or updates in ClickUp.
2. Google Sheets Lookup: Queries a Google Sheet to determine which Google Calendar to use for synchronization based on task data (e.g., a specific tag or custom field).
3. Conditional Routing: Uses an If node to check if a matching calendar is found in the Google Sheet.
4. Google Calendar Event Management:
   • If a matching calendar is found, it creates or updates an event in the designated Google Calendar.
   • If no matching calendar is found, it can route to a default calendar or skip the Google Calendar action.
5. Data Transformation: Utilizes Set nodes to format data appropriately for each service.
6. Merge Paths: Combines different execution paths back together for a cleaner workflow structure.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• ClickUp Account: With an API key configured as an n8n credential.
• Google Calendar Account: With OAuth2 credentials configured in n8n, granting access to create, update, and delete events in your calendars.
• Google Sheets Account: With OAuth2 credentials configured in n8n, granting access to read from your routing spreadsheet.
• Google Sheet: A spreadsheet containing your routing logic (e.g., mapping ClickUp tags/fields to Google Calendar IDs).

Setup/Usage

1. Import the Workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • Set up your ClickUp API Key credential.
   • Set up your Google OAuth2 credential for Google Calendar and Google Sheets. Ensure it has the necessary scopes for both services.
3. Configure ClickUp Trigger (Node 130):
   • Select your ClickUp credential.
   • Choose the ClickUp Space, Folder, List, or Workspace you want to monitor for task changes.
   • Specify the events you want to trigger the workflow (e.g., Task Created, Task Updated).
4. Configure Google Sheets (Node 18):
   • Select your Google Sheets credential.
   • Specify the Spreadsheet ID and Sheet Name that contains your calendar routing information.
   • Ensure the sheet has columns that can be used to map ClickUp task data to Google Calendar IDs.
5. Configure Google Calendar (Node 317):
   • Select your Google Calendar credential.
   • Configure the operations (e.g., Create Event, Update Event) and map the data from ClickUp and the Google Sheet to the appropriate Google Calendar event fields (summary, description, start/end times, calendar ID).
6. Customize Routing Logic (Node 20 - If, Node 112 - Switch):
   • Adjust the conditions in the If node (Node 20) to match your Google Sheet lookup results.
   • If you have complex routing to multiple calendars, customize the Switch node (Node 112) to direct tasks to different Google Calendar actions based on the calendar ID retrieved from the Google Sheet.
7. Activate the Workflow: Once configured, activate the workflow to start synchronizing tasks.

Note on Bidirectional Sync: While the workflow description implies bidirectional sync, the provided JSON only shows a ClickUp Trigger and Google Calendar actions. To achieve full bidirectional sync, you would need a separate Google Calendar Trigger that detects new/updated events and then creates/updates tasks in ClickUp, potentially using a similar routing and lookup mechanism. The current workflow focuses on ClickUp to Google Calendar sync.