Lead Formatter: Triple Your Cold Email Reply Rates

Lead Formatter is a Google Sheets add-on that helps you clean, format, and segment your lead lists inside Google Sheets. Use your own OpenAI API key to pull personalised details from ChatGPT about your leads, making your emails more relevant and effective.

## Functions:

## Manual Tasks:

➩ Remove Blanks and Duplicates: Finds and deletes any empty spaces or repeated entries in columns like names, emails, and company names. Creates new tabs: "Non-Email Outreach" for leads without emails (to use for LinkedIn or calls) and "To Enrich" for leads missing key details like first names or company names. This helps avoid mistakes and ensures all leads are ready to use.

➩ Format Company Names: Uses a custom formula to make company names consistent, so they look professional in emails.

➩ Format Job Titles: Uses a custom formula to make job titles consistent and accurate, while picking the most important job title if there are multiple (like choosing "Co-Founder" over "Marketing Director") to target decision-makers more effectively.

➩ Segment Leads: Groups leads by job title or location so you can create more focused campaigns.

## ChatGPT Tasks:

➩ Enhanced Job Title Formatting: Uses ChatGPT to make job titles more natural and relevant.

➩ Enhanced Company Name Formatting: Uses ChatGPT to make company names more accurate.

➩ Pull Company LinkedIn Descriptions: Retrieves company descriptions from LinkedIn to add more detail to your outreach.

➩ Generate Company Service Description: Determines what services a company offers (like "Paid Ads Agency" for a marketing agency) so you can be more specific with your campaigns and emails.

➩ Personalised Lines Generator: Creates personalised lines for each lead to make your emails more engaging. Also helps to increase deliverability as a form of spintax.

➩ Check for Case Studies: Looks for any mention of companies they have worked with, to see if this can be used to personalise your outreach.

➩ Pull Case Study Names: If a case study is found, retrieves the company name to mention in your emails, like: "Your case study with {Case Study Data} is impressive – we could use this to help you..."

## Key Benefits:

➩ Increase Reply Rates: Triple your reply rates by using data that makes your emails stand out.

➩ Save Time and Reduce Mistakes: Quickly clean, format, and improve your lead lists, avoiding errors and saving hours of work.

➩ Make Emails More Personal: Use AI to create custom messages that connect better with each lead.

➩ Create Focused Campaigns: Segment your leads by job title or location to create more relevant and targeted campaigns.

➩ Get More from Every Lead: Ensure all leads are complete and ready to use, reducing waste and increasing your return.