Refresh Appdrag records when Asana tasks change
Keep a supporting Appdrag row current as task details evolve. Notis can use the update event context with your configured Visual SQL UPDATE function.
Trigger
Task Updated
Triggers when a task is updated in a project.
Action
Visual SQL Update
Tool to execute a Visual SQL UPDATE via an AppDrag Visual UPDATE function. Use when you need to update database rows based on your Visual UPDATE mapping.
Why this helps
Task information changes in Asana, leaving a related Appdrag record outdated until someone remembers to refresh it.
- Reduce stale supporting records.
- Refresh relevant database information as work changes.
- Keep updates tied to the originating task event.
Setup
Build it in a few focused steps.
- 1Connect Asana and Appdrag once in the Notis portal.
- 2Create an automation in Automations, New Automation, or tell Notis from any channel.
- 3Describe which matching Appdrag row should be updated and how your Visual SQL UPDATE function should use the task context.
- 4Pick the Asana Task Updated trigger and choose where run reports go.
- 5Test with one real task update and verify the intended row changed.
Questions about this workflow
What must already exist in Appdrag?
A configured Visual SQL UPDATE function with a suitable row selection and update behavior.
Will Notis choose a matching row automatically?
Your Appdrag function must define how rows match and update. Explain the relationship between the task and the row in your instruction.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Asana to Appdrag. A trigger fires from one place; an action lands in another.
Asana triggers
Appdrag actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Execute Cloud Backend function via DELETE
Tool to execute a Cloud Backend API function via DELETE on the default environment. Use when you need to call a function with DELETE parameters and optional APIKey.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Execute Preprod Function (DELETE)
Tool to execute the pre-production version of a Cloud Backend API function via DELETE. Use when you need to test or validate delete operations in the preprod environment before production deployment.
Attachment Added to Task
Triggers when an attachment is added to a task.
Execute PROD API Function (GET)
Tool to execute a production Cloud Backend API function via GET. Includes robust URL handling and fallbacks to accommodate management base URLs.
New Comment on Task
Triggers when a comment is added to a task in a project.
Execute Dev Function (PATCH)
Tool to execute the development version of a Cloud Backend API function via PATCH. Use after deploying or updating your function to the dev environment.
New Task Created
Triggers when a new task is created in a project.
Execute Cloud Backend function via POST
Tool to execute a Cloud Backend API function via POST on the default environment. Use when you need to call a function with POST parameters and optional APIKey.
Task Moved to Section
Triggers when a task is moved to a section in a project.
Execute Function POST (Preprod Env)
Tool to execute a Cloud Backend API function via POST on the preprod environment. Use when you need to test a function in the preprod environment before releasing to production. Include apiKey if your function requires APIKey security.
Tag Added to Task
Triggers when a tag is added to a task. Note: Asana's event structure is inverted for tag events — the resource is the task and the parent is the tag. So parent.gid gives the tag GID.
Execute Cloud Backend function via PUT (default)
Tool to execute a Cloud Backend API function via PUT on the default environment. Use when you need to call a function with PUT parameters and optional APIKey.
Task Updated
Triggers when a task is updated in a project.
Execute Cloud Backend function via PUT (preprod)
Tool to execute a Cloud Backend API function via PUT on the preprod environment. Use when you need to call a function with PUT parameters and optional APIKey in preprod.
Connect any two apps with Notis in the middle.
Asana and Appdrag, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Appdrag.