Extracting Names and Emails from Outlook Meeting Invites: Seeking Cost-Effective Solutions

Newbee here. I can extract names and emails (combined) from an outlook meeting invite. It is a mix of formats. I’d like Clay to extract first, last and email so I can subsequently find LinkedIn profiles and their location (so I can invite people to local events later). Is there something cheaper than using a ClayAgent for this?

12 comments

Channeled
APP
·
·
Yes, you can use Clay's free template to accomplish this in a cost-effective way. Here's how: 1. First, manually extract the names and company information from your Outlook invites 2. Copy our free template in Clay (you'll need to create a free account if you don't have one) 3. Input the full names and company names into the Clay table 4. Clay will automatically find the corresponding LinkedIn profiles for these people You can use the Clip to Clay Chrome extension from the Chrome Web Store to easily save LinkedIn profiles to your Clay table for further enrichment. Once you have the LinkedIn profiles, you can enrich them with additional information like location and email addresses using Clay's enrichment capabilities.
Source: Claybooks: Search LinkedIn profiles for target keywords | Clay.com
Channeled
APP
·
·
Is that what you were looking for?
Channeled
APP
·
·
Hi Tom P.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Bharat D.
·
·
4O mini can do this at a cheaper price instead of Claygent. If all the rows have similar data, you can even try formulas. Hit me up if you need help.
Channeled
APP
·
·
You can use Clay's built-in Extract Values feature to process your Outlook meeting invite data. Here's how: 1. Copy the names and emails from your Outlook invites into Clay 2. Use the Extract Values functionality to: • Extract email addresses from the text • Extract full names from the text Once you have the names extracted, you can use Clay's Email Permutation feature by: 1. Inputting the extracted full names 2. Adding company domains 3. Getting structured first names and last names automatically separated From there, you can enrich the data with LinkedIn profiles and location information using Clay's enrichment capabilities. Note: While third-party tools like 4O mini might work, using Clay's native extraction and enrichment features ensures better integration with your Clay workflow and data structure.
Sources: Extract Values from Data with Clay Generate Email Permutations with Clay
Channeled
APP
·
·
Was that helpful?
Tom P.
·
·
The output of outlook comes in a wide variety of formats. A regex pattern won’t work. Here is an example: John.doe@company.com Doe, Jane John S Smith t.tim@scrooge.com James.T.Kirk@starfleet.gov george_washington@us.gov Betsy Ross (b.ross@flag.com)
Channeled
APP
·
·
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
Channeled
APP
·
·
Looks like you're still looking for help.
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Tom P.
·
·
https://app.clay.com/workspaces/498799/tables/t_djZh3F7PrPo2/views/gv_F4cu7rSPhfgg
Tom P.
·
·
I figured it out
LuisArturo
·
·
Hey there sorry for the delay, great to hear you were able to address this.