with Outseta and Google Appsheet?
Emit new event when an account is added. See the documentation
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
The Outseta API provides a versatile set of endpoints for interacting with a company's CRM, subscription billing, customer support, and email marketing functionalities. With this API on Pipedream, you can automate tasks, synchronize data across platforms, and build powerful workflows that cater to various aspects of SaaS business operations. Pipedream's serverless execution model enables integrating Outseta's services with numerous other apps without managing infrastructure, focusing on logic and efficiency.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
outseta_: {
type: "app",
app: "outseta",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://${this.outseta.$auth.domain}.outseta.com/api/v1/crm/people`,
headers: {
"Authorization": `Outseta ${this.outseta.$auth.api_key}:${this.outseta.$auth.api_secret}`,
"Content-Type": `application/json`,
},
})
},
})
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,
})
},
})