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 OpenAI (ChatGPT) API

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

Chat with OpenAI (ChatGPT) API on New Item Updated (Instant) from Microsoft Excel API
Microsoft Excel + OpenAI (ChatGPT)
 
Try it
Summarize Text with OpenAI (ChatGPT) API on New Item Updated (Instant) from Microsoft Excel API
Microsoft Excel + OpenAI (ChatGPT)
 
Try it
Classify Items into Categories with OpenAI (ChatGPT) API on New Item Updated (Instant) from Microsoft Excel API
Microsoft Excel + OpenAI (ChatGPT)
 
Try it
Translate Text with OpenAI (ChatGPT) API on New Item Updated (Instant) from Microsoft Excel API
Microsoft Excel + OpenAI (ChatGPT)
 
Try it
Create Transcription with OpenAI (ChatGPT) API on New Item Updated (Instant) from Microsoft Excel API
Microsoft Excel + OpenAI (ChatGPT)
 
Try it
New Item Updated (Instant) from the Microsoft Excel API

Emit new event when an item is updated.

 
Try it
New File Created from the OpenAI (ChatGPT) API

Emit new event when a new file is created in OpenAI. See the documentation

 
Try it
New Fine Tuning Job Created from the OpenAI (ChatGPT) API

Emit new event when a new fine-tuning job is created in OpenAI. See the documentation

 
Try it
New Run State Changed from the OpenAI (ChatGPT) API

Emit new event every time a run changes its status. 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
Chat with the OpenAI (ChatGPT) API

The Chat API, using the gpt-3.5-turbo or gpt-4 model. See docs here

 
Try it
Summarize Text with the OpenAI (ChatGPT) API

Summarizes text using the Chat API

 
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
Classify Items into Categories with the OpenAI (ChatGPT) API

Classify items into specific categories using the Chat API

 
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 OpenAI (ChatGPT)

The OpenAI API is a powerful tool that provides access to a range of
high-powered machine learning models. With the OpenAI API, developers can
create products, services, and tools that enable humanizing AI experiences, and
build applications that extend the power of human language.

Using the OpenAI API, developers can create language-driven applications such
as:

  • Natural language understanding and sentiment analysis
  • Text-based search
  • Question answering
  • Dialogue systems and conversation agents
  • Intelligent text completion
  • Text summarization
  • Text classification
  • Machine translation
  • Language generation
  • Multi-factor authentication
  • Anomaly detection
  • Text analysis

Connect OpenAI (ChatGPT)

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: {
    openai: {
      type: "app",
      app: "openai",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.openai.com/v1/models`,
      headers: {
        Authorization: `Bearer ${this.openai.$auth.api_key}`,
      },
    })
  },
})