← nocodb + OpenAI (ChatGPT) integrations

Classify Items into Categories with OpenAI (ChatGPT) API on New Record in Table from nocodb API

Pipedream makes it easy to connect APIs for OpenAI (ChatGPT), nocodb and 2,000+ other apps remarkably fast.

Trigger workflow on
New Record in Table from the nocodb API
Next, do this
Classify Items into Categories with the OpenAI (ChatGPT) API
No credit card required
Intro to Pipedream
Watch us build a workflow
Watch us build a workflow
4 min
Watch now ➜

Trusted by 800,000+ developers from startups to Fortune 500 companies

Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo

Developers Pipedream

Getting Started

This integration creates a workflow with a nocodb trigger and OpenAI (ChatGPT) action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

  1. Select this integration
  2. Configure the New Record in Table trigger
    1. Connect your nocodb account
    2. Select a Workspace ID
    3. Select a Project ID
    4. Select a Table ID
    5. Configure Polling interval
  3. Configure the Classify Items into Categories action
    1. Connect your OpenAI (ChatGPT) account
    2. Optional- Configure Max Tokens
    3. Optional- Configure Temperature
    4. Optional- Configure Top P
    5. Optional- Configure N
    6. Optional- Configure Stop
    7. Optional- Configure Presence Penalty
    8. Optional- Configure Frequency Penalty
    9. Optional- Configure User
    10. Configure Items
    11. Configure Categories
  4. Deploy the workflow
  5. Send a test event to validate your setup
  6. Turn on the trigger

Details

This integration uses pre-built, source-available components from Pipedream's GitHub repo. These components are developed by Pipedream and the community, and verified and maintained by Pipedream.

To contribute an update to an existing component or create a new component, create a PR on GitHub. If you're new to Pipedream component development, you can start with quickstarts for trigger span and action development, and then review the component API reference.

Trigger

Description:Emit new event for each new record in table. [See the documentation](https://data-apis-v2.nocodb.com/#tag/Table-Records/operation/db-data-table-row-list)
Version:0.0.4
Key:nocodb-new-record

nocodb Overview

NoCodeDB offers a powerful API that allows you to build compelling web and
mobile applications without writing code. With this API, you can create robust
applications that interact with millions of users, securely store data, and
build integrations with other services. Here’s a short list of some of the
things you can do with NoCodeDB:

  • Create real-time web applications by connecting to your users via WebSockets
  • Securely store and manage data for user accounts and settings
  • Create custom APIs to extend your applications
  • Create integrations with third-party services such as Stripe, Salesforce,
    Google Drive, and Dropbox
  • Deploy on serverless infrastructure to ensure fast and reliable results
  • Create custom data models to define relationships between data
  • Create custom queries to access data in powerful ways
  • Automate tasks with serverless functions
  • Monitor application performance and security with detailed analysis
  • Extend existing applications with custom data and logic
  • Utilize modern data practices such as GraphQL and cloud storage
  • Create secure and fully compliant serverless environments
  • And more!

Trigger Code

import common from "../common/base.mjs";

export default {
  ...common,
  type: "source",
  name: "New Record in Table",
  key: "nocodb-new-record",
  description: "Emit new event for each new record in table. [See the documentation](https://data-apis-v2.nocodb.com/#tag/Table-Records/operation/db-data-table-row-list)",
  version: "0.0.4",
  dedupe: "unique",
  props: {
    ...common.props,
  },
  methods: {
    ...common.methods,
    getDataToEmit({ Id }) {
      const ts = new Date().getTime();
      return {
        id: Id,
        summary: `New record created (${Id})`,
        ts,
      };
    },
    getTimeField() {
      return "CreatedAt";
    },
  },
};

Trigger Configuration

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI and CLI.
LabelPropTypeDescription
nocodbnocodbappThis component uses the nocodb app.
Workspace IDworkspaceIdstringSelect a value from the drop down menu.
Project IDprojectIdstringSelect a value from the drop down menu.
Table IDtableIdstringSelect a value from the drop down menu.
N/Adb$.service.dbThis component uses $.service.db to maintain state between executions.
Polling intervaltimer$.interface.timer

Pipedream will poll the Nocodb API on this schedule

Trigger Authentication

nocodb uses API keys for authentication. When you connect your nocodb account, Pipedream securely stores the keys so you can easily authenticate to nocodb APIs in both code and no-code steps.

Your API key can be found in API Tokens Management within your database.
Your domain is where your app is hosted, so for https://mytable.com use mytable.com for the domain.

About nocodb

Free & open source Airtable alternative

Action

Description:Classify items into specific categories using the Chat API
Version:0.0.10
Key:openai-classify-items-into-categories

OpenAI (ChatGPT) Overview

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

Action Code

import common from "../common/common-helper.mjs";

export default {
  ...common,
  name: "Classify Items into Categories",
  version: "0.0.10",
  key: "openai-classify-items-into-categories",
  description: "Classify items into specific categories using the Chat API",
  type: "action",
  props: {
    ...common.props,
    items: {
      label: "Items",
      description: "Items to categorize",
      type: "string[]",
    },
    categories: {
      label: "Categories",
      description: "Categories to classify items into",
      type: "string[]",
    },
  },
  methods: {
    ...common.methods,
    systemInstructions() {
      return "Your goal is to categorize items into specific categories and produce ONLY JSON. The user will provide both the items and categories. Please only categorize items into the specific categories, and no others, and output ONLY JSON.";
    },
    outputFormat() {
      return "Please only categorize items into the specific categories, and no others. Output a valid JSON string — an array of objects, where each object has the following properties: item, category. Do not return any English text other than the JSON, either before or after the JSON. I need to parse the response as JSON, and parsing will fail if you return any English before or after the JSON";
    },
    userMessage() {
      return `Categorize each of the following items:\n\n${this.items.join("\n")}\n\ninto one of the following categories:\n\n${this.categories.join("\n")}\n\n${this.outputFormat()}}`;
    },
    summary() {
      return `Categorized ${this.items.length} items into ${this.categories.length} categories`;
    },
    formatOutput({
      messages, response,
    }) {
      if (!messages || !response) {
        throw new Error("Invalid API output, please reach out to https://pipedream.com/support");
      }
      const assistantResponse = response.choices?.[0]?.message?.content;
      let categorizations = assistantResponse;
      try {
        categorizations = JSON.parse(assistantResponse);
      } catch (err) {
        console.log("Failed to parse output, assistant returned malformed JSON");
      }
      return {
        categorizations,
        messages,
      };
    },
  },
};

Action Configuration

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI.

LabelPropTypeDescription
OpenAI (ChatGPT)openaiappThis component uses the OpenAI (ChatGPT) app.
Max TokensmaxTokensinteger

The maximum number of tokens to generate in the completion.

Temperaturetemperaturestring

Optional. What sampling temperature to use. Higher values means the model will take more risks. Try 0.9 for more creative applications, and 0 (argmax sampling) for ones with a well-defined answer.

Top PtopPstring

An alternative to sampling with temperature, called nucleus sampling, where the model considers the results of the tokens with top_p probability mass. So 0.1 means only the tokens comprising the top 10% probability mass are considered. We generally recommend altering this or temperature but not both.

Nninteger

How many completions to generate for each prompt

Stopstopstring[]

Up to 4 sequences where the API will stop generating further tokens. The returned text will not contain the stop sequence.

Presence PenaltypresencePenaltystring

Number between -2.0 and 2.0. Positive values penalize new tokens based on whether they appear in the text so far, increasing the model's likelihood to talk about new topics.

Frequency PenaltyfrequencyPenaltystring

Number between -2.0 and 2.0. Positive values penalize new tokens based on their existing frequency in the text so far, decreasing the model's likelihood to repeat the same line verbatim.

Useruserstring

A unique identifier representing your end-user, which can help OpenAI to monitor and detect abuse. Learn more here.

Itemsitemsstring[]

Items to categorize

Categoriescategoriesstring[]

Categories to classify items into

Action Authentication

OpenAI (ChatGPT) uses API keys for authentication. When you connect your OpenAI (ChatGPT) account, Pipedream securely stores the keys so you can easily authenticate to OpenAI (ChatGPT) APIs in both code and no-code steps.

About OpenAI (ChatGPT)

OpenAI is an AI research and deployment company with the mission to ensure that artificial general intelligence benefits all of humanity. They are the makers of popular models like ChatGPT, DALL-E, and Whisper.

More Ways to Connect OpenAI (ChatGPT) + nocodb

Add Record with nocodb API on New Fine Tuning Job Created from OpenAI (ChatGPT) API
OpenAI (ChatGPT) + nocodb
 
Try it
Delete Record with nocodb API on New Fine Tuning Job Created from OpenAI (ChatGPT) API
OpenAI (ChatGPT) + nocodb
 
Try it
Get Record (from row number) with nocodb API on New Fine Tuning Job Created from OpenAI (ChatGPT) API
OpenAI (ChatGPT) + nocodb
 
Try it
Update Record with nocodb API on New Fine Tuning Job Created from OpenAI (ChatGPT) API
OpenAI (ChatGPT) + nocodb
 
Try it
List Records in Table Matching Criteria with nocodb API on New Fine Tuning Job Created from OpenAI (ChatGPT) API
OpenAI (ChatGPT) + nocodb
 
Try it
New Record in Table from the nocodb API

Emit new event for each new record in table. See the documentation

 
Try it
New Update in Table from the nocodb API

Emit new event for each update in table. See the documentation

 
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 Record with the nocodb API

This action adds a record in a table. See the documentation

 
Try it
Delete Record with the nocodb API

This action deletes a row in a table. See the documentation

 
Try it
Get Record (from row number) with the nocodb API

This action gets a row by row Id. See the documentation

 
Try it
List Records in Table Matching Criteria with the nocodb API

This action lists all rows in a table. See the documentation

 
Try it
Update Record with the nocodb API

This action updates a record in a table. See the documentation

 
Try it

Explore Other Apps

1
-
24
of
2,000+
apps by most popular

HTTP / Webhook
HTTP / Webhook
Get a unique URL where you can send HTTP or webhook requests
Notion
Notion
Notion is a new tool that blends your everyday work apps into one. It's the all-in-one workspace for you and your team.
OpenAI (ChatGPT)
OpenAI (ChatGPT)
OpenAI is an AI research and deployment company with the mission to ensure that artificial general intelligence benefits all of humanity. They are the makers of popular models like ChatGPT, DALL-E, and Whisper.
Schedule
Schedule
Trigger workflows on an interval or cron schedule.
Google Drive
Google Drive
Google Drive is a file storage and synchronization service which allows you to create and share your work online, and access your documents from anywhere.
Google Sheets
Google Sheets
Use Google Sheets to create and edit online spreadsheets. Get insights together with secure sharing in real-time and from any device.
Filter
Filter
Specify a condition that your workflow must meet and whether you'd like to proceed or end workflow execution.
Python
Python
Anything you can do in Python can be done in a Pipedream Workflow. This includes using any of the 350,000+ PyPi packages available in your Python powered workflows.
Slack
Slack
Slack is a channel-based messaging platform. With Slack, people can work together more effectively, connect all their software tools and services, and find the information they need to do their best work — all within a secure, enterprise-grade environment.
Data Stores
Data Stores
Use Pipedream Data Stores to manage state throughout your workflows.
GitHub
GitHub
Where the world builds software. Millions of developers and companies build, ship, and maintain their software on GitHub—the largest and most advanced development platform in the world.
Formatting
Formatting
Pre-built actions to make formatting and manipulating data within your workflows easier.
Node
Node
Anything you can do with Node.js, you can do in a Pipedream workflow. This includes using most of npm's 400,000+ packages.
Airtable (OAuth)
Airtable (OAuth)
Airtable is a low-code platform to build next-gen apps. Move beyond rigid tools, operationalize your critical data, and reimagine workflows with AI.
Zoom
Zoom
Zoom is the leader in modern enterprise video communications, with an easy, reliable cloud platform for video and audio conferencing, chat, and webinars.
Google Calendar
Google Calendar
With Google Calendar, you can quickly schedule meetings and events and get reminders about upcoming activities, so you always know what’s next.
Gmail
Gmail
Gmail offers private and secure email by Google at no cost, for business and consumer accounts.
Gmail (Developer App)
Gmail (Developer App)
Private and secure email by Google at no cost, for business and consumer accounts. Use this app to connect your own developer account credentials.
Email
Email
Trigger workflows on new emails, and send emails to yourself as part of a Pipedream workflow.
Delay
Delay
Delay, pause, suspend, or have the execution of your workflow wait for as little as one millisecond, or as long as one year.
Go
Go
Anything you can do in Go, you can do in a Pipedream Workflow. You can use any of Go packages available with a simple import.
Premium
Zoom Admin
Zoom Admin
Video conferencing (includes account-level scopes) for Zoom Admins.
Twilio
Twilio
Twilio is a cloud communications platform for building SMS, Voice & Messaging applications on an API built for global scale.
Bash
Bash
Run any Bash in a Pipedream step within your workflow, including making curl requests.