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.
Popular Ways to Connect Microsoft Excel with OpenAI (ChatGPT)#
Popular Microsoft Excel and OpenAI (ChatGPT) Triggers#
Emit new event when a new file is created in OpenAI. See the documentation
Emit new event when a new fine-tuning job is created in OpenAI. See the documentation
Emit new event every time a run changes its status. See the documentation
Popular Microsoft Excel and OpenAI (ChatGPT) Actions#
Adds rows to the end of specific table. See the documentation
The Chat API, using the gpt-3.5-turbo or gpt-4 model. See docs here
Update the properties of tablerow object. (Only for work or school account) See the documentation
Classify items into specific categories using the Chat API
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#
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)#
OpenAI provides a suite of powerful AI models through its API, enabling developers to integrate advanced natural language processing and generative capabilities into their applications. Here’s an overview of the services offered by OpenAI's API:
Use Python or Node.js code to make fully authenticated API requests with your OpenAI account:
Connect OpenAI (ChatGPT)#
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}`,
},
})
},
})