with Mailbox Power and Google Cloud?
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 Mailbox Power API enables personalized direct mail campaigns by automating the sending of physical mail, gifts, and greeting cards. This can be orchestrated directly from Pipedream's platform, leveraging the ease of serverless workflows. With this API, one can create targeted, personalized mail pieces on the fly, manage contacts, and track sent items, all programmatically. The integration potential on Pipedream also allows for syncing Mailbox Power with CRM systems, triggering mail sends based on customer actions or dates, and analyzing the impact of direct mail campaigns in conjunction with digital marketing tools.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
mailbox_power: {
type: "app",
app: "mailbox_power",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.rocketnotes.com/api/clienttether/contacts/groups`,
headers: {
"APIKEY": `${this.mailbox_power.$auth.api_key}`,
},
})
},
})
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
}
},
})