What do you want to automate
with SheetDB and Notion?
Prompt, edit and deploy AI agents that connect to SheetDB, Notion and 2,500+ other apps in seconds.
Trusted by 1,000,000+ developers from startups to Fortune 500 companies
Popular SheetDB and Notion Triggers#
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. See the documentation
Emit new event when a page is created or updated in the selected database. See the documentation
Emit new event when a page is created in the selected database. See the documentation
Emit new event when the selected page or one of its sub-pages is updated. See the documentation
Popular SheetDB and Notion Actions#
Create rows in a Google Sheet using the SheetDB API. See the documentation
Append new and/or existing blocks to the specified parent. See the documentation
Deletes the specified row(s) in a SheetDB sheet by matching a column name and value. See the documentation
Create a comment in a page or existing discussion thread. See the documentation
Get column names of a Google Sheet using the SheetDB API. See the documentation
Overview of SheetDB#
SheetDB API turns your Google Sheets into a JSON API, enabling you to manage the content within your spreadsheet through RESTful endpoints. With Pipedream, you can harness this capability to build robust automations and workflows that interact with your spreadsheet data dynamically. Whether you're updating rows based on external triggers, syncing data to other platforms, or building a makeshift CRM, SheetDB paired with Pipedream's zero-management execution environment lets you deploy these solutions rapidly.
Connect SheetDB#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
sheetdb: {
type: "app",
app: "sheetdb",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://sheetdb.io/api/v1/${this.sheetdb.$auth.api_id}`,
})
},
})
Overview of Notion#
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.
Connect Notion#
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`,
},
})
},
})
Trusted by 1,000,000+ developers from startups to Fortune 500 companies