AI Database

This app streamlines workflows by letting users fill a Google Form with a simple request prompt. It calls OpenAI and Gemini via API, storing their responses in dedicated fields using Markdown formatting. Relevant content is copied into a text field, and a well-formatted email is sent with the compiled results.

AI Database table structure

AI table is stored in a MySQL database

AI table columns

Request: prompt for AI engines
OpenAI: result of OpenaAI call
Gemini: result of Gemini call
Text: compiled text of the best of both responses
Subject: email subject

Google Appsheet is used for adding, editing and data visualisation.

Ask for enabling the app by filling the form.

The trial is limited to 20 AI calls using my API keys. If you need more, or want to discuss a customized private version using you own API keys, reply to the welcome email you received.

Screenshots

Responses Deck view

Edit form

Video and the step-by-step workflow generated by Google Gemini.

The video demonstrates how to use the AIDB application to generate a summary of the book "The Great Gatsby" and then send it via email.

Here's a step-by-step workflow description:

Accessing AIDB: The user navigates to the AIDB application by typing "appsheet.com" in the browser's search bar [00:03].
Viewing Existing Entries: Upon loading, the AIDB interface displays existing entries, including "Science: Size of Universe" and "Recipe: Scrambled eggs" [00:05]. The user clicks on "Recipe: Scrambled eggs" to view its details, which include ingredients, equipment, and instructions [00:07].
Adding a New Request: The user clicks the "Add" button to create a new request [00:13].
Entering Request Details: A form appears where the user types "summary of the boog great gatsby" into the "Request" field [00:16].
Saving the Request: The user clicks "Save" to add the new request to the AIDB list [00:24].
Generating the Summary: The user clicks "OpenAI" and then “Gemini”to generate the summary for "summary of the boog great gatsby" [00:28]. The generated summary of "The Great Gatsby" then appears on the right side of the screen [00:35].
Editing the Summary Details: The user clicks the "Edit" button to modify the details of the generated summary [00:42]. They change the "Subject" to "Books: Great Gatsby" and the "Text" field to "Books: Great Gatsby" [00:47].
Saving Edited Details: The user clicks "Save" to apply the changes [00:54].
Sending the Summary via Email: The user clicks the "Send Email" button [00:58].
Confirming Email Send: A confirmation message appears, and the user clicks "Send" to send the email [01:04].
Verifying Email in Gmail: The user navigates to their Gmail inbox [01:07] and opens the newly received email titled "AIDB: Books: Great Gatsby" to confirm the summary was sent successfully [01:09].