Google Appsheet

With Google AppSheet, you can build powerful solutions that simplify work. No coding required.

Integrate the Google Appsheet API with the OpenAI (ChatGPT) API

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

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
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
Create Transcription (Whisper) with the OpenAI (ChatGPT) API

Transcribes audio into the input language. See docs here.

 
Try it

Overview of Google Appsheet

Appsheets is a powerful API that allows you to quickly and easily create apps
that can be used on a variety of devices, including smartphones, tablets, and
computers. With Appsheet, you can easily create apps that allow you to track
and manage your data, create reports and visualizations, and even share your
data with other users. Appsheet is also easy to use, with a simple interface
that makes it easy to get started.

Connect Google Appsheet

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    google_appsheet: {
      type: "app",
      app: "google_appsheet",
    }
  },
  async run({steps, $}) {
    const data = {
      "Action": "Find",
      "Properties": `{
          "Locale": "en-US",
          "Selector": "Filter(Sheet1, true)",
          "Timezone":
          "Pacific Standard Time"
      }`,
    }
    return await axios($, {
      method: "post",
      url: `https://api.appsheet.com/api/v2/apps/${this.google_appsheet.$auth.app_id}/tables/{{your_table_here}}/Action`,
      headers: {
        "ApplicationAccessKey": `${this.google_appsheet.$auth.access_key}`,
      },
      data,
    })
  },
})

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