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 message is posted in a channel
Creates a new row in the specified worksheet. See the documentation
Create a new channel in Microsoft Teams. See the docs here
Get the list of shift instances for a team. 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 Microsoft Teams API on Pipedream allows you to automate tasks, streamline communication, and integrate with other services to enhance the functionality of Teams as a collaboration hub. With this API, you can send messages to channels, orchestrate complex workflows based on Teams events, and manage Teams' settings programmatically.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
microsoft_teams: {
type: "app",
app: "microsoft_teams",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://graph.microsoft.com/v1.0/me`,
headers: {
Authorization: `Bearer ${this.microsoft_teams.$auth.oauth_access_token}`,
},
})
},
})