AI Database table structure
AI table is stored in a MySQL database
- 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.
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].