Turn a Google Spreadsheet into a JSON API. Connect Google sheets to CRM, API, Website, WordPress, any application or tool.
Create rows in a Google Sheet using the SheetDB API. See the documentation
Deletes the specified row(s) in a SheetDB sheet by matching a column name and value. See the documentation
Retrieves the record identified by the specified sys_id from the specified table.
Get column names of a Google Sheet using the SheetDB API. See the documentation
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.
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}`,
})
},
})
The ServiceNow API enables developers to tap into the robust capabilities of ServiceNow's IT service management platform. With the API, you can create, read, update, and delete records, manage workflows, and integrate with other services. By leveraging these capabilities, you can automate routine tasks, sync data across multiple platforms, and enhance operational efficiencies.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
servicenow: {
type: "app",
app: "servicenow",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://${this.servicenow.$auth.instance_name}.service-now.com/api/now/table/incident`,
headers: {
Authorization: `Bearer ${this.servicenow.$auth.oauth_access_token}`,
},
})
},
})