with Microsoft Excel and YouTube Data?
Emit new event when when a specific cell's value changes in an Excel worksheet
Emit new event when when a new row is added to an Excel worksheet
Emit new event when a new Excel spreadsheet is created.
Emit new event when an Excel spreadsheet is updated.
Emit new event for each new comment or reply posted to a Youtube channel (or any of its videos).
Adds rows to the end of specific table. See the documentation
Adds resources to a playlist. See the documentation for more information
Insert a new row into a specified Excel worksheet. See the documentation
Returns statistics from my YouTube Channel or by id. See the documentation for more information
Find a row by column and value in an Excel worksheet. See the documentation
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}`,
},
})
},
})
The YouTube Data API lets you incorporate functions normally executed on the YouTube website into your own website or application. You can perform operations like searching for videos, retrieving channel data, and managing playlists. When integrated with Pipedream's serverless platform, this API can be part of automations that react to events, synchronize YouTube data with other services, or generate custom reports.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
youtube_data_api: {
type: "app",
app: "youtube_data_api",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://www.googleapis.com/oauth2/v1/userinfo`,
headers: {
Authorization: `Bearer ${this.youtube_data_api.$auth.oauth_access_token}`,
},
})
},
})