Chase hiring managers on interviewed candidates

Good candidates go elsewhere while decisions wait. Every Monday this reads your Candidates sheet and emails the hiring manager about each candidate who was interviewed more than five days ago and is still waiting.

The sheet needs the columns Name, Status, Interview date and Hiring manager email.

Run every Monday at 09:00.Run every Monday at 09:00.

Candidates waiting for a decisionRead the rows of (not set). Save it as waiting.Google Sheets

For each candidateFor each candidate in waiting.rows:

Nudge the hiring managerSend an email to candidate["Hiring manager email"]. Save it as nudge. Subject: Decision needed: candidate.NameHi, candidate.Name was interviewed on candidate.date_display. Please tell the recruiter whether you want to move forward.Gmail