ninad-hazarika/outreach-automation-v1

outreach-automation-v1 turns a Google Sheet into a simple personal system for tracking cold outreach emails, built for a student handling an internship or job search rather than a business running a marketing campaign. It uses only tools people already have free access to as a student: Google Sheets, Google Apps Script, Gmail, and a free Telegram bot for notifications. You list the companies or people you want to contact in a spreadsheet, and the tool fills in email content from fields you have already entered, with no AI involved in this version. It then creates a Gmail draft, but only for a row you have explicitly marked as verified and approved, so nothing goes out automatically without you checking it first. Once you approve sending, it tracks the sent date, the Gmail thread, and checks later for replies. It can also prepare and send a single follow-up email per contact once you approve that too, and it sends you Telegram alerts summarizing what happened. Safety is built in as a set of switches you control from a separate tab in the spreadsheet: a test mode that redirects everything to your own email address, a master switch that can block all sending, a daily limit on how many emails go out, and per-row checkboxes that require you to confirm an email address and approve each send individually. The whole thing runs automatically once an hour through a Google Apps Script trigger, and any errors are written back into the spreadsheet next to the row that caused them. Setting it up means creating a Google Sheet with two specific tabs, pasting the provided script into the sheet's built-in Apps Script editor, and following a written installation guide, ideally while running in test mode first. The author is explicit that this is meant for a small number of personalized, researched contacts, not for spam or mass emailing scraped lists. It is released under the MIT license.