Importing your customer database to Synerise is a great way to get started with your email marketing efforts, as it will allow you to immediately start building relationships with your customers. In this use case, we will focus on how to use Automation Hub to easily import a ready-to-use data base from a CSV file without any transformation. ## Prerequisites --- - Create a CSV file with your customer database. You can add a few basic columns: `firstName,lastName,email`. Prepare your file based on [this document](/docs/automation/actions/synerise-integrations/import-customers). You can also find the general requirements for the `.CSV` file format [here](/docs/assets/catalogs/creating-catalogs#requirements). **Example CSV file might look like this:** ``` firstName,lastName,email, Dwight,Addams,dwight.addams@test.com, Martin,Smith,martin.smith@test.com, Kurt,Doe,kurt.doe@test.com, John,Smith,john.smith@website.com, ```

If you decide to import without a transformation diagram (without data transformation), it is very important to name the columns in the file appropriately, because they will later be connected with client's attributes. The column names should correspond with the API fields [described here](https://developers.synerise.com/ProfileManagement/ProfileManagement.html#operation/BatchAddOrUpdateClients). Any additional column outside this list in the API documentation will be treated as a custom client attribute.

If you are importing a newsletter database, apart from the email attribute, we suggest that you should also add columns with a marketing agreement called `agreements.email` with a value `1` or `0`.

## Prepare a workflow --- The scenario for this use case involves a one-time import of `.csv` file with a customer database directly to Synerise. 1. Go to

**Automation Hub > Workflows > New workflow**. 2. Enter the name of the workflow. ### Define the launch date 3. As the trigger node, add **Scheduled Run**. 4. In the configuration of the node: 1. Change the **Run trigger** option to **one time**. 2. Select **Immediately**. 3. Confirm by clicking **Apply**.

The configuration of the Scheduled Run node

### Select file to import 1. Add a **Local File** node. 2. In the configuration of the node: 1. Upload the file. 2. Confirm by clicking **Apply**.

### Add Import Profiles node 1. Choose **Synerise** node. 1. On the **Local File** node, click **THEN**. 2. From the list that opens, select **Synerise > Import Profiles**. ### Add the finishing node 1. Add the **End** node. 2. In the upper right corner, click **Save & Run**.

The workflow configuration — Imported profile

You can monitor the flow of the workflow in the **Transformation logs** tab. It contains information about each execution of the workflow.

**Result:** New imported profiles can be visible in **Behavioral Data Hub > Profiles**. ## Check the use case set up on the Synerise Demo workspace --- You can check the [workflow configuration](https://app.synerise.com/automations/automation-diagram/9c4e1942-6751-45b7-b783-ee1389f59ab2) directly in Synerise Demo workspace. If you’re our partner or client, you already have automatic access to the **Synerise Demo workspace (1590)**, where you can explore all the configured elements of this use case and copy them to your workspace. If you’re not a partner or client yet, we encourage you to fill out the contact [form](https://demo.synerise.com/request) to schedule a meeting with our representatives. They’ll be happy to show you how our demo works and discuss how you can apply this use case in your business. ## Read more --- - [Automation Hub](/docs/automation) - [Behavioral Data Hub](/docs/crm)