Import customers to Synerise by file upload

Published November 07, 2022
Selected Clients
eathappygroup logoempik logohouseofhackney logo

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 the Automation module to easily import a ready-to-use data base from a CSV file without any transformation.


  • 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. You can also find the general requirements for the .CSV file format here.

Example CSV file might look like this:

Important: 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. Any additional column outside this list in the API documentation will be treated as a custom client attribute.
Tip: 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 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 icon Automation > Workflows > New workflow.
  2. Enter the name of the workflow.

Define the launch date

  1. As the trigger node, add Scheduled Run.

  2. 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
    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.
Local file transfer
Local file transfer

Add import profiles node

  1. Choose Synerise node.
  2. On the Local File node, click THEN.
  3. 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.

The logs for the workflow
The logs for the workflow

Result: New imported profiles can be visible in your CRM module.

Check the use case set up on the Synerise Demo workspace

You can check the workflow configuration directly in Synerise Demo workspace.

If you don’t have access to the Synerise Demo workspace, please leave your contact details in this form, and our representative will contact you shortly.

Read more


We are sorry to hear that

Thank you for helping improve out documentation. If you need help or have any questions, please consider contacting support.



Thank you for helping improve out documentation. If you need help or have any questions, please consider contacting support.

Close modal icon Placeholder alt for modal to satisfy link checker