With Google AppSheet, you can build powerful solutions that simplify work. No coding required.
Emit new event when a new comment is created in a page or block. See the documentation
Emit new event when a database is created. Note: Databases must be shared with your Pipedream Integtration to trigger event.
Emit new event when a page or one of its sub-pages is updated.
Adds a new row to a specific table in the AppSheet app. See the documentation
Creates and appends blocks to the specified parent. See the documentation
Deletes a specific row from a table in the AppSheet app. See the documentation
Creates a comment in a page or existing discussion thread. See the documentation
Read existing records in a table in the AppSheet app. See the documentation
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,
})
},
})
Notion's API allows for the creation, reading, updating, and deleting of pages, databases, and their contents within Notion. Using Pipedream's platform, you can build workflows that connect Notion with various other services to automate tasks such as content management, task tracking, and data synchronization. With Pipedream's serverless execution, you can trigger these workflows on a schedule, or by external events from other services, without managing any infrastructure.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
notion: {
type: "app",
app: "notion",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.notion.com/v1/users/me`,
headers: {
Authorization: `Bearer ${this.notion.$auth.oauth_access_token}`,
"Notion-Version": `2021-08-16`,
},
})
},
})