Extract csv file attached from Gmail and map extracted data into another module

Questions & Answers
1

Hi everyone,

I always receive an automatic email with the information of one prospect. I have this information written in the email but also in a csv file (see attached file) with the name of the prospect, address, phone number, etc… I would like to extract the info from this file (or from the content of the email) in order to create a deal in Pipedrive.

Could someone show me how to extract the data from the file correctly?

I am using a Gmail “watch email” to get the email with all the information. After that, I am a bit stuck on how I can do it.

You can find attached the content of the email and the file attached to this email.

Thanks for your help.

Best,

Capture d’écran 2022-09-06 à 18.38.09
Capture d’écran 2022-09-06 à 18.38.091566×1384 370 KB

Capture d’écran 2022-09-06 à 18.37.49
Capture d’écran 2022-09-06 à 18.37.492862×288 72.9 KB

Capture d’écran 2022-09-06 à 18.37.56
Capture d’écran 2022-09-06 à 18.37.561362×1332 95.7 KB

2

Hello Guillaume,

Use the “Parse CSV” module

image
image1308×1198 125 KB

2 Likes
3

Thanks Loic,

It’s working ! I did not know this module existed.

Best,

1 Like