Email CSV Formatting

Format your CSV file correctly for Zigpoll email campaigns

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
[email protected],Jane,12345,67890
[email protected],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.

circle-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.

Last updated