Welcome new hires from a sheet

Day one goes better when the meeting is booked, the new hire knows when to arrive and IT has had notice. Adding a row to your New Hires sheet starts all three.

The manager gets a 30-minute welcome meeting at 9:00 on the start date, the new hire gets a friendly note, and your IT channel is asked to set up a laptop.

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

New hire's name split into wordsSplit new_hire.fields.Name by a space and save it as name_parts.

Welcome meeting on the manager's calendarCreate the event 'Welcome meeting with new_hire.fields.Name' from new_hire.fields["Start date"]T09:00:00 to new_hire.fields["Start date"]T09:30:00. Save it as welcome_meeting. Calendar: new_hire.fields["Manager email"]new_hire.fields.Name, starting as new_hire.fields.Role, joins the team today.Google Calendar

Email the new hire their welcome noteSend an email to new_hire.fields["Personal email"]. Save it as welcome_email. Subject: Welcome to the team, name_parts[0]Hi name_parts[0], We are delighted that you are joining us as new_hire.fields.Role. Your first day is new_hire.date_display. Your manager, new_hire.fields["Manager email"], has set up a welcome meeting with you at 9:00 AM that day. Please get in touch with them if you have...Gmail

Ask IT to set up a laptopSend message to channel. Save it as it_notice.Please set up a laptop for new_hire.fields.Name (new_hire.fields.Role), who starts on new_hire.date_display. Their manager is new_hire.fields["Manager email"].Slack