Best Gemini prompts for Medical and Clinical Laboratory Technicians

Create a Google Sheets script that connects to our EHR system and flags abnormal lab results based on pre-defined criteria. The script should also send an email notification to the lab technician and physician on record. Assume the EHR system has an API for retrieving patient data, and use the following columns: Patient ID, Test Name, Result Value, Reference Range. Use the following logic: if Result Value is outside Reference Range, flag as abnormal. Also, generate a daily report of all abnormal results, including patient demographics and test information.

Using a dataset of 10,000 patient lab results, including complete blood count (CBC), basic metabolic panel (BMP), and liver function tests (LFT), create a correlation matrix to identify relationships between different test results. Use Google Data Studio to visualize the correlations and identify patterns that may indicate underlying conditions or diseases. Also, generate a list of the top 10 most correlated test pairs, along with their correlation coefficients and p-values.

Design a workflow that integrates our lab's EHR system with a clinical decision support system (CDSS) to provide real-time, evidence-based recommendations for patient care. Use Google Cloud Functions to create an API that receives patient data from the EHR system, sends it to the CDSS, and retrieves recommendations. Then, use Google Sheets to create a dashboard that displays the recommendations and allows lab technicians to document patient care decisions. Assume the CDSS has an API for retrieving recommendations, and use the following patient data: medical history, current medications, lab results.

Create a Google Docs template for generating quality control audit reports, including the following sections: introduction, methodology, results, discussion, and conclusions. Use Google Sheets to connect to our lab's quality control database and retrieve data on instrument calibration, control sample results, and proficiency testing. Then, use the data to populate the report template, including tables, figures, and text. Also, generate a summary of key findings and recommendations for quality improvement.