Importing from SFTP to SharePoint and other cloud storage

Jayden Bartram
Sep 6 · 3 min read

Couchdrop’s managed file transfer platform provides the ability to automatically poll a location daily, weekly or monthly and pull down files to another location, as well as perform actions on these files. A scenario could be automatically pulling files from an FTP server and placing them into a SharePoint site, or pulling data from Google Drive and importing them into an Azure Blob storage bucket.

Configuring Couchdrop’s automated file import

For this scenario we will automatically pull files from an SFTP server on a daily basis and import them into a SharePoint site while appending a timestamp to the files.

Configure SFTP server

Much like any traditional SFTP server you need a hostname, port, username and either a password or private key. You can also specify a subpath.

sftp backup cloud sftp
Configuring an SFTP server with Couchdrop

Configure SharePoint Site

Simply login with OAuth, specify a document library (SharePoint configuration guide) and then either browse storage or go straight to save.

sftp to sharepoint backup
Configuring SharePoint with Couchdrop

Configure Schedular

  • Navigate to Couchdrop’s Schedular Configuration
  • Provide it a name (FTP to SharePoint)
  • Set the interval to poll
  • Specify the source path, in this case it is the SFTP mount point we configured earlier. You can also specify subfolders
  • Set the conditions, in this case any file under the SFTP destination
  • Set an action, in this case we are copying the file to SharePoint and preserving the existing name {EXISTING_NAME} while adding a timestamp {TIMESTAMP}. You can also specify further subfolders here as well.
  • Save the configuration
pulling files from an sftp server into SharePoint
Configuring Couchdrop to poll an SFTP server and pull the files into SharePoint

Enable the scheduled poll

pulling sftp files to cloud storage
Enabling the configured schedular

Results

sftp automation
Files sitting in the configured SFTP server
sharepoint sftp
Files imported into SharePoint
importing files from sftp into sharepoint google drive
Couchdrop audit log showing the events by the ‘schedular’

To perform further actions to these files you can either add more conditions (such as rename, delete file, etc.) or you can initiate another workflow using Couchdrop’s automate functionality such as routing files to their own folders or encrypting with PGP.

couchdrop ftp automation workflows
Showcasing Couchdrop Automate to perform more actions
file automation and workflows
Additional actions that can be taken

For more information or to get started head to Couchdrop’s website.

Couchdrop

Couchdrop is your cloud SFTP server and virtual file system for the cloud.

Couchdrop

Couchdrop is your cloud SFTP server. It helps you SFTP/FTP, SCP and Rsync directly into your cloud storage. Couchdrop is developer ready and offers a API and webhooks. It works with all widely used cloud storage endpoints, such as Dropbox, Box, Google Drive, Wasabi, S3, etc.

Jayden Bartram

Written by

CEO of Couchdrop and Movebot

Couchdrop

Couchdrop is your cloud SFTP server. It helps you SFTP/FTP, SCP and Rsync directly into your cloud storage. Couchdrop is developer ready and offers a API and webhooks. It works with all widely used cloud storage endpoints, such as Dropbox, Box, Google Drive, Wasabi, S3, etc.