SheetDB
Turn a Google Spreadsheet into a JSON API. Connect Google sheets to CRM, API, Website, WordPress, any application or tool.
Integrate the SheetDB API with the OpenAI (ChatGPT) API
Setup the SheetDB API trigger to run a workflow which integrates with the OpenAI (ChatGPT) API. Pipedream's integration platform allows you to integrate SheetDB and OpenAI (ChatGPT) remarkably fast. Free for developers.
Popular Ways to Connect SheetDB with OpenAI (ChatGPT)#
Popular SheetDB 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 SheetDB and OpenAI (ChatGPT) Actions#
Create rows in a Google Sheet using the SheetDB API. See the documentation
The Chat API, using the gpt-3.5-turbo or gpt-4 model. See docs here
Deletes the specified row(s) in a SheetDB sheet by matching a column name and value. See the documentation
Get column names of a Google Sheet using the SheetDB API. See the documentation
Overview of SheetDB#
SheetDB API turns your Google Sheets into a JSON API, enabling you to manage the content within your spreadsheet through RESTful endpoints. With Pipedream, you can harness this capability to build robust automations and workflows that interact with your spreadsheet data dynamically. Whether you're updating rows based on external triggers, syncing data to other platforms, or building a makeshift CRM, SheetDB paired with Pipedream's zero-management execution environment lets you deploy these solutions rapidly.
Connect SheetDB#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
sheetdb: {
type: "app",
app: "sheetdb",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://sheetdb.io/api/v1/${this.sheetdb.$auth.api_id}`,
})
},
})
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}`,
},
})
},
})