When you add a new hire to a Google Sheet, creates their kickoff, IT setup and benefits tasks in Asana and tells their manager.
Uses
Asana
Gmail
Google Sheets
Create onboarding tasks for a new hire
hire.When a row is added to the spreadsheet. Save it as hire.hire.fields.Name'. Save it as kickoff.
Due in working days: 2
Count working days from: hire.fields["Start date"]Asanahire.fields.Name'. Save it as it_setup.
Due in working days: 5
Count working days from: hire.fields["Start date"]Asanahire.fields.Name'. Save it as benefits.
Due in working days: 10
Count working days from: hire.fields["Start date"]Asanahire.fields["Start date"] readable and save it as start_date_written.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