with Google Cloud and Pipefy?
Inserts rows into a BigQuery table. See the docs and for an example here
Creates a scheduled query in Google Cloud. See the documentation
Gets Google Cloud Storage bucket metadata. See the docs
Downloads an object from a Google Cloud Storage bucket, See the docs
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.
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
}
},
})
Pipefy is a platform that empowers users to streamline complex processes and workflows without the need for technical skills. With the Pipefy API, you can automate various aspects of your Pipefy environment, such as creating cards, updating fields, and managing pipelines programmatically. Use Pipedream to connect Pipefy with hundreds of other apps and orchestrate workflows that can save time, reduce errors, and enhance efficiency.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
pipefy: {
type: "app",
app: "pipefy",
}
},
async run({steps, $}) {
const data = {
"query": `{ me { name } }`,
}
return await axios($, {
method: "post",
url: `https://api.pipefy.com/graphql`,
headers: {
Authorization: `Bearer ${this.pipefy.$auth.token}`,
},
data,
})
},
})