Skip to main content

Dynamic Export - SFTP Integration

S
Written by Shakked Mishan

Use the Dynamic Export SFTP integration to securely send your Shapes data to your own SFTP server. This allows automated delivery of export files to a remote destination using the Secure File Transfer Protocol (SFTP), a secure way to transfer files over SSH.

Before you begin

  • Ensure you have access to an SFTP host (hostname, username, password or SSH key).

  • Confirm the port your SFTP host uses (default 22).

  • Ensure you have permissions to upload files to your SFTP destination.

Step 1: Open the Dynamic Export setup

  1. In Shapes, go to Account Settings → Integrations → Dynamic Export. Only a Super Admin, or an Admin with the Manage integrations permission, can set up Dynamic Export.

    Dynamic Export settings page under Account Settings, Integrations
  2. On the Dynamic Export page, click Connect to start setting up an SFTP destination.

    Connect button to start a new SFTP destination setup

Step 2: Copy the SSH public key

The Dynamic Export integration uses an SSH public key for secure authentication.

  1. In the SSH public key field, click Copy to copy the key to your clipboard.
    ​
    This is the key you'll add to your SFTP server's authorized keys so Shapes is allowed to upload files.

    SSH public key field with Copy button in the SFTP setup form

If your SFTP server requires password-based authentication instead of the SSH public key, skip adding the SSH key and use a username and password.

Step 3: Add your SFTP credentials

The SFTP connection form asks for your SFTP host, SFTP username, SFTP password and Port (optional). Complete the fields as follows:

SFTP connection form with host, username, password, and port fields

Field

What to enter

SFTP host

Your SFTP server hostname (for example, sftp.yourprovider.com)

SFTP username

The username configured on your SFTP server

SFTP password

Your SFTP password (leave blank if using SSH key only)

Port (optional)

Your SFTP port (default is 22)

Step 4: Save and test the SFTP connection

  1. Once all fields are filled out, click Connect.

  2. Shapes connects to your SFTP host to verify the credentials.


Step 5: Configure your export report

After the Dynamic Export integration connects:

  1. You receive a CSV export once a day with the default set of fields:

    • First name

    • Last name

    • Work email

      You can add, remove and remap columns yourself in the SFTP setup. Custom reports can include employee data and Time Off requests.

  2. Choose which employees are included in the export on the employees step of the setup, using the People filters. To change this selection later, click Manage on the Dynamic Export integration page and edit the employees step.

  3. A custom file name and a preferred destination folder can also be requested from your Customer Success Manager or support@shapes.co.

Running a Dynamic Export on demand

To run a Dynamic Export without waiting for the next daily run, a Super Admin, or an Admin with the Manage integrations permission, clicks Run now on the Dynamic Export integration page. Daily scheduled runs continue as usual. The page shows when the integration last ran, in your local date and time.

If you click Run now again while a request is still in progress, the request shares the existing run rather than starting a duplicate. Run now becomes available again 5 minutes after a run finishes.

Each file that Shapes sends to your SFTP server appears in Integration Activity. Activity shows one line per file.


Tips & Troubleshooting
​If the connection fails:

  • Check your host name and port.

  • Confirm SSH key or password is correct.

  • Ensure your server allows connections from Shapes.

    • If Shapes cannot connect, ask your IT team to allowlist (whitelist) IP: 44.205.116.249 so the server accepts inbound SFTP connections from Shapes.

SSH vs. Password:

If your SFTP host supports SSH public key authentication, adding the Shapes SSH public key gives secure, password-less uploads. Otherwise, provide a password. SSH uses the Secure Shell protocol to encrypt the transfer.

Permissions:

The target folder on your SFTP server must allow write permissions for the SFTP username you entered.


Good to know about the Dynamic Export SFTP integration

Failed connection:

If the SFTP connection fails, Shapes shows an error message. Check your host settings, credentials, SSH key and port.

Firewall port:

Your SFTP host must accept connections on the configured port (typically 22), so open that port in your firewall if needed.

Export frequency:

The Dynamic Export runs once a day, and the export frequency can't be changed. Use Run now for an extra export between daily runs.

Did this answer your question?