with Pipedrive and Microsoft Excel?
Adds a new activity. Includes more_activities_scheduled_in_context
property in response's additional_data
which indicates whether there are more undone activities scheduled with the same deal, person or organization (depending on the supplied data). See the Pipedrive API docs for Activities here. For info on adding an activity in Pipedrive
Adds rows to the end of specific table. See the documentation
Insert a new row into a specified Excel worksheet. See the documentation
Pipedrive API on Pipedream allows you to create powerful sales automation and data management workflows. With access to Pipedrive's CRM capabilities, you can automate deal updates, contact management, and sales reporting. Whether you're syncing customer information across platforms or triggering actions based on deal stages, Pipedream makes these integrations seamless.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
pipedrive: {
type: "app",
app: "pipedrive",
}
},
async run({steps, $}) {
return await axios($, {
url: `${this.pipedrive.$auth.api_domain}/users/me`,
headers: {
Authorization: `Bearer ${this.pipedrive.$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}`,
},
})
},
})