Smart Visual Applicant Tracking System (Gmail + Sheets + Drive)

🛠 What You Need Before Setup

• ✅ A Gmail account (used for hiring)
• ✅ A Google Sheet (template provided)
• ✅ A Google Drive folder to store resumes
• ✅ Access to Apps Script (inside the Sheet)

📁 Folder Setup

1. Go to your Google Drive
2. Create a folder named: SVATS - Resumes
3. Copy the Folder ID from the URL:Example:https://drive.google.com/drive/folders/1fgypcn0lRhvyPYVnJYov00t0ENSGefBN Folder ID = 1fgypcn0lRhvyPYVnJYov00t0ENSGefBN

📄 Google Sheet Setup

1. Open the SVATS Sheet
2. Navigate to Extensions > Apps Script

🔧 Paste Script

1. Delete all existing code in the App’s Script editor
2. Paste the complete script provided in your documentation