with Streak and Google Appsheet?
Emit new event when a box's stage is updated in a pipeline.
Emit new event when a new comment is created within a pipeline.
Emit new event when a new contact is created within a team.
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
Read existing records in a table in the AppSheet app. See the documentation
The Streak API taps into the core of Streak’s CRM functionality within Gmail, allowing users to automate interactions with pipeline data, such as leads, contacts, and sales opportunities. With Pipedream, you can harness this API to craft serverless workflows that react to events in Streak and connect with countless other services to streamline CRM tasks, sync data across platforms, or trigger communications based on pipeline changes.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
streak: {
type: "app",
app: "streak",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://www.streak.com/api/v1/users/me`,
auth: {
username: `${this.streak.$auth.api_key}`,
password: ``,
},
})
},
})
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,
})
},
})