Sync Asana task updates with Google Calendar events

Description

Quick overview
This workflow listens for changes to tasks in an Asana project, looks up the linked Google Calendar event from an n8n Data Table sync log, and updates the event’s title, description, attendees, or date/time to match the latest task details.

How it works
Triggers when an Asana task changes in the selected workspace/project.
Looks up the task’s sync record in an n8n Data Table and ignores updates that were already synced based on the stored last-synced timestamp.
Fetches the Asana task details (including assignee and followers) and retrieves the linked Google Calendar event.
Compares the task fields to the event fields to detect changes in name, description, attendees (company-domain), or start/end times.
Updates the Google Calendar event fields for each detected difference.
Writes the task’s latest modified timestamp back to the Data Table sync log to prevent reprocessing the same change.

Setup
Connect Asana OAuth2 credentials and select the workspace and project to monitor in the Asana trigger.
Connect Google Calendar OAuth2 credentials and ensure the workflow user has access to the target calendar.
Create/select the n8n Data Table used as the sync log and ensure it contains CalendarEventID, AsanaTaskID, and LastSyncedUpdate columns, then select the same table in both Data Table steps.
Set your Google Calendar ID and your company email domain in the configuration step (used to decide which attendees to add/remove).