File Automations with SharePoint

Movebot
Couchdrop
Published in
4 min readJan 31, 2023

--

As a modern MFT, Couchdrop has many features to help you get your files where they need to be. Couchdrop’s file automations let you move, encrypt, rename files, and more, and integrates directly with SharePoint and other storage both on-premises and in the cloud.

For example, a bank can pull financial data from a remote partner’s server, then share that information along with other relevant files for a specific team to an internal SharePoint site. It can then keep a copy in SharePoint, and then encrypt and share out the information (minus the internal docs) to a third party like analysts or auditors. And with Couchdrop, all of this can be done automatically through file automations.

With Couchdrop Automations, you can pull files from another location, including a private file server, and send files through SFTP into SharePoint and vice versa. In this tutorial, we’ll show you how to create a simple scheduled automation using SharePoint and an SFTP endpoint in Couchdrop.

Before enabling automation workflows, you’ll need to connect SharePoint to your Couchdrop account. If you need help with this, take a look at the tutorial video Couchdrop Demo SFTP to Sharepoint.

Creating a simple scheduled automation using SharePoint and SFTP

For this example, we’ll create a simple scheduled automation in Couchdrop to move files in a specific folder (hosted in a remote SFTP endpoint) into SharePoint at midnight every day, then rename the file to add a timestamp. For a full list of automation options, see the article configuring Couchdrop automations.

To start, go to the Automations tab (on the left sidebar on desktop). Then follow these steps:

  • Click Add a new automation
  • Choose “Create a scheduled workflow”
  • Name the Automation and choose when you want it to run.
  • Pick a directory to monitor. This will be the folder the files will be pulled from. This can be any Storage Integration you have connected to Couchdrop, including other cloud storage like Google Workspace or Dropbox. In this simple automation, the folder monitored is called “To Move to SharePoint’’ using Couchdrop’s hosted storage.
Setting up an SFTP to SharePoint automation in Couchdrop
Couchdrop Scheduled Automation
  • Click Actions and then click the Add action dropdown. Choose “Move File” and then choose the mounted SharePoint folder as the destination.
  • Multi-step automations are supported in Couchdrop. In this case, the file is renamed using the {EXISTING_NAME} variable and then adding the {TIMESTAMP} variable, then moved to SharePoint.
  • Click Save and Continue and add any email notifications. Check that the Summary looks right and then choose Save and Continue once more.
Couchdrop’s file automation summary showing triggers and actions for SFTP to SharePoint
Couchdrop automation summary

You can test the workflow by adding files into the folder and then going into the Workflows and clicking the three dots and choosing Run/Trigger Workflow.

SFTP to SharePoint Automation shown in the Couchdrop interface

Results

Upload a file into Hosted Storage into the folder To Move to SharePoint.

Preview of an Automation for SharePoint with SFTP
A file is uploaded into the folder with the automation

The target folder in the destination is currently empty.

Empty SharePoint Directory where SFTP will automate file transfers.
The empty target folder for the automation

Wait until the automation runs or use the Run/Trigger Workflow option in Automations to have it run immediately. Then check to see if the file moved as expected.

File in SharePoint

The SharePoint folder that was empty now has a new file in it.
The file moved into SharePoint after the Automation has run

Couchdrop Storage

Successful automation of SFTP to SharePoint
The file is no longer in Couchdrop

Success! The file was renamed and moved successfully as expected. With automations, you can automate repetitive tasks and transfer files where they need to be with ease. There are currently over 10 different file actions that can be done in Couchdrop.

A dropdown menu showing the different file actions within Couchdrop Automations for SFTP to SharePoint and other cloud storage integrations.
File actions for Couchdrop automations

Couchdrop works with multiple cloud storage providers and can move files from any supported cloud storage or on-premise platform (Windows, MacOSX or SFTP server) to SharePoint or vice versa. Multi-step automations can do complex file transfers between multiple platforms with no manual input required.

To get started with Couchdrop, register for a free 14-day trial today.

--

--