When a row is added to your Offboarding sheet, creates the offboarding tasks in Asana, dated from the last day, and emails the manager.
Uses
Asana
Gmail
Google Sheets
Offboard a leaving employee
Google SheetsWhen a row is added to the Offboarding tab. Save it as leaver.When a row is added to the Offboarding tab. Save it as leaver.Task: remove system accessCreate task 'Remove system access: leaver.fields.Employee'. Save it as it_task.
Due date: leaver.fields["Last day"]AsanaTask: exit interviewCreate task 'Exit interview: leaver.fields.Employee'. Save it as exit_task.
Due in working days: -2
Count working days from: leaver.fields["Last day"]AsanaTask: hand over their workCreate task 'Hand over work: leaver.fields.Employee'. Save it as handover_task.
Due in working days: -5
Count working days from: leaver.fields["Last day"]AsanaEmail the managerSend an email to leaver.fields["Manager email"]. Save it as told_manager.
Subject: leaver.fields.Employee's offboardingHi,
leaver.fields.Employee's last day is leaver.date_display. We've created the offboarding tasks in Asana, including a handover task assigned to you.
ThanksGmail