What do you want to automate

with SFTP (password-based auth) and Retool?

Prompt, edit and deploy AI agents that connect to SFTP (password-based auth), Retool and 2,500+ other apps in seconds.

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
New Remote Directory Watcher (Password Auth) from the SFTP (password-based auth) API

Emit new events when files get created, changed or deleted from a remote directory. See the docs

 
Try it
Upload File (Password Auth) with the SFTP (password-based auth) API

Uploads a file or string in UTF-8 format to the SFTP server. See the documentation

 
Try it
Integrate the SFTP (password-based auth) API with the Retool API
Setup the SFTP (password-based auth) API trigger to run a workflow which integrates with the Retool API. Pipedream's integration platform allows you to integrate SFTP (password-based auth) and Retool remarkably fast. Free for developers.

Overview of SFTP (password-based auth)

SFTP on Pipedream enables secure file management on remote servers directly from your workflows. Utilize this app to automate file uploads, downloads, and synchronization tasks between your systems and SFTP servers. Implement robust data pipelines or deploy content to web servers without manual intervention, all while maintaining a high level of security with password-based authentication.

Connect SFTP (password-based auth)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
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 Retool

Retool is a platform that makes it faster to build internal tools with a drag-and-drop interface. The Retool API allows you to programmatically manage various aspects of your Retool applications, such as triggering queries, updating apps, or retrieving data from your custom tools. In Pipedream, you can utilize this API to automate workflows between Retool and other apps, creating powerful integrations that streamline your internal processes.

Connect Retool

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    retool: {
      type: "app",
      app: "retool",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.retool.com/api/v1/resources`,
      headers: {
        Authorization: `Bearer ${this.retool.$auth.access_token}`,
        "Accept": `application/json`,
      },
    })
  },
})

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo