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 SWAPI - Star Wars API

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

Get Film with SWAPI - Star Wars API on New Item Updated (Instant) from Microsoft Excel API
Microsoft Excel + SWAPI - Star Wars
 
Try it
New Item Updated (Instant) from the Microsoft Excel API

Emit new event when an item is updated.

 
Try it
Add A Worksheet Tablerow with the Microsoft Excel API

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

 
Try it
Get Film with the SWAPI - Star Wars API

Get a film

 
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

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 SWAPI - Star Wars

The SWAPI - Star Wars API is a treasure trove of structured data from the Star Wars universe. It's a go-to resource for fetching information about planets, spaceships, vehicles, people, films, and species from the iconic franchise. Using Pipedream, you can harness this data to create automations and workflows that trigger based on specific criteria from SWAPI. For instance, you could set up a workflow that notifies you when new data is added, enrich customer profiles with their favorite Star Wars characters, or even use it for trivia games by pulling random facts.

Connect SWAPI - Star Wars

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    swapi: {
      type: "app",
      app: "swapi",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://swapi.dev/api/films/1/`,
    })
  },
})