# 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 %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.zigpoll.com/tutorials/email-csv-formatting.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.