Inquiry about Extracting Data from Gmail Hi,

[JP.C]

Hi,

Is there a way to extract the following data from an email in a Gmail account, such as the phone number and email address?

Here’s the use case: we want to extract the necessary data from a Gmail email when a customer purchases a membership. We use a platform with API and Webhooks. Our goal is to send a message via ManyChat, and to do this, we need to extract the WhatsApp number from the Gmail email using ChatGPT.

Is this possible? What would be the process in ActivePieces?

Thank you for your help.

Best regards,
JP

[kishanprmr]

Hello @JP.C ,

You can use the ‘Extract Structured Data from Text’ action of the OpenAI piece. Please refer to the attached post for details.

Introducing the Extract Data from Text Action for OpenAI!

Hello Activepiecers , We’re excited to announce the new Extract Data from Text action for OpenAI piece. Now, you can extract useful data in a structured way from unstructured text. Quick Tutorial Map unstructured text from the previous step to the Unstructured Text field and provide a brief description of instructions to help the AI extract particular data in the Prompt field. [image] Provide the name and type of property for the output structured data. You can also provide a descri…

[Drewzy]

Another option, if you don’t want to call OpenAI every time you run:

Create a code piece. This will allow you to run typescript on the email body to parse the WhatsApp number.

If you don’t know typescript (I didn’t) go to ChatGPT and give it a sample email and ask it to write a typescript code to extract the info. It helped to also give a screenshot of the piece configuration panel

[JP.C]

Thank you for the great support you gave me, infinite thanks!