with quentn and Google Appsheet?
Emit new event when a campaign contact is sent. You should set up a webhook in the Quentn UI workflow builder to send a POST request to this source by drag and drop the API Send
element.
Adds a new row to a specific table in the AppSheet app. See the documentation
Deletes a specific row from a table in the AppSheet app. See the documentation
Quentn is a marketing automation platform that enables users to streamline communication with their leads and customers. With the Quentn API on Pipedream, you can automate tasks like managing contacts, sending personalized emails, and triggering actions based on customer behaviors. It allows for a more targeted approach to marketing by engaging with your audience at critical points in the customer journey, all while saving time with automated workflows.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
quentn: {
type: "app",
app: "quentn",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://${this.quentn.$auth.system_id}.${this.quentn.$auth.server_id}.quentn.com/public/api/V1/terms`,
headers: {
Authorization: `Bearer ${this.quentn.$auth.api_key}`,
},
})
},
})
The Google Appsheet API enables programmatic interactions with your custom AppSheet applications, allowing you to streamline processes, automate actions, and interlink your apps with other services. Leveraging Pipedream's powerful serverless platform, you can create workflows that react to events in real-time, automate tasks, and connect to countless other services with minimal effort. Whether you're updating datasets, syncing with external systems, or triggering complex chains of actions, combining AppSheet with Pipedream can supercharge your productivity and enhance your app's capabilities.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
google_appsheet: {
type: "app",
app: "google_appsheet",
}
},
async run({steps, $}) {
const data = {
"Action": "Find",
"Properties": `{
"Locale": "en-US",
"Selector": "Filter(Sheet1, true)",
"Timezone":
"Pacific Standard Time"
}`,
}
return await axios($, {
method: "post",
url: `https://api.appsheet.com/api/v2/apps/${this.google_appsheet.$auth.app_id}/tables/{{your_table_here}}/Action`,
headers: {
"ApplicationAccessKey": `${this.google_appsheet.$auth.access_key}`,
},
data,
})
},
})