with Zoho Sheet and Breathe?
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.
Emit new event when an existing employee is updated in Breathe. See the documentation
Emit new event when a new employee is created in Breathe. See the documentation
Creates a new row in the specified worksheet. See the documentation
Approve or reject an employee leave request in Breathe. See the documentation
Creates a new leave request for an employee in Breathe. 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`,
},
})
},
})
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
breathe: {
type: "app",
app: "breathe",
}
},
async run({steps, $}) {
return await axios($, {
url: `${this.breathe.$auth.api_url}/v1/account`,
headers: {
"x-api-key": `${this.breathe.$auth.api_key}`,
},
})
},
})