Generate fake emails that are clean and acceptable but outreach tools. Why? Because you should reach your leads on LinkedIn if you don’t have their e-mail. Nothing is lost.
- Create a new Google Sheets file
- Create a table with a column first name and another one for the last name
- Go to Extensions → Apps Script
- Remove all the code and copy-paste the following instead
- Save your project and go back to your sheet
- Use generateEmail(B1;B2), like classic Google Sheets Formula
The 3 new functions in Google Sheets:
The code to paste in Apps Script inside Google Sheets:
function generateEmail(first_name, last_name) {
if (first_name && last_name) {
first_name = first_name.toLowerCase().replace(/[éèë]/g, 'e').replace(/[àäâ]/g, 'a').replace(/[ïî]/g, 'i').replace(/[öô]/g, 'o').replace(/[ùüû]/g, 'u').replace(/\s+/g, '');
last_name = last_name.toLowerCase().replace(/[éèë]/g, 'e').replace(/[àäâ]/g, 'a').replace(/[ïî]/g, 'i').replace(/[öô]/g, 'o').replace(/[ùüû]/g, 'u').replace(/\s+/g, '');
return first_name + "-" + last_name + "@fake-mail.com";
}
return "";
}
generateEmail('First Name', 'Last Name')
