with Zenkit and Microsoft Excel?
Emit new event when when a specific cell's value changes in an Excel worksheet
Emit new event when there is a new notification in Zenkit
Emit new event when when a new row is added to an Excel worksheet
Add a comment to an entry/item within a list/collection on Zenkit. See the docs
Adds rows to the end of specific table. See the documentation
Insert a new row into a specified Excel worksheet. See the documentation
Zenkit is a versatile project management and collaboration tool that lets you organize your data and build custom workflows to streamline your business and personal projects. With the Zenkit API, you can create, read, update, and delete items in your collections, manage users, and automate notifications or actions based on changes within your datasets. Combining Zenkit's API with Pipedream's capability unlocks powerful automation opportunities, allowing you to interconnect your project data with numerous other services and internal systems to enhance productivity, data consistency, and event-driven processes.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
zenkit: {
type: "app",
app: "zenkit",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://zenkit.com/api/v1/users/me`,
headers: {
Authorization: `Bearer ${this.zenkit.$auth.oauth_access_token}`,
},
})
},
})
The Microsoft Excel API on Pipedream allows you to automate spreadsheet tasks, manipulate data, and integrate Excel with other apps and services. Through Pipedream, you can create serverless workflows that react to events, perform operations on Excel files like reading, writing, updating cells, and managing worksheets. This API turns Excel into a powerful tool for data analysis, report generation, and task automation without manual intervention.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
microsoft_excel: {
type: "app",
app: "microsoft_excel",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://graph.microsoft.com/v1.0/me`,
headers: {
Authorization: `Bearer ${this.microsoft_excel.$auth.oauth_access_token}`,
},
})
},
})