Sync SAP sales project fields between Microsoft SQL and Asana

by n8n Lab ✓ · 36 views · created 2026-07-17 · CRM

What this workflow does

This workflow has 15 nodes and runs on a schedule (every hour). Along the way it connects Microsoft SQL.

How it runs

Trigger: On a schedule (every hour).

1. Query Unsynced Projects (Microsoft SQL): run a query
2. Any Records to Sync? (Filter): keeps only the items that match a condition
3. Mark as Processing (Microsoft SQL): run a query
4. Pass Project Context (Code): runs custom JavaScript code
5. Get Portfolio Projects from Asana (HTTP Request): calls an HTTP API
6. Match Project by Name (Code): runs custom JavaScript code
7. Project Found in Asana? (If): checks a condition and branches into true / false
8. Get Project Custom Fields (HTTP Request): calls an HTTP API
9. SQL — Mark Waiting for Project ID (Microsoft SQL): run a query
10. Build Custom Fields Payload (Code): runs custom JavaScript code

…plus 4 more steps. See the full node list below.

Services it uses

Microsoft SQL

Before you upgrade to n8n 3.0

Nodes used (6)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Microsoft SQLn8n-nodes-base.microsoftSql
• Filtern8n-nodes-base.filter
• Coden8n-nodes-base.code
• HTTP Requestn8n-nodes-base.httpRequest
• Ifn8n-nodes-base.if

From the author

Quick overview This workflow runs hourly to sync project records from a Microsoft SQL Server staging table into matching Asana projects, updating Asana custom fields and writing back sync status, errors, and the Asana project ID to the database. How it works…

View the original on n8n.io → Check your own copy