lemlist
For Sheets
All tools
Functions
Clean first names
Normalize names from your list. Remove emojis and capitalize names correctly ("🔥 lucas" → "Lucas")
=cleanFirstName(
“lucas 🔥”
)
Copy code
Open tutorial
Clean company names
Normalize company name from your list. Remove emojis and legal entities. (("Apple LLC. 🔥" → "Apple")
=cleanCompanyName("ACME Ltd")
Copy code
Open tutorial
Find domain names
Find the domain from a company name. ("apple" → "apple.com")
=findDomain()
Copy code
Open tutorial
Find social media profiles
Find social media URLs (Linkedin, Twitter, Youtube, Facebook, Instagram) from a domain name.
=getSocialLinks()
Copy code
Open tutorial
Classify Job Titles
Classify job titles into departments ("head of business" → "sales")
=classifyJobTitle("Business developer")
Copy code
Open tutorial
Fetch website text content
Fetch the given website url and get the text content.
Tip : then use the AI feature to enrich a company from their website
=getWebsitePageContent("https://wwww.lemlist.com")
Copy code
Open tutorial
Extract emails from text
Extracts emails in the text of your choice
=extractEmailFromText()
Copy code
Open tutorial
Extract emails from website
Extracts emails of a website page
=extractEmailFromWebsite("https://www.lemlist.com")
Copy code
Open tutorial