What do you want to automate

with SFTP (key-based auth) and Google Cloud?

Prompt, edit and deploy AI agents that connect to SFTP (key-based auth), Google Cloud 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
Upload String as File with SFTP (key-based auth) API on New Pub/Sub Messages from Google Cloud API
Google Cloud + SFTP (key-based auth)
 
Try it
Bigquery Insert Rows with Google Cloud API on New Remote Directory Watcher from SFTP (key-based auth) API
SFTP (key-based auth) + Google Cloud
 
Try it
Create Bucket with Google Cloud API on New Remote Directory Watcher from SFTP (key-based auth) API
SFTP (key-based auth) + Google Cloud
 
Try it
Create Scheduled Query with Google Cloud API on New Remote Directory Watcher from SFTP (key-based auth) API
SFTP (key-based auth) + Google Cloud
 
Try it
Get Bucket Metadata with Google Cloud API on New Remote Directory Watcher from SFTP (key-based auth) API
SFTP (key-based auth) + Google Cloud
 
Try it
New Remote Directory Watcher from the SFTP (key-based auth) API

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

 
Try it
New Pub/Sub Messages from the Google Cloud API

Emit new Pub/Sub topic in your GCP account. Messages published to this topic are emitted from the Pipedream source.

 
Try it
BigQuery - New Row from the Google Cloud API

Emit new events when a new row is added to a table

 
Try it
BigQuery - Query Results from the Google Cloud API

Emit new events with the results of an arbitrary query

 
Try it
Upload File with the SFTP (key-based auth) API

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

 
Try it
Bigquery Insert Rows with the Google Cloud API

Inserts rows into a BigQuery table. See the docs and for an example here

 
Try it
Create Bucket with the Google Cloud API

Creates a bucket on Google Cloud Storage See the docs

 
Try it
Create Scheduled Query with the Google Cloud API

Creates a scheduled query in Google Cloud. See the documentation

 
Try it
Get Bucket Metadata with the Google Cloud API

Gets Google Cloud Storage bucket metadata. See the docs

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

Overview of SFTP (key-based auth)

The SFTP (key-based auth) app on Pipedream allows you to securely transfer and manage files over a network. It uses SSH for data transfer and provides the same level of security as SSH, without requiring password authentication, making automation workflows more secure and less prone to human error. You can automate file uploads, downloads, synchronization tasks, and efficiently manage your remote files in a serverless environment. Integrating this with other Pipedream-supported apps enables you to craft powerful and secure data flow systems.

Connect SFTP (key-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: {
      type: "app",
      app: "sftp",
    }
  },
  async run({steps, $}) {
    const Client = require('ssh2-sftp-client');
    
    const { 
      host,
      username,
      privateKey,
    } = this.sftp.$auth
    
    const config = {
      host,
      username,
      privateKey,
    }
    
    const sftp = new Client()
    
    await sftp.connect(config)
    this.cwd = await sftp.cwd();
    return await sftp.end();
  },
})

Overview of Google Cloud

The Google Cloud API opens a world of possibilities for enhancing cloud operations and automating tasks. It empowers you to manage, scale, and fine-tune various services within the Google Cloud Platform (GCP) programmatically. With Pipedream, you can harness this power to create intricate workflows, trigger cloud functions based on events from other apps, manage resources, and analyze data, all in a serverless environment. The ability to interconnect GCP services with numerous other apps enriches automation, making it easier to synchronize data, streamline development workflows, and deploy applications efficiently.

Connect Google Cloud

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
31
32
33
module.exports = defineComponent({
  props: {
    google_cloud: {
      type: "app",
      app: "google_cloud",
    }
  },
  async run({steps, $}) {
    // Required workaround to get the @google-cloud/storage package
    // working correctly on Pipedream
    require("@dylburger/umask")()
    
    const { Storage } = require('@google-cloud/storage')
    
    const key = JSON.parse(this.google_cloud.$auth.key_json)
     
    const storage = new Storage({
      projectId: key.project_id,
      credentials: {
        client_email: key.client_email,
        private_key: key.private_key,
      }
    })
    
    await storage.authClient.getCredentials()
    return {
      status: "success",
      authenticated: true,
      projectId: key.project_id,
      serviceAccount: key.client_email
    }
  },
})

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