Google Spreadsheets

Saggi Neumann -

SFTP To Go

SFTP To Go is a fully managed secure, scalable and reliable cloud file storage with support for the SFTP, FTPS, S3 and HTTPS protocols. It allows to share and integrate with 3rd parties using popular and secure protocols and automate data management and processing using APIs and webhooks.

  • 1-click setup and you're ready to go
  • Use your own domain
  • Integrate data without worrying about APIs and automate everything

Google Spreadsheets

Google Sheets is a cloud-based spreadsheet application that allows users to edit, organize, and analyze different types of information and enables them to collaborate in real-time, with anyone, anytime, anywhere. Google Sheets handles everything from simple task lists to data analysis with charts, filters and pivot tables.

  • Get to your spreadsheets anywhere, at any time
  • Built-in formulas, pivot tables and conditional formatting options
  • Free of charge

How does it work?

Easily create a list of files when they are uploaded to your secure cloud file storage by integrating SFTP To Go with Google Spreadsheets.

  1. Create the Google Sheet that will store the file list.
  2. In Google Apps Script, create a web app that receives the webhook payload and appends a new row to the sheet.
  3. Deploy the script as a web app and copy the web app URL.
  4. In SFTP To Go, go to Webhooks and add a new webhook.
  5. Paste the Apps Script web app URL and select the upload event.
  6. Upload a test file and confirm a new row appears in Google Sheets.

For further reading, see Apps Script web apps and how to use webhooks with SFTP To Go.