with Zoho Sheet and Perplexity?
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
Generates a model's response for the given chat conversation. 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`,
},
})
},
})
The Perplexity API offers advanced natural language processing capabilities, enabling users to generate answers, summaries, and insights from texts. Leveraging this API on Pipedream allows for the automation of content analysis, intelligent alert systems, and dynamic data enrichment, integrating seamlessly with various data sources and services for real-time processing.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
perplexity: {
type: "app",
app: "perplexity",
}
},
async run({steps, $}) {
const data = {
"model": "mistral-7b-instruct",
"messages": [
{
"role": "system",
"content": "Be precise and concise."
},
{
"role": "user",
"content": "Can you tell me about the integration platform called Pipedream?"
}
]
}
return await axios($, {
method: "post",
url: `https://api.perplexity.ai/chat/completions`,
headers: {
Authorization: `Bearer ${this.perplexity.$auth.api_key}`,
"accept": `application/json`,
},
data,
})
},
})