How to Keep your Folders on FTP Server and Google Drive in Sync

H
Published in: Dropbox - Google Drive

How do you connect an FTP server to your Google Drive or Dropbox for transferring files in either direction automatically?

Well, the easiest option would be to use a desktop FTP client like Cyberduck (supports Mac & Windows, free) or Transmit (Mac only, paid). These software applications can connect to all the popular cloud storage services including Google Drive, OneDrive, Dropbox and Amazon S3. They can perform a remote-to-remote sync allowing you to recursively transfer files and folders from the FTP server to any cloud service and vice versa.

The only issue with using a desktop application is that it needs to be run manually on your computer. Wouldn’t it be nice if you could set up a task that continuously monitors your Google Drive (or Dropbox or OneDrive) for new files and automatically copies them to a specified FTP server?

Transfer Files from FTP Server to Google Drive

Enter Microsoft Flow, an online automation service that lets you create automated workflows similar to Zapier and IFTTT. The free plan lets you create unlimited workflows and each workflow would run every 15 minutes. And it is the only service in town that can simultaneously talk to Google Drive, OneDrive, Dropbox and FTP /SFTP servers.

google-drive-ftp.png

Let’s create a connector that will upload a copy of the file to Google Drive whenever a file is added to Google Drive. You can similarly setup workflows to sync files from a folder in Dropbox to folder on FTP server. Or connect to Gmail and download emails to your FTP server automatically in the background.

  1. Go the Microsoft Flow Connectors page and activate the FTP (or SFTP) service.
  2. Next select the trigger that should start the workflow. In our case, we’ll choose “When a file is added to the FTP server”
  3. Specify the host address, the username and the password for your FTP server. If you are using SFTP, you may also need to specify the SSH private key and passphrase.
  4. On the next screen specify the full path of the folder on the FTP server that should be monitored for new files.
  5. Click “Add an Action” for the New step, choose Google Drive from the connector list and set the action as “Create File”
  6. Select the folder in Google Drive where the files should be saved, set the file name and file content fields from the list of available files so they match the incoming file name and content.

Save the flow and test. Also checkout the documentation page to know about the various actions and triggers available for the FTP / SFTP connectors in Mcirosoft Flow.

📮  Subscribe to our Email Newsletter for Google tips and tutorials!
Published in: Dropbox - Google Drive

Looking for something? Find here!

Meet the Author

Web Geek, Google Developer Expert
A
Amit Agarwal

Amit Agarwal is a Google Developer Expert in Google Workspace and Google Apps Script. He holds an engineering degree in Computer Science (I.I.T.) and is the first professional blogger in India. He is the developer of Mail Merge for Gmail and Document Studio. Read more on Lifehacker and YourStory

Get in touch

Google Add-ons

Do more with your Gmail and GSuite account
G

We build bespoke solutions that use the capabilities and the features of Google Workspace for automating business processes and driving work productivity.

  1. Mail Merge with Attachments
    Send personalized email to your Google Contact with a Google Sheet and Gmail
  2. Save Emails and Attachments
    Download email messages and file attachments from Gmail to your Google Drive
  3. Google Forms Email Notifications
    Send email notifications to multiple people when a new Google Form is submitted
  4. Document Studio
    Create beautiful pixel perfect documents merging data from Google Sheets and Google Forms
  5. Creator Studio for Google Slides
    Turn your Google Slides presentations into animated GIFs and videos for uploading to YouTube