You can use Microsoft Graph to allow web and mobile applications to read and modify Excel workbooks stored in OneDrive for Business, SharePoint site or Group drive.
Emit new event when an existing contact is created in Holded. See the docs.
Emit new event when invoice is generated in Holded. See the docs.
Adds rows to the end of specific table. See the documentation
Update the properties of tablerow object. (Only for work or school account)
See the documentation
Deliver an email with a document to a contact through Holded. See the docs.
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 Holded API offers access to a versatile platform that combines accounting, invoicing, inventory, and project management. It's designed to streamline various business processes. With Pipedream, you can connect Holded to hundreds of other apps to automate workflows. This means you can sync invoices with your CRM, get real-time alerts for new sales, or even automate inventory updates. The API's endpoints allow you to manage contacts, products, accounting, and more, enabling your business to stay organized and efficient.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
holded: {
type: "app",
app: "holded",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.holded.com/api/invoicing/v1/contacts`,
headers: {
"Accept": `application/json`,
"key": `${this.holded.$auth.api_key}`,
},
})
},
})