# Can Mautic bulk personalize emails to sent with column headers of a Google Sheet or CSV file?

**URL:** <https://forum.mautic.org/t/can-mautic-bulk-personalize-emails-to-sent-with-column-headers-of-a-google-sheet-or-csv-file/28503>\
**Category:** Product Support\
**Created:** [July 3, 2023, 10:41pm UTC](https://forum.mautic.org/t/can-mautic-bulk-personalize-emails-to-sent-with-column-headers-of-a-google-sheet-or-csv-file/28503 "2023-07-03T22:41:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Cookovin](https://avatars.discourse-cdn.com/v4/letter/c/f08c70/32.png) [@Cookovin](https://forum.mautic.org/u/Cookovin)\
**Post date:** [July 3, 2023, 10:41pm UTC](https://forum.mautic.org/t/can-mautic-bulk-personalize-emails-to-sent-with-column-headers-of-a-google-sheet-or-csv-file/28503/1 "2023-07-03T22:41:13Z")

</div>

I don’t use Mautic yet but I want to know if Mautic can do this:

I want to send out emails in large quantity that will need to be personalized (e.g. with First name, Last name, Company name, Job title etc. (whatever is mentioned in the column headers of the Google Sheet or CSV file) for each contact based on the column headers of a Google Sheet or a CSV file that has all the info about each contact.  
How can this be done in Mautic?  
Thank you 🏃‍♂️

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [July 4, 2023, 9:21am UTC](https://forum.mautic.org/t/can-mautic-bulk-personalize-emails-to-sent-with-column-headers-of-a-google-sheet-or-csv-file/28503/2 "2023-07-04T09:21:14Z")

</div>

Hi,  
yes, you can do this with Mautic.  
You would:

1. Create the custom fields in Mautic to correspond to your Google sheet structure  
[Manage custom fields | Mautic](https://docs.mautic.org/en/contacts/manage-custom-fields)
2. Save your Google sheet as CSV
3. Import contacts  
[Import contacts | Mautic](https://docs.mautic.org/en/contacts/import-contacts)
4. Create Email with tokens (personalization)  
[Email & Landing Page Builder | Mautic](https://docs.mautic.org/en/builders)
5. Send email.

You would need to have Mautic set up properly to make sure all cronjobs are runnig and email sending is configured.

Joey

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/1X/43c63600fe51440378769136903f1fa2a9a34102.png) [@system](https://forum.mautic.org/u/system)\
**Post date:** [July 8, 2023, 3:15pm UTC](https://forum.mautic.org/t/can-mautic-bulk-personalize-emails-to-sent-with-column-headers-of-a-google-sheet-or-csv-file/28503/3 "2023-07-08T15:15:30Z")

</div>

This topic was automatically closed 36 hours after the last reply. New replies are no longer allowed.