Create onboarding tasks for a new hire

Onboarding tasks get missed when they depend on someone remembering. When a row is added to your New Hires sheet, this creates three Asana tasks with due dates counted in working days from the person's start date: a kickoff call after 2, IT setup after 5 and benefits enrollment after 10.

It then emails the new hire's manager so they know the tasks exist. Your sheet needs columns named Name, Start date (written 2026-11-30) and Manager email.

Google SheetsWhen a row is added to the spreadsheet. Save it as hire.When a row is added to the spreadsheet. Save it as hire.

Task: kickoff callCreate task 'Kickoff call with hire.fields.Name'. Save it as kickoff. Due in working days: 2 Count working days from: hire.fields["Start date"]Asana

Task: IT setupCreate task 'IT setup for hire.fields.Name'. Save it as it_setup. Due in working days: 5 Count working days from: hire.fields["Start date"]Asana

Task: benefits enrollmentCreate task 'Benefits enrollment for hire.fields.Name'. Save it as benefits. Due in working days: 10 Count working days from: hire.fields["Start date"]Asana

Start date as people read itMake hire.fields["Start date"] readable and save it as start_date_written.

Email the managerSend an email to hire.fields["Manager email"]. Save it as emailed. Subject: Onboarding tasks created for hire.fields.NameHi, hire.fields.Name starts on start_date_written. I've created three onboarding tasks in Asana: a kickoff call, IT setup and benefits enrollment. Thanks!Gmail