Add AI directly into your Caspio applications. OpenAI GPT extension automatically processes your data through OpenAI's latest models whenever records are created or updated, then stores the AI response right back in your table. Define a prompt once, and every qualifying record gets processed automatically. Summarize support tickets as they come in. Score leads on submission. Extract key details from uploaded documents. Generate personalized follow-up messages. Flag anomalies in financial data. The AI works in the background as part of your application logic.

How it works

Choose the table the agent monitors and whether it runs when records are created or when they are updated. Write a prompt that references your table fields, then pick the field where the response is stored. Once the agent is active, every qualifying record is processed automatically in the background.

Features

• Latest GPT-5 models - Access OpenAI's most advanced reasoning and accuracy.
• Profile-level knowledge - Define persistent context, instructions, and reference files that shape how AI responds. Use this to ground responses in your domain, enforce consistency across agents, or limit AI to only your approved information.
• File processing - Include file attachments from the record in the AI request for document analysis, extraction, or summarization.
• Web search - Allow AI to pull current online information when responses need real-time data.
• Prompt preview - Test and refine prompts before activation to ensure quality results.
• Multiple agents per profile - Create different agents for different workflows, all sharing the same Knowledge base.

Compliance

Caspio's Business Associate Agreement with OpenAI already covers the OpenAI API service behind this extension, so healthcare teams get covered AI processing out of the box. There is no separate agreement to negotiate with the AI provider and no vendor review to clear before you start building.

Getting started

OpenAI GPT extension is ready to use immediately. No setup, no coding, no external accounts required. AI requests are billed through Caspio Credits, which scale with usage. Enterprise customers who need greater control over usage and billing can connect their own OpenAI account.

Resource usage

The extension utilizes two types of resources:

• Integration Calls: An agent makes 3 integration calls per task to send, receive, and log, with an additional call required for each optional file or attachment.
• Credits: AI requests consume Caspio Credits based on model selection, prompt complexity, response length, attached files, web search usage, and the temperature, Top-p, and reasoning effort settings. When knowledge files are uploaded, storage credits apply: 50 credits per GB per day (prorated, minimum 0.01 credit/day). Knowledge files also consume additional credits when used to answer prompts.

Learn more about Credit pricing or request a consultation.