The latest articles on DEV Community by Vineet (@vineetgoyalhuf). https://dev.to/vineetgoyalhuf https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3853742%2F03f8ee8c-02f8-4969-869d-ec224942815c.png https://dev.to/vineetgoyalhuf en Vineet Tue, 31 Mar 2026 15:02:22 +0000 https://dev.to/vineetgoyalhuf/how-to-build-a-free-applicant-tracking-system-in-google-sheets-with-apps-script-3oo7 https://dev.to/vineetgoyalhuf/how-to-build-a-free-applicant-tracking-system-in-google-sheets-with-apps-script-3oo7 <p>INTRO: Small businesses don't need a $300/month ATS. Here's how to build a candidate tracking and email automation system in Google Sheets — free, with Apps Script.</p> <p>SECTION 1: The Sheet Structure</p> <ul> <li>4 sheets: Applications, Email Templates, Settings, Email Log</li> <li>Key design: Status column never triggers emails — explain why this matters</li> </ul> <p>SECTION 2: Reading Candidate Data Correctly</p> <ul> <li>The timezone bug: why getDisplayValue() is needed for date cells</li> <li>Code snippet: getCandidate() function</li> </ul> <p>SECTION 3: Non-Contiguous Row Selection</p> <ul> <li>The bug: getActiveRange() only returns last clicked range</li> <li>The fix: getActiveRangeList().getRanges()</li> <li>Code snippet: getSelectedRows() function</li> </ul> <p>SECTION 4: Email Providers</p> <ul> <li>GmailApp vs MailApp</li> <li>How to support 4 providers from one settings cell</li> <li>Code snippet: dispatch() function</li> </ul> <p>SECTION 5: Logo and HTML Signature</p> <ul> <li>buildHtmlEmail() wrapper function</li> <li>Code snippet</li> </ul> <p>SECTION 6: The Menu</p> <ul> <li>6 menu items, no more</li> <li>Why manual confirmation before every send matters</li> </ul> <p>If you want the pre-built template with all this already done: <a href="https://subswift.gumroad.com/l/jobapplicationtrack-googlesheets" rel="noopener noreferrer">https://subswift.gumroad.com/l/jobapplicationtrack-googlesheets</a></p> googleappsscript productivity javascript showdev