Smartsheet

Dynamic work & collaboration software

Integrate the Smartsheet API with the OpenAI (ChatGPT) API

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

Chat with OpenAI (ChatGPT) API on New Comment Added (Instant) from Smartsheet API
Smartsheet + OpenAI (ChatGPT)
 
Try it
Chat with OpenAI (ChatGPT) API on New Row Added (Instant) from Smartsheet API
Smartsheet + OpenAI (ChatGPT)
 
Try it
Chat with OpenAI (ChatGPT) API on New Row Deleted (Instant) from Smartsheet API
Smartsheet + OpenAI (ChatGPT)
 
Try it
Chat with OpenAI (ChatGPT) API on New Row Updated (Instant) from Smartsheet API
Smartsheet + OpenAI (ChatGPT)
 
Try it
Summarize Text with OpenAI (ChatGPT) API on New Comment Added (Instant) from Smartsheet API
Smartsheet + OpenAI (ChatGPT)
 
Try it
New Comment Added (Instant) from the Smartsheet API

Emit new event when a comment is added in a sheet.

 
Try it
New Row Added (Instant) from the Smartsheet API

Emit new event when a row is added to a sheet.

 
Try it
New Row Deleted (Instant) from the Smartsheet API

Emit new event when a row is deleted from a sheet.

 
Try it
New Row Updated (Instant) from the Smartsheet API

Emit new event when a row is upedated in a sheet.

 
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
Add Row to Sheet with the Smartsheet API

Adds a row to a sheet. See docs here

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

Classify items into specific categories using the Chat API

 
Try it
Translate Text (Whisper) with the OpenAI (ChatGPT) API

Translate text from one language to another using the Chat API

 
Try it

Overview of Smartsheet

The Smartsheet API unlocks the power of managing and automating complex workflows, directly interacting with Smartsheet's features such as sheets, rows, columns, and attachments. You can create, read, update, and delete sheets, share them with others, and extract complex data reports. Leveraging the API on Pipedream allows for seamless integration with other services for enhanced productivity and data management. Whether you're orchestrating an approval process, syncing data across platforms, or automating project tracking, the Smartsheet API pairs with Pipedream's serverless platform to build powerful, scalable, and automated workflows.

Connect Smartsheet

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: {
    smartsheet: {
      type: "app",
      app: "smartsheet",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.smartsheet.com/2.0/users/me`,
      headers: {
        Authorization: `Bearer ${this.smartsheet.$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)

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}`,
      },
    })
  },
})