# Email CSV Formatting

When running a Zigpoll email campaign, you can upload a CSV file instead of entering email addresses manually. This lets you attach custom metadata to each recipient, which gets stored alongside their survey responses for richer reporting.

#### Creating Your CSV File

1. Open a spreadsheet tool (Excel, Google Sheets, etc.).
2. Add a column called **email**. This column is required and should contain the email addresses you want to contact.
3. Add any additional columns for metadata you want to track alongside responses.

#### Special Column Names

The following column names have special meaning in Zigpoll:

| Column Name           | Purpose                                          |
| --------------------- | ------------------------------------------------ |
| `email`               | **Required.** The recipient's email address      |
| `shopify_customer_id` | Links the response to a Shopify customer profile |
| `shopify_order_id`    | Links the response to a specific Shopify order   |

Any other columns you add will be stored as custom metadata on the participant's response.

#### Example CSV

```
email,first_name,shopify_customer_id,shopify_order_id
customer1@example.com,Jane,12345,67890
customer2@example.com,John,12346,67891
```

#### Uploading Your CSV

1. Go to **Surveys** and select your survey.
2. Click **Campaigns → Emails**.
3. Switch to the **CSV Upload** tab.
4. Upload your formatted CSV file and click **Send Email**.

{% hint style="info" %}
We recommend starting with a small test batch before sending to your full audience. This lets you verify everything looks correct before scaling up.
{% endhint %}