Create spreadsheets your teams can easily collaborate on for free. Powered with an automated data processor, an AI-assisted data analyst, and 1000+ integration possibilities, Zoho Sheet makes data handling easier and more effective.
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 a new batch is completed in OpenAI. See the documentation
Emit new event when a new file is created in OpenAI. See the documentation
Creates a new row in the specified worksheet. See the documentation
The Chat API, using the gpt-3.5-turbo
or gpt-4
model. See the documentation
Summarizes text using the Chat API. See the documentation
Classify items into specific categories using the Chat API. See the documentation
Translate text from one language to another using the Chat API. 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`,
},
})
},
})
OpenAI provides a suite of powerful AI models through its API, enabling developers to integrate advanced natural language processing and generative capabilities into their applications. Here’s an overview of the services offered by OpenAI's API:
Use Python or Node.js code to make fully authenticated API requests with your OpenAI account:
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
openai: {
type: "app",
app: "openai",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.openai.com/v1/models`,
headers: {
Authorization: `Bearer ${this.openai.$auth.api_key}`,
},
})
},
})