Google Cloud

The Google Cloud Platform, including BigQuery

Integrate the Google Cloud API with the Formatting API

Setup the Google Cloud API trigger to run a workflow which integrates with the Formatting API. Pipedream's integration platform allows you to integrate Google Cloud and Formatting remarkably fast. Free for developers.

[Data] Convert JSON to String with Formatting API on New Pub/Sub Messages from Google Cloud API
Google Cloud + Formatting
 
Try it
[Data] Parse JSON with Formatting API on New Pub/Sub Messages from Google Cloud API
Google Cloud + Formatting
 
Try it
[Date/Time] Add/Subtract Time with Formatting API on New Pub/Sub Messages from Google Cloud API
Google Cloud + Formatting
 
Try it
[Date/Time] Compare Dates with Formatting API on New Pub/Sub Messages from Google Cloud API
Google Cloud + Formatting
 
Try it
[Date/Time] Format with Formatting API on New Pub/Sub Messages from Google Cloud API
Google Cloud + Formatting
 
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
[Data] Convert JSON to String with the Formatting API

Convert an object to a JSON format string

 
Try it
[Data] Parse JSON with the Formatting API

Parse a JSON string

 
Try it
[Date/Time] Add/Subtract Time with the Formatting API

Add or subtract time from a given input

 
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
[Date/Time] Compare Dates with the Formatting API

Get the duration between two dates in days, hours, minutes, and seconds along with checking if they are the same.

 
Try it

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
34
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)
     
    // Creates a client from a Google service account key.
    // See https://cloud.google.com/nodejs/docs/reference/storage/1.6.x/global#ClientConfig
    const storage = new Storage({
      projectId: key.project_id,
      credentials: {
        client_email: key.client_email,
        private_key: key.private_key,
      }
    })
    
    // Uncomment this section and rename for your bucket before running this code
    // const bucketName = 'pipedream-test-bucket';
    
    await storage.createBucket(bucketName)
    console.log(`Bucket ${bucketName} created.`)
  },
})

Connect Formatting

1
2
3
4
5
6
export default defineComponent({
  async run({ steps, $ }) {
    const text = ' Hello world! ';
    return text.trim()
  },
})