AI-Powered GPT Connect
3 minutes to readWith the AI-Powered GPT Connect extension, you can create dynamic prompts using fields from your tables, which are sent to an OpenAI Large Language Model for tasks like data analysis, content generation, and more. You can store AI’s responses in designated fields, enabling a wide range of use cases.
Note: The AI model is trained on data available up until a certain date.
Using AI-Powered GPT Connect
Prerequisites: Install the extension.- On the list of extensions, click Open next to AI-Powered GPT Connect.
- On the Agents screen, click Create agent.
- In the right panel that opens, enter the name of your agent.
- Select the profile for this agent. In the profile settings, you can choose which OpenAI model will be used to process the requests from this agent.
- Under Trigger, select the data source which will be monitored, and the type of event that will trigger the agent.
- In the Outgoing data items section, enter your AI prompt. You can insert parameters that the extension should use when processing the prompt. You can select a file to be analyzed by AI.
- In the Incoming data items section, select the target field of the table where you want the response to be stored.
- Click Create.
Outgoing Data Items
- AI prompt: Create a prompt with table fields for the AI model. Specify response length, value type, or if extra details should be excluded, and adjust for the destination field type (for example, max 255 characters).
- File: Include a File or Attachment data type field in the prompt to be analyzed by AI. The supported formats are: c, cpp, css, csv, doc, docx, gif, go, html, java, jpeg, jpg, js, json, md, pdf, php, pkl, png, pptx, py, rb, tar, tex, ts, txt, webp, xlsx, xml, zip.For png, jpeg, jpg, webp and non-animated gif files, the file size must not exceed 20 MB. For optimal image processing, the recommended resolution is 1024×1024 pixels or less.For other file types, the maximum allowed size is 512 MB.
Incoming Data Items
Response: Store the AI model’s response in the table field. The output received from OpenAI depends on the data type of the target field selected.AI language models
In the profile configuration for AI-Powered GPT Connect extension agents, you can choose one of the following language models to be applied:- GPT-4.1 – advanced model for high-accuracy processing, suitable for nuanced tasks involving long text or structured output.
- GPT-4.1 mini – balanced model for moderately complex tasks with faster response and lower consumption.
- GPT-4.1 nano – highly optimized for basic language tasks with minimal cost.
- GPT-4o – for processing complex requests that require high language precision and image interpretation.
- GPT-4o mini – optimized for fast performance and reduced costs on simpler requests.
Resource Usage
This extension uses two types of resources:- Integrations calls: An agent makes 3 integrations calls per task to send, receive, and log, with an additional call for each optional document of File data type (does not apply to Attachment data type).
- Credits: Caspio Credits are used for the cost of the AI service. The consumption depends on the complexity of your prompt, the size and complexity of the attached files, the selected model, and the size of the response.
Example scenario | GPT-4.1 nano | GPT-4.1 mini | GPT-4.1 | GPT-4o mini | GPT-4o |
---|---|---|---|---|---|
Request with 200 characters (40 words) | 0.02 | 0.09 | 0.45 | 0.03 | 0.5 |
Prompt plus a single-page PDF invoice | 15.05 | 15.6 | 15.91 | 16.5 | 20 |
Prompt plus a PNG image of an invoice (1286×1880 px) | 0.39 | 1.06 | 2.62 | 5.56 | 3.28 |
Response of 500 characters (100 words) | 0.03 | 0.26 | 1.06 | 0.08 | 2.1 |