Extracting Contact Information from Outlook Calendar Invites

Hi - I am trying to extract first, last, email and company from an Outlook calendar invite. The info is in a wide variety of formats. Data is here: https://app.clay.com/workspaces/498799/tables/t_djZh3F7PrPo2/views/gv_F4cu7rSPhfgg

7 comments

Channeled
APP
·
·
You can use Clay's Extract Values integration to pull this information from your calendar invite data. Here's how: 1. Use the "Extract Values from Data" feature with your calendar invite text as input. This integration can identify and extract specific information like email addresses from complex datasets. 2. For email addresses specifically, you can then use the "Identify Email Type and Extract Company Domain" integration which will help you: • Extract the company domain • Get the username • Determine if it's a work or personal email • Parse out additional email details For best results, first test this approach on a small sample of your calendar invites to verify the extraction accuracy before processing your full dataset.
Sources: Identify Email Type and Extract Company Domain from Email with Clay Extract Values from Data with Clay
Channeled
APP
·
·
Was that helpful?
Tom P.
·
·
I tried that. I don't understand how to capture the data and extract it to a field
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
Owen C.
·
·
Hey there, thanks for reaching out! This can actually be done 100% with formulas! Recorded a quick video going over this. :) Loom Video Let me know if you have any other questions or concerns here!