Sync Google Calendar events with Asana tasks using a data table log
Ready for 3.0What this workflow does
This workflow has 23 nodes and runs on a schedule (every hour). Along the way it connects Google Calendar and Asana. It also calls app.asana.com over HTTP.
How it runs
Trigger: On a schedule (every hour).
- Set configuration (Edit Fields (Set)): sets 7 fields: Period, NumberOfPeriods, calendarId…
- Get sync records (Data table): get
- Get Calendar Events (Google Calendar): get many
- Rename row ID field (Edit Fields (Set)): sets 1 field: RowID
- Keep standard events only (Filter): keeps only the items that match a condition
- Match events with sync records (Merge): merges the data from its input branches
- Loop over events (Loop Over Items (Split in Batches)): loops over the items in batches
- Set Event Data (Edit Fields (Set)): sets 14 fields: Title, Description, EventStatus…
- Route by sync action (Switch): routes items into 3 branches
- Add Task Deleted Comment (Asana): work with task comment
…plus 12 more steps. See the full node list below.
Services it uses
HTTP calls to: app.asana.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (11)
- HTTP Request
n8n-nodes-base.httpRequest - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Calendar
n8n-nodes-base.googleCalendar - Data table
n8n-nodes-base.dataTable - Edit Fields (Set)
n8n-nodes-base.set - Merge
n8n-nodes-base.merge - Asana
n8n-nodes-base.asana - Code
n8n-nodes-base.code - Filter
n8n-nodes-base.filter - Switch
n8n-nodes-base.switch - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Quick overview This workflow runs hourly to sync Google Calendar events into Asana tasks, using an n8n Data Table as a sync log to create, update, or delete tasks based on event changes, cancellations, and declines. How it works 1. Runs every hour on a…