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 GitHub API

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

Create Issue with GitHub API on New Item Updated (Instant) from Microsoft Excel API
Microsoft Excel + GitHub
 
Try it
Search Issues and Pull Requests with GitHub API on New Item Updated (Instant) from Microsoft Excel API
Microsoft Excel + GitHub
 
Try it
Add A Worksheet Tablerow with Microsoft Excel API on New Branch (Instant) from GitHub API
GitHub + Microsoft Excel
 
Try it
Add A Worksheet Tablerow with Microsoft Excel API on New Card in Column (Classic Projects) from GitHub API
GitHub + Microsoft Excel
 
Try it
Add A Worksheet Tablerow with Microsoft Excel API on New Collaborator (Instant) from GitHub API
GitHub + Microsoft Excel
 
Try it
New Item Updated (Instant) from the Microsoft Excel API

Emit new event when an item is updated.

 
Try it
New Branch from the GitHub API

Emit new event when a branch is created See the documentation

 
Try it
New Card in Column (Classic Projects) from the GitHub API

Emit new event when a (classic) project card is created or moved to a specific column. For Projects V2 use New Issue with Status trigger. More information here

 
Try it
New Collaborator from the GitHub API

Emit new event when a collaborator is added See the documentation

 
Try it
New Commit from the GitHub API

Emit new event when commits are pushed to a branch See the documentation

 
Try it
Add A Worksheet Tablerow with the Microsoft Excel API

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

 
Try it
Create Issue with the GitHub API

Create a new issue in a Gihub repo. See docs here

 
Try it
Search Issues and Pull Requests with the GitHub API

Find issues and pull requests by state and keyword. See docs here

 
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
Create Branch with the GitHub API

Create a new branch in a Github repo. See docs here

 
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 GitHub

The GitHub API is a powerful gateway to interaction with GitHub's vast web of data and services, offering a suite of endpoints to manipulate and retrieve information on repositories, pull requests, issues, and more. Harnessing this API on Pipedream, you can orchestrate automated workflows that respond to events in real-time, manage repository data, streamline collaborative processes, and connect GitHub with other services for a more integrated development lifecycle.

Connect GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    github: {
      type: "app",
      app: "github",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.github.com/user`,
      headers: {
        Authorization: `Bearer ${this.github.$auth.oauth_access_token}`,
        "X-GitHub-Api-Version": `2022-11-28`,
      },
    })
  },
})