Thank referrers and invite referred candidates

Employees refer more people when they hear back quickly. When a row is added to your Referrals sheet, this thanks the employee who made the referral, invites the candidate to apply, and tells the recruiting channel in Slack.

The sheet needs the columns Referrer name, Referrer email, Candidate name, Candidate email and Role.

Google SheetsWhen a row is added to the Referrals tab. Save it as referral.When a row is added to the Referrals tab. Save it as referral.

Thank the employee who referred themSend an email to referral.fields["Referrer email"]. Save it as thanks. Subject: Thanks for referring referral.fields["Candidate name"]Hi referral.fields["Referrer name"], Thank you for referring referral.fields["Candidate name"] for our referral.fields.Role role. We have invited them to apply and the recruiting team will keep you posted.Gmail

Invite the candidate to applySend an email to referral.fields["Candidate email"]. Save it as invite. Subject: referral.fields["Referrer name"] thinks you'd be great for our referral.fields.Role roleHi referral.fields["Candidate name"], referral.fields["Referrer name"] suggested you for our referral.fields.Role role and we'd love to hear from you. Reply to this email with your resume and we'll take it from there.Gmail

Tell the recruiting channelSend message to channel. Save it as recruiting_alert.New referral: referral.fields["Referrer name"] referred referral.fields["Candidate name"] (referral.fields["Candidate email"]) for referral.fields.Role.Slack