Best ChatGPT prompts for Library Assistants, Clerical

Create a Python script that takes a CSV file as input containing book titles, authors, and publication dates, and updates a digital library catalog database with the new entries, adding the books to the database in the correct order and formatting the data according to library standards.

Write a VBA script for Microsoft Excel to automate the generation of a report on book status, including the total number of books in stock, books available, and books on loan, and format the report to include charts and tables with clear labels and headers.

Develop a simple Python script that sends an email notification to library users when a book they have requested is available, using their email address and the book's title and author, and formatting the email with a clear subject line and body.

Create a Node.js script that connects to the library's API to retrieve information about book availability and sends a webhook notification to the library's administrators when a book is about to be due, including the book's title, author, and expected return date.

Design a SQL query that creates a database view to display information about books, including the book title, author, publication date, and availability status, and generates a report on the top 5 most borrowed books in the library over the past year, sorted by the number of loans.