# Recruitment Tracker - Google Sheets Setup Guide

## Why Google Sheets for Recruitment Tracking?

✓ **Real-time collaboration** — Multiple team members editing simultaneously  
✓ **Cloud-based** — Access anywhere, on any device  
✓ **Auto-save** — Never lose data  
✓ **Built-in sharing** — Team permissions management  
✓ **Comments & conversations** — Discuss candidates inline  
✓ **Mobile-friendly** — Check from your phone  
✓ **Free** — No licensing costs  

---

## Quick Setup (3 Steps)

### Step 1: Create a New Google Sheet
1. Go to **sheets.google.com**
2. Click the **+** (blank spreadsheet) icon
3. Name it: `Recruitment Tracker 2026` (or your preference)

### Step 2: Set Up Column Headers
Create headers exactly as shown (copy-paste recommended):

```
Candidate Name | Position | Date Applied | Source | Status | Interview Round | Rating (1-5) | Feedback | Next Steps | Follow-up Date | Salary Expectation | Notice Period
```

**Format headers:**
1. Select the header row
2. Click **Format** → **Number format** → **Bold** (or use Ctrl+B)
3. Add background color: **Format** → **Fill color** → Choose your brand color

### Step 3: Add Your First Candidates
Enter candidate data row by row. Example:

| Candidate Name | Position | Date Applied | Source | Status | Interview Round | Rating | Feedback | Next Steps | Follow-up Date | Salary Exp | Notice |
|---|---|---|---|---|---|---|---|---|---|---|---|
| John Smith | Senior Java Dev | 2026-08-01 | LinkedIn | Interview Stage | Technical Screening | 4 | Strong technical background | Schedule Behavioral | 2026-08-15 | ₹15L-₹18L | 30 days |

---

## Advanced Google Sheets Features

### 1. Data Validation (Dropdown Lists)

Create dropdown menus to prevent typos and standardize entries:

**For Status Column:**
1. Select all cells in the Status column (D2:D100)
2. Click **Data** → **Data validation**
3. Choose **List of items**
4. Enter: `Initial Screening, Interview Stage, Offer Extended, Rejected, On Hold, Hired`
5. Click **Done**

**For Interview Round Column:**
1. Select all cells in Interview Round column (F2:F100)
2. Click **Data** → **Data validation**
3. Enter: `Pending, Technical Screening, Round 1, HR Round, Final Round, All Rounds Complete`

**For Source Column:**
1. Select all cells in Source column (D2:D100)
2. Enter: `LinkedIn, Indeed, Referral, Job Board, Campus Drive, Direct Application`

### 2. Conditional Formatting

Highlight candidates based on status or follow-up urgency:

**Highlight Hot Candidates (Rating = 5):**
1. Select Rating column (G2:G100)
2. Click **Format** → **Conditional formatting**
3. Format rules: **Equal to** → **5**
4. Formatting style: **Green background** + **Bold text**

**Highlight Overdue Follow-ups:**
1. Select Follow-up Date column (J2:J100)
2. Click **Format** → **Conditional formatting**
3. Format rules: **Date is earlier than** → **TODAY()**
4. Formatting style: **Red background** + **Bold text**

**Highlight Active Interviews:**
1. Select Status column (E2:E100)
2. Click **Format** → **Conditional formatting**
3. Format rules: **Text is exactly** → **"Interview Stage"**
4. Formatting style: **Blue background**

### 3. Sort & Filter

**Quick Sorting:**
1. Select any cell in your data
2. Click **Data** → **Create a filter**
3. Click the filter icon (⇩) in any column header
4. Sort or filter as needed

**Common Filters:**
- Show only "Interview Stage" candidates
- Hide "Rejected" candidates
- Sort by "Follow-up Date" (oldest first)
- Sort by "Rating" (highest first)

### 4. Formulas for Automation

**Count Total Candidates:**
```
=COUNTA(A2:A100)
```

**Count by Status:**
```
=COUNTIF(E:E,"Interview Stage")
```

**Count by Rating:**
```
=COUNTIF(G:G,5)
```

**Average Rating:**
```
=AVERAGE(G2:G100)
```

**Days Since Application:**
```
=TODAY()-C2
```

**Place these formulas in a separate "Dashboard" sheet**

### 5. Create a Dashboard Sheet

**Step 1:** Add a new sheet
1. Click the **+** icon at the bottom
2. Name it "Dashboard"

**Step 2:** Add metric cards
In different cells, create your KPIs:

```
RECRUITMENT PIPELINE DASHBOARD

Total Candidates:           =COUNTA(Tracker!A2:A100)
Interview Stage:            =COUNTIF(Tracker!E:E,"Interview Stage")
Offer Extended:             =COUNTIF(Tracker!E:E,"Offer Extended")
Rejected:                   =COUNTIF(Tracker!E:E,"Rejected")
Average Rating:             =AVERAGE(Tracker!G2:G100)

By Source:
  LinkedIn:                 =COUNTIF(Tracker!D:D,"LinkedIn")
  Indeed:                   =COUNTIF(Tracker!D:D,"Indeed")
  Referral:                 =COUNTIF(Tracker!D:D,"Referral")
```

**Format Dashboard:**
1. Use **Font size 14** for headers
2. Use **Font size 18** and **Bold** for metric values
3. Add background colors to separate sections
4. Use **Freeze rows** for easy viewing

### 6. Share with Your Team

**Grant View Access (Read-Only):**
1. Click **Share** (top right)
2. Enter email addresses
3. Select **Viewer** → **Share**

**Grant Edit Access:**
1. Click **Share**
2. Enter email addresses
3. Select **Editor** → **Share**

**Create a Shared Team Link:**
1. Click **Share**
2. Change from "Restricted" to **"Anyone with the link"**
3. Select **Viewer** or **Commenter**
4. Copy link and share with team

### 7. Comments for Team Feedback

Leave notes directly on candidate entries:

1. Click on any cell
2. Click **Insert** → **Comment** (or Ctrl+Alt+M)
3. Type feedback: "Strong candidate, but asked for higher salary"
4. Mention teammates: Type @ and their email
5. Click **Comment** to post

### 8. Mobile App

**Access your tracker from anywhere:**
1. Download Google Sheets app (iOS or Android)
2. Open the tracker
3. Edit, comment, and update on the go

---

## Pro Tips for Google Sheets

### Tip 1: Use a Template from the Gallery
1. Go to **sheets.google.com**
2. Click the **Template gallery** icon
3. Search "recruitment" or "project tracker"
4. Start with a pre-built template and customize

### Tip 2: Protect Important Columns
Prevent accidental edits to important data:

1. Select column (e.g., Date Applied)
2. Click **Data** → **Protect sheets and ranges**
3. Give it a name: "Application Dates"
4. Click **Set permissions** → **Restrict who can edit**
5. Choose **Only me** or specific people

### Tip 3: Archive Old Candidates
Keep your main tracker clean:

1. Create a second sheet named "Archive"
2. Move rejected/hired candidates there monthly
3. Use **Cut** (Ctrl+X) and **Paste** (Ctrl+V)
4. Filter your main sheet to hide old data

### Tip 4: Link to Additional Resources
Connect candidate data to other files:

```
=HYPERLINK("https://www.linkedin.com/in/candidate", "View LinkedIn")
=HYPERLINK("https://drive.google.com/...", "Resume")
```

### Tip 5: Set Up Notifications
Track when important dates are coming:

1. Click on a cell with a date
2. Click **Insert** → **Checkbox**
3. Manually check when you follow up, or
4. Create a filter to "Show only unchecked"

### Tip 6: Export to Excel When Needed
Backup or share in Excel format:

1. Click **File** → **Download** → **Microsoft Excel (.xlsx)**
2. Saves to your computer

---

## Common Google Sheets Issues & Solutions

### Issue: Formulas not updating
**Solution:** Make sure your data range is correct. Example: If you add a new column, update the formula range.

### Issue: Sharing isn't working
**Solution:** Check your Google account permissions. Some organizations restrict sharing. Contact IT if needed.

### Issue: Performance is slow with many rows
**Solution:** Archive old data to a separate sheet. Keep main tracker under 500 rows for optimal speed.

### Issue: Data got accidentally deleted
**Solution:** Click **File** → **Version history** → Select a previous version and restore.

### Issue: Can't see other people's edits
**Solution:** Click the circular arrow icon (top right) to refresh, or reload the page.

---

## Collaboration Best Practices

### Establish Naming Conventions
- **Candidate Name:** First Last (no nicknames)
- **Position:** Full job title (not abbreviations)
- **Date Format:** YYYY-MM-DD (2026-08-01)
- **Status:** Use exact values from dropdown only

### Update Frequency
- **Daily:** Check status for same-day updates
- **After Interviews:** Update feedback within 2 hours
- **Weekly:** Review entire pipeline on Mondays
- **Monthly:** Archive rejected candidates

### Communication Protocol
- **Use Comments:** For feedback and questions
- **Mention Teammates:** @email to notify
- **No Direct Edits:** If unsure, comment first
- **Weekly Sync:** Review dashboard together

### Permission Levels
- **Founder/Hiring Manager:** Editor access (full control)
- **Recruiters:** Editor access (edit all data)
- **Interns/Admins:** Commenter (suggest changes)
- **Senior Management:** Viewer (reports only)

---

## Template Gallery Alternatives

If you prefer pre-built templates:

1. **Google Sheets Template Gallery**
   - Built-in templates (try "Project Tracker")
   - Customize for recruitment use

2. **Airtable**
   - More powerful than Sheets
   - Better for large-scale tracking
   - More expensive

3. **Monday.com**
   - Visual pipeline view
   - Team collaboration features
   - Paid plans start at $99/month

4. **Pipedrive**
   - Built specifically for pipelines
   - Real-time metrics
   - Best for enterprise teams

---

## Security & Data Protection

### Backup Your Data
1. Monthly: Download Excel version locally
2. Store in OneDrive or Google Drive
3. Keep dated backups (Tracker_Aug2026.xlsx)

### Privacy Considerations
- **Only share candidate data** with people who need it
- **Don't share publicly** — Restrict to "Anyone with link"
- **Remove personal details** when sharing reports
- **Archive sensitive data** after hiring cycle completes

### Access Control
- Regular review of who has access
- Remove access when team members leave
- Use "Viewer" role for consultants/advisors
- Audit trail: Google logs all edits with timestamps

---

## Advanced: Linking to Other Tools

### Link to Google Forms (Candidate Feedback)
1. Create a Google Form for interview feedback
2. Responses auto-populate into a sheet
3. Link individual responses to tracker

### Link to Gmail
Create canned responses for follow-up emails:
- "Hi {Candidate Name}, Just checking in on your application..."
- Merge data from Sheets into Gmail template

### Link to Google Calendar
1. Create a calendar event for follow-up dates
2. Link back to the tracker

### Link to Slack
1. Use Zapier or IFTTT to send Slack reminders
2. "Follow-up date today for {Candidate Name}"

---

## Troubleshooting Checklist

✓ Do all team members have edit access?  
✓ Are formulas using correct cell ranges?  
✓ Have you enabled data validation dropdowns?  
✓ Is conditional formatting applied to key columns?  
✓ Is your filter showing/hiding data correctly?  
✓ Are dates in consistent YYYY-MM-DD format?  
✓ Is the Dashboard sheet linked to the Tracker sheet?  
✓ Have you shared with the correct permission level?  
✓ Is the file name clear and searchable?  

---

## Quick Reference: Essential Formulas

```
Total Count:               =COUNTA(A2:A100)
Count by Status:           =COUNTIF(E:E,"Interview Stage")
Count by Rating:           =COUNTIF(G:G,5)
Average Rating:            =AVERAGE(G2:G100)
Days Since Applied:        =TODAY()-C2
Count by Source:           =COUNTIF(D:D,"LinkedIn")
Count Unique Values:       =COUNTA(D2:D100)-SUMPRODUCT(COUNTIF(D$2:D2,D2:D100))
```

---

## Next Steps

1. ✅ Create your Google Sheet
2. ✅ Add column headers
3. ✅ Set up data validation dropdowns
4. ✅ Add sample data (3-5 candidates)
5. ✅ Create a Dashboard sheet with formulas
6. ✅ Share with your team
7. ✅ Test comments and collaboration
8. ✅ Set up a monthly archive process

**Questions?** Check the FAQ section of the Quick Start Guide, or email support.

**Ready to go?** Start tracking and watch your recruitment efficiency improve immediately. 🚀

---

## Still Need Help?

- **Google Sheets Help Center:** support.google.com/sheets
- **Video Tutorials:** YouTube "Google Sheets Recruitment Tracker"
- **StaffIQ Blog:** More recruitment tracking tips and strategies
- **Contact Us:** For personalized setup assistance

Happy tracking! 📊