with Zoho Sheet and Neon?
Emit new event whenever a row is added or modified.
Emit new event each time a new row is created in a Zoho Sheet worksheet.
Emit new event whenever a new workbook is created.
Creates a new row in the specified worksheet. See the documentation
Searches for a row based on provided criteria and deletes it. See the documentation
The Zoho Sheet API allows you to manipulate spreadsheet data programmatically. Imagine harnessing this functionality within Pipedream's ecosystem, where you can automate data flows, sync information across platforms, and generate reports with ease. With Pipedream, you can trigger workflows using events from numerous apps, fetch or push data to Zoho Sheet, analyze or transform this data, and even automate notifications based on the results.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
zoho_sheet: {
type: "app",
app: "zoho_sheet",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://sheet.${this.zoho_sheet.$auth.base_api_uri}/api/v2/workbooks`,
headers: {
"Authorization": `Zoho-oauthtoken ${this.zoho_sheet.$auth.oauth_access_token}`,
},
params: {
method: `workbook.list`,
},
})
},
})
The Neon API provides powerful interaction with Neon's infrastructure, which includes secure handling of API keys and other sensitive data. On Pipedream, you can leverage these capabilities to automate workflows around key management, data security, and infrastructure scaling. By connecting the Neon API with other services and apps, you can create automatic processes for issuing, rotating, and monitoring API keys, ensuring your applications maintain robust security and compliance without manual oversight.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
neon_api_keys: {
type: "app",
app: "neon_api_keys",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://console.neon.tech/api/v2/projects`,
headers: {
Authorization: `Bearer ${this.neon_api_keys.$auth.api_key}`,
"Accept": `application/json`,
"Content-Type": `application/json`,
},
})
},
})