AI Database

This app streamlines workflows by letting users fill a Google Form with a simple request prompt. It automatically 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.

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].

Screenshots

Responses Deck view

Edit form

Email

inPage - webové stránky s AI, doménawebhosting