When a referral is added to your sheet, thanks the employee, invites the candidate and tells recruiting in Slack.
Uses
Gmail
Google Sheets
Slack
Thank referrers and invite referred candidates
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.GmailInvite 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.GmailTell 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