Best ChatGPT prompts for Data Entry Keyers

Create a Python script that automates data entry into a MySQL database by connecting to the database using MySQL Connector/Python, then inserting data into a specified table based on the provided CSV file, and finally updating the database with the new data while handling any potential exceptions and ensuring data integrity.

Develop a Python function to verify and correct data entries by comparing the inputted data with the existing data in the database using a specified validation rule, and then generate an automatic correction report detailing any discrepancies found during the verification process.

Design a data visualization dashboard using Plotly and Datalib to generate and display accurate reports on customer data and sales trends based on user-defined query parameters and provide interactive filtering and sorting options to facilitate data analysis.

Create an Excel VBA Macro that automates data entry into an existing Excel spreadsheet by importing data from a CSV file, formatting the data according to specific requirements, and then populating the relevant spreadsheets with the new data while applying validation rules and handling errors as necessary.

Develop a Python function to generate an automated report summarizing customer data and sales trends using a user-defined template and data from a MySQL database, and then schedule the report to be sent via email at specified intervals using a scheduling library.