DreamApply + Google Sheets + Asana
Generate reports in Google Sheets rows to track the time it takes to fulfill new data removal requests in DreamApply
Generate reports in Google Sheets to track the time it takes to fulfill an applicant's request to be forgotten in DreamApply. The automation adds a row with a timestamp and no personal data. In the next step, the automation creates a task in Asana and waits for the task be fulfilled. Once the task is marked as done, a row with an updated timestamp is added and the spreadsheet calculates the time it took form the request in DreamApply to task completion in Asana.
Generate reports in Google Sheets to track the time it takes to fulfill an applicant's request to be forgotten in DreamApply. The automation adds a row with a timestamp and no personal data. In the next step, the automation creates a task in Asana and waits for the task be fulfilled. Once the task is marked as done, a row with an updated timestamp is added and the spreadsheet calculates the time it took form the request in DreamApply to task completion in Asana.
- When this happens...Applicant Requested to Be Forgotten
Triggers when an applicant presses the button to request their data to be removed from the system, according to the GDPR right to be forgotten.
- automatically do this...
- then do this...Create Task
Adds a new task.
- then do this...Update Task
Updates an existing task.
- then do this!
- Free forever for core features
- 14 day trial for premium features & apps
Applicant Registered
Triggers when a new applicant has registered (on their own). This is separate from an applicant being imported or entered by an advisor/agent.
Try ItFlag
Try ItApplication Was Submitted
Triggers when an application is submitted for the first time. Note that there is a separate trigger for re-submitted applications.
Try ItInvoice Was Collected
Triggers when an invoice was marked as fully paid. This can happen when the applicant makes a payment using a payment gateway (PayPal, Flywire, Mollie, Authorize.net, Simplepay or others) or when the admissions administrator or accountant manually marks the invoice as paid.
Try It
Applicant Requested to Be Forgotten
Triggers when an applicant presses the button to request their data to be removed from the system, according to the GDPR right to be forgotten.
Try ItApplication Was Re-Submitted
Triggers when an application is re-submitted (after being submitted and reopened before). This may trigger multiple times as applications can be reopened and re-submitted by applicants at will. Note that there is a separate trigger for catching just the first-time submitted applications.
Try ItFlag
Try ItInvoice Was Issued
Triggers when a new invoice is issued. This can happen automatically using the rules engine or the API, but often invoices are also issued manually by the admissions administrator.
Try It
