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 Runs every hour and queries Microsoft SQL Server for up to 100 project records that are not yet synced (or previously failed) and have fewer than three sync attempts. Marks each selected record as “Processing” in SQL Server to prevent duplicate handling during the sync. Calls the Asana API to list projects in a specific portfolio and matches the SQL ProjectName to an Asana project name. If no Asana project matches, updates the SQL record to a “Waiting for Project ID” state with a message for manual project creation. If a match is found, retrieves the Asana project’s custom fields and builds an update payload mapping SQL values (manager, margin, revenue, costs, and dates) to Asana custom fields. Updates the Asana project via the Asana API and then marks the SQL record as “Completed” with the Asana project ID, or logs the error and marks the record as “Failed” while incrementing the attempt counter.
Tags
Microsoft SQLRelated workflows
See all Microsoft SQL→Execute an SQL query in Microsoft SQL
Explore this workflow on its official n8n template page.
Export SQL table into CSV file
This workflow demonstrates how easy it is to export SQL query to CSV automatically! Before running the workflow please make sure you have access to a local or remote MSSQL server with a sample AdventureWorks database. The detailed process is explained in the tutorial https://blog.n8n.io/sql-export-to-csv/