Microsoft Excel

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.

Integrate the Microsoft Excel API with the Gmail (Developer App) API

Setup the Microsoft Excel API trigger to run a workflow which integrates with the Gmail (Developer App) API. Pipedream's integration platform allows you to integrate Microsoft Excel and Gmail (Developer App) remarkably fast. Free for developers.

Add A Worksheet Tablerow with Microsoft Excel API on New Attachment Received from Gmail (Developer App) API
Gmail (Developer App) + Microsoft Excel
 
Try it
Add A Worksheet Tablerow with Microsoft Excel API on New Email Received from Gmail (Developer App) API
Gmail (Developer App) + Microsoft Excel
 
Try it
Add A Worksheet Tablerow with Microsoft Excel API on New Labeled Email from Gmail (Developer App) API
Gmail (Developer App) + Microsoft Excel
 
Try it
Add A Worksheet Tablerow with Microsoft Excel API on New Sent Email from Gmail (Developer App) API
Gmail (Developer App) + Microsoft Excel
 
Try it
Add Label to Email with Gmail (Developer App) API on New Item Updated (Instant) from Microsoft Excel API
Microsoft Excel + Gmail (Developer App)
 
Try it
New Item Updated (Instant) from the Microsoft Excel API

Emit new event when an item is updated.

 
Try it
New Attachment Received from the Gmail (Developer App) API

Emit new event for each attachment in a message received. This source is capped at 100 max new messages per run.

 
Try it
New Email Received from the Gmail (Developer App) API

Emit new event when an email is received. This source is capped at 100 max new messages per run.

 
Try it
New Labeled Email from the Gmail (Developer App) API

Emit new event when a new email is labeled.

 
Try it
New Sent Email from the Gmail (Developer App) API

Emit new event for each new email sent. (Maximum of 300 events emited per execution)

 
Try it
Add A Worksheet Tablerow with the Microsoft Excel API

Adds rows to the end of specific table. See the documentation

 
Try it
Add Label to Email with the Gmail (Developer App) API

Add a label to an email message. See the docs

 
Try it
Create Draft with the Gmail (Developer App) API

Create a draft from your Google Workspace email account

 
Try it
Update Worksheet Tablerow with the Microsoft Excel API

Update the properties of tablerow object. (Only for work or school account) See the documentation

 
Try it
Download Attachement with the Gmail (Developer App) API

Download an attachment by attachmentId to the /tmp directory. See the docs

 
Try it

Overview of Microsoft Excel

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.

Connect Microsoft Excel

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
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}`,
      },
    })
  },
})

Overview of Gmail (Developer App)

By connecting your personal Gmail account to Pipedream, you'll be able to incorporate email into whatever you're building with any of the 900+ apps that are available on Pipedream.

Connect Gmail (Developer App)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    gmail_custom_oauth: {
      type: "app",
      app: "gmail_custom_oauth",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://www.googleapis.com/oauth2/v1/userinfo`,
      headers: {
        Authorization: `Bearer ${this.gmail_custom_oauth.$auth.oauth_access_token}`,
      },
    })
  },
})