Turn a Google Spreadsheet into a JSON API. Connect Google sheets to CRM, API, Website, WordPress, any application or tool.
Emit new event immediately after a record of arbitrary object type (selected as an input parameter by the user) is deleted
Emit new event (at regular intervals) when a record of arbitrary object type (selected as an input parameter by the user) is deleted. See the docs for more information.
Emit new event when a new outbound message is received in Salesforce. See Salesforce's guide on setting up Outbound Messaging. Set the Outbound Message's Endpoint URL to the endpoint of the created source. The "Send Session ID" option must be enabled for validating outbound messages from Salesforce.
Emit new event immediately after a record of arbitrary object type (selected as an input parameter by the user) is created
Create rows in a Google Sheet using the SheetDB API. See the documentation
Adds an existing contact to an existing campaign. See Event SObject and Create Record
Deletes the specified row(s) in a SheetDB sheet by matching a column name and value. See the documentation
Adds an existing lead to an existing campaign. See Event SObject and Create Record
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 Salesforce (REST API) provides a powerful platform for creating and managing customer relationships with a wide array of features like data manipulation, querying, and complex automation. With Pipedream's serverless execution, you can create workflows that automate your sales processes, sync data with other platforms, enhance customer engagement, and trigger actions based on specific events. Dive into Salesforce data, streamline lead management, track customer interactions, and push or pull data to or from Salesforce seamlessly.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
salesforce_rest_api: {
type: "app",
app: "salesforce_rest_api",
}
},
async run({steps, $}) {
return await axios($, {
url: `${this.salesforce_rest_api.$auth.instancetype}/services/oauth2/userinfo`,
headers: {
Authorization: `Bearer ${this.salesforce_rest_api.$auth.oauth_access_token}`,
},
})
},
})