SFTP (password-based auth)
Interact with an SFTP (SSH File Transfer Protocol) Server using a username and password for auth
Integrate the SFTP (password-based auth) API with the Google Sheets API
Setup the SFTP (password-based auth) API trigger to run a workflow which integrates with the Google Sheets API. Pipedream's integration platform allows you to integrate SFTP (password-based auth) and Google Sheets remarkably fast. Free for developers.
Popular Ways to Connect SFTP (password-based auth) with Google Sheets#
Popular SFTP (password-based auth) and Google Sheets Triggers#
Emit new events when files get created, changed or deleted from a remote directory. See the docs
Emit new events each time a row or rows are added to the bottom of a spreadsheet. To use this source with a spreadsheet in a Shared Drive, use the New Row Added (Shared Drive, Instant) source instead.
Emit new events each time a row or rows are added to the bottom of a spreadsheet in a shared drive
Emit new event each time a row or cell is updated in a spreadsheet. To use this source with a spreadsheet in a Shared Drive, use the New Updates (Shared Drive, Instant) source instead.
Emit new event each time a row or cell is updated in a spreadsheet in a shared drive
Overview of SFTP (password-based auth)#
SFTP (Secure File Transfer Protocol) is a network protocol that provides secure
file transfers over secure shell (SSH) connections. It is an extension of the
Secure Shell protocol, designed for secure file exchange between hosts. A user
can securely transfer files between systems without having to worry about
external threats, as the protocol is encrypted and authenticated.
With the SFTP API, you can build applications that securely transfer data, such
as files and documents, between two different systems. Some example
applications include:
- Secure document sharing between two systems
- Secure file synchronization between two systems
- Secure backups of data over the network
- Secure transfers of large files
- Secure uploads and downloads of data
- Media streaming between two systems
Connect SFTP (password-based auth)#
module.exports = defineComponent({
props: {
sftp_password_based_auth: {
type: "app",
app: "sftp_password_based_auth",
}
},
async run({steps, $}) {
const Client = require('ssh2-sftp-client');
const {
host,
username,
password,
} = this.sftp_password_based_auth.$auth
const config = {
host,
username,
password,
}
const sftp = new Client()
await sftp.connect(config)
this.cwd = await sftp.cwd();
return await sftp.end();
},
})
Overview of Google Sheets#
Some examples of things you can build using the Google Sheets API include:
- A web app that lets users input data into a Google Sheet
- A script that automatically updates a Google Sheet with data from another
source - A tool that generates graphs and charts from data in a Google Sheet
- A service that sends data from a Google Sheet to another API or application
Connect Google Sheets#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
google_sheets: {
type: "app",
app: "google_sheets",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://www.googleapis.com/oauth2/v1/userinfo`,
headers: {
Authorization: `Bearer ${this.google_sheets.$auth.oauth_access_token}`,
},
})
},
})
Related Videos#
Community Posts#
