Turn a Google Spreadsheet into a JSON API. Connect Google sheets to CRM, API, Website, WordPress, any application or tool.
Emit new event when a specified property is provided or updated on a company. See the documentation
Emit new event when a specified property is provided or updated on a contact. See the documentation
Emit new event when a specified property is provided or updated on a custom object.
Create rows in a Google Sheet using the SheetDB API. See the documentation
Adds a contact to a specific static list. See the documentation
Deletes the specified row(s) in a SheetDB sheet by matching a column name and value. See the documentation
Create or update a batch of contacts by its ID or email. See the documentation
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 HubSpot API enables developers to integrate into HubSpots CRM, CMS, Conversations, and other features. It allows for automated management of contacts, companies, deals, and marketing campaigns, enabling custom workflows, data synchronization, and task automation. This streamlines operations and boosts customer engagement, with real-time updates for rapid response to market changes.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
hubspot: {
type: "app",
app: "hubspot",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.hubapi.com/integrations/v1/me`,
headers: {
Authorization: `Bearer ${this.hubspot.$auth.oauth_access_token}`,
},
})
},
})