# Sending Zaps At this point your campaign should be set up, the design created and published, and ready for data upload. ## Uploading Data On the 'campaigns' screen you should see an option to 'Upload CSV to send Zaps'

{% hint style="info" %} If the upload icon is light grey it likely means you do not have a published design for this campaign {% endhint %} Once you have the CSV upload icon, you will be asked to select a send date for your campaign.

After choosing your send date, you will be asked to select a CSV. This will then go through validation; this includes checking header names, missing columns, missing mandatory data, etc. You will either receive a confirmation or failure to upload. {% hint style="info" %} Any blank rows in your CSV will automatically be removed upon upload. We only allow certain characters into the name and address fields. We will attempt to clean up data that does not meet the character expectations. Accented characters will be replaced by non-accented equivalents and certain UTF-8 representations of MS ANSI characters will be replaced by equivalents. All other characters will be stripped before ingestion into our system. {% endhint %} ### Field Mapping

When initially viewing field mapping, the ZAP APP will try to automatically map fields it can identify irrelevant of casing. For example, the template header expects to see Firstname, as the CSV header is First Name it is automatically mapped. For any fields that cannot be automatically mapped, you will be able to select the drop down under 'CSV Headers' to choose with field the ZAP APP should get the data from.

You will not be able to confirm your changes until, as a minimum, all mandatory fields are mapped.

Upon clicking confirm, the ZAP APP will continue validation, checking missing mandatory data and any validation requirements. You will either receive a confirmation or failure to upload.

## Data Upload (Failure) If the ZAP-APP fails to upload the CSV, you will be given two options: \ \ 1\. Ignore and continue - this will process the CSV, ignoring any failed records.\ 2\. Download and fix records - this will automatically download a failure report, highlighting which records failed and why. {% hint style="info" %} It is not recommended to choose 'Ignore and continue' {% endhint %}

After you have corrected or removed any failed records, you can upload the file again from the campaigns page. ## Null Handling If you find yourself wishing for Null to appear on one of more of your records due to being a Street Name or even a Surname, then The ZAP APP can handle 'Null' entries when it comes to CSV uploads. After uploading a CSV if the ZAP APP identifies a 'Null' record then it will be highlighted after the field mapping process.

## Data Upload (Success) Once your CSV has uploaded successfully, you will see a confirmation of upload. Upon clicking the 'Next' link in the bottom right, you will be shown a 'Campaign confirmation'. This will confirm:\ \ \&#xNAN;**- Number of Zaps**\ **- Campaign Name**\ **- Date of Send**\ **- Estimated Arrival**\ **- Zaps Used** (out of the total remaining on your account) Clicking the 'Confirm' link will save your data and campaign.

## Uploading Data using an Integration Various integrations are available to connect your data directly with ZAP-POST, these include: * Klaviyo * Hubspot * DotDigital * Patchworks For detailed information on our integrations, see our [Integration Documentation](https://integrations.zappost.com/)