Google Cloud

The Google Cloud Platform, including BigQuery

Integrate the Google Cloud API with the Trello API

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

Create a List with Trello API on New Pub/Sub Messages from Google Cloud API
Google Cloud + Trello
 
Try it
Bigquery Insert Rows with Google Cloud API on Card Moved (Instant) from Trello API
Trello + Google Cloud
 
Try it
Create Bucket with Google Cloud API on Card Moved (Instant) from Trello API
Trello + Google Cloud
 
Try it
Create Scheduled Query with Google Cloud API on Card Moved (Instant) from Trello API
Trello + Google Cloud
 
Try it
Get Bucket Metadata [See the docs](https://googleapis.dev/nodejs/storage/latest/Bucket.html#getMetadata) with Google Cloud API on Card Moved (Instant) from Trello API
Trello + Google Cloud
 
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
Card Moved (Instant) from the Trello API

Emit new event each time a card is moved to a list.

 
Try it
BigQuery - New Row from the Google Cloud API

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

 
Try it
New Card (Instant) from the Trello API

Emit new event for each new Trello card on a board.

 
Try it
BigQuery - Query Results from the Google Cloud API

Emit new events with the results of an arbitrary query

 
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
Get Object with the Google Cloud API

Downloads an object from a Google Cloud Storage bucket, See the docs

 
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.`)
  },
})

Overview of Trello

Trello's API lets you craft workflows around managing boards, lists, cards, and users. With Pipedream, you can automate Trello tasks, like syncing cards with external databases, updating checklists, and posting notifications to other platforms. It enables seamless connection with other apps, fostering productivity by automating routine board operations, card management, and team notifications.

Connect Trello

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    trello: {
      type: "app",
      app: "trello",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.trello.com/1/members/me`,
    }, {
      token: {
        key: this.trello.$auth.oauth_access_token,
        secret: this.trello.$auth.oauth_refresh_token,
      },
      oauthSignerUri: this.trello.$auth.oauth_signer_uri,
    })
  },
})