MY 1st Workflow Made: Auto Datasheet/Email Response HR Application Form!!!!!!!!
🔄 Process Summary: 1. Form Submission Applicants fill out a web form providing details such as name, email, contact number, position applied for, years of experience, expected salary, and resume upload. 2. File Management Uploaded resumes are automatically saved to a designated Google Drive folder for recordkeeping. 3. Data Entry Applicant information is automatically added to a Google Sheet, ensuring all submissions are tracked and stored in one place. 4. Applicant Categorization A decision node evaluates specific responses (e.g., expected salary or position) to categorize applicants into groups like “Entry-Level,” “Skilled,” or “Expert.” 5. Notifications The system sends: An email to the recruiter with the applicant’s details and resume. An automated confirmation email to the applicant acknowledging receipt. 6. Completion The workflow finalizes by tagging or labeling the emails for easy tracking and closes the process automatically. ⚙️ Tools Involved: - Form Trigger – collects application data - Google Drive – stores uploaded resumes - Google Sheets – logs applicant details - Switch/Condition Node – categorizes based on rules - Email Integration – sends notifications 🚀 Next Improvement Plan: The next version of the workflow will: - Integrate a recruiter’s Google Drive where all applicant PDFs will be automatically uploaded and renamed based on the applicant’s name and document type. - Implement logic to handle multiple PDF files per submission, ensuring every uploaded document (e.g., Resume, Passport, Certificates, NBI) is properly renamed and organized into the correct folder. - Add checks to prevent overwriting and ensure consistent naming even when multiple applicants upload files at the same time. All suggestions are appreciated. Thank you!