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.
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!