How to download multiple files and folders from SFTP to a SharePoint folder

In 2026.2 there is support in Flow automations for SFTP Directory which I haven’t yet used but it seems to have super potential

Otherwise in the FME Form workbench you need to build a workspace and install Putty

Using a Private SSH key with FTPCaller to Authenticate an SFTP Connection for FME Form and FME Flow on Windows Systems – FME Support Center 

FTPCaller supports SFTP, but for .ppk authentication it relies on an SSH agent such as PuTTY Pageant or ssh-agent rather than directly specifying the .ppk file in the transformer

You sFTP provider will need to add something there side

One tip with putty if to use SystemCaller with clean up task       taskkill /IM pageant.exe /F 

FTPCaller or SystemCaller (WinSCP sync entire SFTP folder)

↓

SystemCaller (cleanup)

↓

Directory and File Path Reader (using the download path from the FTPcaller)

↓

SharePointOnlineConnector with upload action, perhaps the initator attribute fme_dataset or path_windows

Writing files in SharePointOnline will require you to work with your Azure Administrator to register an app with ReadWrite.All scope

Getting Started with Microsoft SharePoint – FME Support Center

then dive into all the steps here How to Create a SharePoint Online Single Tenant Web Connection – FME Support Center