with Zoho Sheet and Zoho Forms?
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 when a specific form receive a new response.
Emit new event whenever a new workbook is created.
Creates a new row in the specified worksheet. See the documentation
Fetches the meta information of all the forms present in a Zoho Creator application. See the documentation
Searches for a row based on provided criteria and deletes it. See the documentation
Finds a specific row by its index and updates its content. 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`,
},
})
},
})
Zoho Forms API allows you to automate interactions with your forms and the data you collect. Leveraging Pipedream, you can harness this API to trigger workflows upon new form submissions, manipulate form entries, and sync data with other services. Pipedream’s serverless platform simplifies integrating Zoho Forms with hundreds of other apps, empowering you to create custom, scalable workflows without hosting or managing servers.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
zoho_forms: {
type: "app",
app: "zoho_forms",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://forms.zoho.com/api/zforms?zf_service=Pipedream`,
headers: {
"Authorization": `Zoho-oauthtoken ${this.zoho_forms.$auth.oauth_access_token}`,
},
})
},
})