I have a csv file with data for 3 customers. I want to send the csv file to each customer with only their data. How do I edit the csv in gmail attachment?

[Mayur_Savaisarje]

I have a csv file with data for 3 customers. I want to send the csv file to each customer with only their data. How do I edit the csv in gmail attachment? This is the data:
“Customer”,“Monthly Budget”,“Spend to Date”,“Target Temperature”
“SunShield”,“7023”,“896.67”,“”
“CoolWave Fans”,“4349”,“680.28”,“”
“CloudNest”,“1613”,“914.61”,“”

When sent in mail everything is shared to every customer.

What change can I make in data so that each customer gets only their data?
For example gmail attachment for SunShield will have only Sunshield value.

thanks.

[LinkYourTech]

You need to use the csv module to retrieve the data in the csv. Then you’ll have to parse the data using a text parser. If done correctly you’ll have separate bundles with values for each customer you can map to the email.

Hope this helps!

[Mayur_Savaisarje]

I have already done that. I am getting data from iterator into CSV and then parsing csv then using array aggregator to pass data.