Setup required: Connect Google Sheets to enable activity tracking & rep logging.
Outreach Email Generator
From Cold to Closed in 7 touches with hyper-personalization and relevance.
Prospect details
Select your name to begin
Company Intel
Select your outreach touch
✅ 1 reply⭐ 1-4 replies — Getting traction🔥 5-9 replies — Hot performer🏆 WINNER (10+) — Hall of fame
Touch 1Cold Intro Email
Subject:
Tip: Write this on a branded notecard or postcard with a pen. Handwritten mail gets opened.
Full 7-Touch Sequence
Generating…
Starting…
Google Sheets Setup — Activity Tracking
This one-time setup takes about 5 minutes. After setup, every email generated will be logged automatically — rep name, prospect details, touch number, and timestamp.
1 Create your Google Sheet
Go to sheets.google.com and create a new spreadsheet. Name it "Hometown UC Outreach Log" or similar. Leave it open.
2 Open Apps Script
In your sheet, click Extensions → Apps Script. Delete any default code and paste this exactly:
function doPost(e) {
try {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var data = JSON.parse(e.postData.contents);
if (sheet.getLastRow() === 0) {
sheet.appendRow(['Timestamp','Rep Name','Touch #','Touch Type',
'Industry','Prospect Role','Company','Context','Sequence Type']);
}
sheet.appendRow([
data.timestamp, data.rep, data.touchNumber, data.touchType,
data.industry, data.role, data.company, data.context, data.sequenceType
]);
return ContentService
.createTextOutput(JSON.stringify({status:'ok'}))
.setMimeType(ContentService.MimeType.JSON);
} catch(err) {
return ContentService
.createTextOutput(JSON.stringify({status:'error',message:err.toString()}))
.setMimeType(ContentService.MimeType.JSON);
}
}
3 Deploy the script
Click Deploy → New deployment. Select type: Web app. Set:
• Execute as: Me • Who has access: Anyone
Click Deploy, authorize when prompted, then copy the Web app URL it gives you.
4 Paste your Web App URL here
Paste the URL from step 3 below. It will be saved to this browser so logging activates immediately.
Saved! Logging is now active.
5 Update rep names in the HTML
Open the HTML file in a text editor (Notepad, TextEdit, VS Code). Find the comment that says THERESA: ADD OR EDIT REP NAMES BELOW and replace the placeholder names with your actual rep names. Save and re-distribute the file.
