Automation Projects

Project Overview

Daniel Okafor runs a logistics company in Lagos hiring for three roles. His team had no system for tracking applications. Candidates never got confirmation emails. HR only checked the inbox when they remembered to. Good candidates moved on before anyone responded.

I built an n8n automation that eliminates every manual step. When a candidate submits a Tally form, the workflow confirms receipt by email, logs their details to Google Sheets, and notifies HR instantly. A Switch node categorizes each applicant as Junior (0-2 years), Mid-Level (3-5 years), or Senior (6+). Junior candidates receive a polite rejection email. Qualified candidates (3+ years) go through an automated scheduling path. A JavaScript node reads existing interviews from the sheet, finds the next available weekday slot starting 5 days out, and caps bookings at 5 per day. The workflow creates a Google Calendar event with a Meet link and sends the candidate an interview invitation with the exact date, time, and meeting URL. The applicant's row in the sheet updates from Pending to Scheduled automatically. No one types anything. No one copies a link. No candidate falls through the cracks.

Tools Used 

• n8n

• Tally.so

• Google Sheets

• Gmail 

How it Works

Here is the updated version reflecting the full workflow:

1. Candidate fills out the Tally application form.

2. Tally sends the submission to n8n via webhook.

3. n8n cleans the form data and assigns a category (Junior, Mid-Level, or Senior) based on years of experience.

4. n8n logs the applicant's details to Google Sheets with Interview Status set to Pending.

5. n8n sends a confirmation email to the applicant.

6. n8n notifies the HR team by email with a summary of the application.

7. n8n routes the applicant through a Switch node based on experience band (0-2, 3-5, 6+).

8. Junior candidates (0-2 years) receive a polite rejection email.

9. Qualified candidates (3+ years) enter the scheduling path.

10. n8n reads existing interviews from the Google Sheet to check which slots are taken.

11. A JavaScript node calculates the next available weekday slot, starting 5 days out, with a cap of 5 interviews per day.

12. n8n creates a Google Calendar event with a Google Meet link for the interview.

13. The candidate receives an interview invitation email with the exact date, time, and Meet link.

14. n8n updates the applicant's row in Google Sheets from Pending to Scheduled with the interview date.

Screenshots