Skip to main content

Importing and syncing contacts with a remote file through FTP/SFTP

❗️ Important
This integration is only available on our Enterprise plan.

In this article, we will explain how to sync a contact list on Sendinblue via an SFTP/FTP server in a matter of minutes and without a single line of code. This will help you to keep your contacts always up-to-date on Sendinblue.

Before you start

  • We currently support .csv (comma-separated values) files, i.e. each value in your file must be separated by a comma only. We don’t support semicolon or tab-separated values.
  • Your file must contain some data for you to be able to see attributes in the mapping step.
  • The following IP will be used to send information via the FTP server: 35.202.19.80. We recommend that you contact your IT department and ask them to add it to your allow list.

Setting up the FTP Contacts Integration

Add the FTP contacts integration

To get your integration up and running, you will need to perform the following steps:

  1. Click on the + icon on the top menu.
  2. Click on the Integrations tab.
  3. Select the FTP contacts integration from the Integrations page.1.png
  4. Enter an integration name as shown below.
  5. Click on Create Integration to move onto the Integration Creation page.3.png

Connect to your FTP server 

  1. To connect your remote host, fill in your credentials:
    • Host (URL or IP address),
    • Username,
    • Password,
    • Port (optional).4.png
  2. Click on Quick connect to connect to the entered FTP host. 

  3. After a few seconds, you will see a success or a failure message as a result of the connection attempt:

    • ✅  If the connection was successful, click on Continue.

    • ❗️  If your credentials are wrong, you won't be able to proceed and will have to provide the correct credentials. This error message will be displayed: "Impossible to connect to the server".
      2.png

Select a file

  1. Select the file from your remote host that you want to sync contacts with. You have to choose the following two things:5.png
    1. Select a folder: Click on the first drop-down to see the list of available folders in your FTP account. You will also see the root folder as `/`. 
      ❗️ Important
      Only the root folder and folders on the same level can be selected.
    2. Select a file: Once you have selected a folder, you can select a file from the second drop-down. You can select a .csv or .txt file.
      You can also add a new file to your FTP account and click on the refresh button on the right to refresh the list of files.
      After you provide the file and folder, an Opt-in Agreement will appear.
    3. Check the agreement box to sync contacts in the file with your Sendinblue account.
    4. Click on Continue.7.png

Map your remote file data fields with your Sendinblue contacts attributes

  1. Optional: To import your contacts as blacklisted contacts, check the Contact Blacklisting box.
    mceclip2.png
  2. Map your Sendinblue contact attributes with your FTP attributes using the drop-down lists.
  3. Click on Continue.
    11.png
💡 Good to know
If you leave out fields in the mapping process, they will not be synced within the integration. It is only mandatory to map at least an Email or SMS field. 
💡 Good to know
Sendinblue does not support boolean-type attributes for contacts to sync.

Select a Sendinblue contact list

  1. You can select an existing list or create a new one using the tabs. Your remote file contacts will be imported and synced to this list.
  2. Click on Continue.
    6.png

Set import frequency

  1. Choose how frequently the selected FTP file will be read from the server and synced with your Sendinblue list. You can specify when your files should be read and synched:
    • Specific days of the week: select the day(s) the time at which the file should be read and synched.
    • Specific day of the month: specify a single day of the month and the time at which the file should be read and synched.
      10.png
  2. Once the import frequency is set, click on Continue.

Save your integration

You're almost finished, just click on Save and Activate now. You will be redirected to the Integrations page, where you can view the newly created integration.

💡 Good to know
Click on Save and keep inactive in order to keep the integration as a draft. You can always activate it later.

8.png

Monthly quota

  • There’s a global limit on how much data, your integrations can pull or sync with. This limit is set to 100,000 tasks/month. You'll receive an email notification when you reach 80% of your monthly quota. If you exceed this limit, your integrations will be stopped and you'll receive a new email notification informing you about that.
  • To increase your monthly quota, feel free to contact our support team by creating a ticket from your account

🤔 Have a question?

If you have a question, feel free to contact our support team by creating a ticket from your account. If you don't have an account yet, you can contact us here.