Syncing 10,000 leads/mo? Get a demo
ActiveCampaign logo
+
FTP/SFTP logo

How to connect ActiveCampaign with FTP/SFTP

Connect ActiveCampaign to FTP/SFTP with LeadsBridge

ActiveCampaign » FTP/SFTP

In this article, you'll learn how to set up the bridge and connect ActiveCampaign to FTP/SFTP using LeadsBridge.

How to set up your bridge step-by-step tutorial

Before you start

  1. Head over to the left sidebar and click on Bridges
  2. You'll be taken to the Bridges section of your account
  3. Click on the Add New button
  4. You'll be taken to the first step of the bridge creation

Step 1: Bridge's Main information

  1. Choose a name for your bridge (this will only be visible inside LeadsBridge)
  2. You may add labels to help you identify your bridge later
  3. Choose ActiveCampaign as the source for your bridge
  4. Choose FTP/SFTP as the destination
  5. Click on the Next button

Step 2: Setup your ActiveCampaign source

  1. Type in the name you'd like to call your integration
  2. Enter API URL and API Key to connect your ActiveCampaign with LeadsBridge
    1. Log into your ActiveCampaign account
    2. Click on Settings at the bottom left of the menu
    3. Settings menu will open on the right, click on Developer
    4. Copy the API Access URL and Key, then paste it inside your LeadsBridge integration page
    You can find further information in the following link:( OPEN LINK)
  3. Select the segment you'd like to use as the source for your leads
  4. Click on the Next button

ActiveCampaign now requires to setup a Webhook to send lead's information to LeadsBridge.

Copy the Webhook address that you see in this step and set this endpoint inside your ActiveCampaign settings.

How to setup the webhook on ActiveCampaign

Then follow the steps below:
  1. Log into your ActiveCampaign account
  2. Click on Settings at the bottom left of the menu
  3. Settings menu will open, click on Developer
  4. Then click on Manage Webhooks
  5. You will be redirected to the webhooks page, click Add to create a webhook.
  6. Select which list your webhook will be associated with by selecting it from the drop-down, or select All Lists, then type the name of your webhook in the Name field and paste the Webhook URL you got while creating your LeadsBridge bridge
  7. Next, check the boxes next to any action/event that will trigger your webhook
  8. Then, check the boxes next to any source that will trigger your webhook
  9. After that, click Send Sample Data on the lower left of your screen
  10. Go back into your LeadsBridge bridge setup and wait till the sample data arrives
  11. Finally, after you've received the sample data on LeadsBridge, go back into ActiveCampaign and click Add on the lower left of your screen
You can find further information in the following link: ( OPEN LINK)

In case some lead data is not being received after you’ve followed the above steps, you should set the Webhook on listening mode and trigger the Webhook with a real event so if, for example, you’ve set the Webhook to be triggered on a Contact Added event you should add a new contact in your Active Campaign account with all the information you’ll like to receive in the Bridge, this way the Webhook should be able to receive all the information you need.

Before proceeding

Please make sure to send a test lead from ActiveCampaign. This will allow us to recognize the data you'd like to pass along and offer them as presets in the next steps of the setup.

  1. When the LeadsBridge screen is saying "Waiting for New Lead...", it means that we're ready to receive your test data
  2. Go to ActiveCampaign
  3. Submit a test lead
  4. Head back to LeadsBridge and check if the information has been processed correctly
  5. Click on the Next button

Step 3: Setup your FTP/SFTP destination

  1. Type in the integration's name in the dedicated field
  2. Enter Domain, Consumer secret, Use SFTP? (Secure FTP), FTP Host, FTP Port, FTP Username, FTP Password, Root directory, Private Key, Charset, File's extension (eg. txt), Fields Separator Char, Headers row number (default 0) and Destination filename pattern to connect FTP/SFTP with LeadsBridge
  3. Some FTP/SFTP details such as host name, username and password are required for accessing your files on the server by using an FTP client. The FTP details will comprise a server address (similar to ftp.yourdomain.com), a username and a password.

    In case that you don't have, or you don't know, those details, you should contact your web hosting provider, and they will be able to give you this information.

    Usually, web hosting services provide you these details after you sign up for a web hosting package. In most cases you’ll receive your FTP/SFTP information details in the welcome email sent from your web host provider after signing up to their services.

    Below you can find a short description for each field from the FTP/SFTP integration:

    • Use SFTP This toggle will allow you to use the Secure mode (SFTP), if your FTP server implements it
    • FTP Host This is the hosting server name
    • FTP Port This is the server port, the default port for FTP is 21, and for SFTP is 22
    • FTP Username/Password Your FTP credentials, usually they're the same as your cPanel login details
    • Root Directory This is the folder in your FTP service where you would read files from or put files to. If any provided, the root dir will be used
    • Headers row number This is the row index (0 based) in which the file headers are located
    • Charset This is the charset encoding of your input files
    • File's extension This is the extensions that will be used to filter files in case you use your integration as a Source
    • Fields Separator Char The char used as separator in the CSV file
    • Destination filename pattern This value will be used to define the name of the output file in case the integration is used as Destination. You may use Date and Time patterns chars such as Y/m/d H:i:s. Notice that you should type the pattern inside square brackets, for instance [Ymd]
  4. Click on the Next button
  5. You'll now be able to select the destination segment to send your leads to
  6. You may choose to receive an email receipt for each incoming lead.
    • Type the address(es) where you'd like to receive the receipt
    • You may also modify the Subject line of the email
  7. Click on the Next button

Step 4: Fields Mapping

Here you'll be able to map your source information with your destination fields.

You'll see a field name with the destination integration's logo at the top, this indicates the name of the field on FTP/SFTP.

Underneath there's a box where you may add the information you'd like to send.

  • Check each of the FTP/SFTP fields available
  • Match the information you wish to pass along from ActiveCampaign
  • You may type the information manually and pass them as a static value
  • Use the functions to customize information like reformatting dates and times or modifying text, phone numbers and so on
  • You may also leave blank the box of a field's information you don't want to send through

Custom Fields

  1. If you'd like to add more fields, just look at the bottom of the page
  2. Head over the "Don't find a CRM custom field?" box
  3. Select the field you'd like to add from the dropdown list
  4. Click the Add Custom Field button
  5. The field will appear above
  6. Add the desired information, as you did with the other ones

Once accomplished your desired outcome, just click Next and head to the last step.

Step 5: Test

In this final step, you'll be able to send a lead from LeadsBridge to test if the configuration works properly.

  1. To create a new test lead, fill in the required information when prompted
  2. Click Test Now
  3. To test with a real lead, switch the toogle to "Test with existing lead".
  4. Click Sync Now along the lead you'd like to send
  5. If you did everything right the button will turn green, meaning your lead was synced successfully and the integration is ready
  6. Click Finish to save your settings and turn active your bridge

That's all! Congratulations.

You'll be redirected to the bridges section of your account with a green success message at the top right of the page and your bridge will now be active.

Have you got some questions?

You may want to take a look at the common questions on the respective integration's documentation.

If you have any other questions, or need help to configure your bridge from ActiveCampaign to FTP/SFTP with LeadsBridge, do not hesitate to contact our Support!