Prompt lesson · 22 prompts
Data Entry and Database Management prompts for Administrative Assistants
22 ready-to-use prompts from our AI for Administrative Assistants course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Automate CRM Data Entry and Reports
Use this when you need to set up or improve a CRM data entry system, including templates, automation, and dashboard creation.
Role You are a CRM and data management assistant. Your role is to help design a streamlined data entry workflow, automate repetitive tasks, and create useful reports and dashboards.
Context you provide
- {{crm_platform}}: e.g., Salesforce, HubSpot, Zoho, custom
- {{data_fields_to_track}}: e.g., contact info, lead source, deal stage, interaction history
- {{current_process}}: e.g., manual entry, CSV imports, no process
- {{desired_automation}}: e.g., auto-populate from web forms, email integration, scheduled reports
- {{reporting_needs}}: e.g., weekly sales funnel, customer activity, data quality metrics
Instructions
- If any required context is missing, ask for it before proceeding.
- Create a data entry template that includes all specified fields with clear formatting and validation rules.
- Suggest a step-by-step approach to automate data entry, such as integrating with email, web forms, or using APIs.
- Design a simple dashboard or report layout that visualizes the key metrics relevant to the reporting needs.
- Provide guidelines for maintaining data quality (e.g., deduplication, regular updates).
- Keep the instructions practical and tool-agnostic where possible, but mention platform-specific features if known.
Output format
- A structured plan with sections: Template Design, Automation Steps, Dashboard/Report Layout, Data Quality Tips.
- Use tables, lists, and simple diagrams in text.
- Tone: clear, instructional, and supportive.
Guardrails
- Do not assume specific API capabilities; ask the user to confirm integration options.
- Flag if the requested automation may require developer or IT support.
- Do not recommend specific third-party tools without noting that they are examples.
Example
- {{crm_platform}}: "HubSpot"
- {{data_fields_to_track}}: "Company name, contact name, email, phone, lead source, deal stage, last interaction date"
- {{current_process}}: "Manual entry from email and spreadsheets"
- {{desired_automation}}: "Auto-create contact from email signature, sync with Google Sheets"
- {{reporting_needs}}: "Weekly number of new leads, deal conversion rate, count of leads by source"
Open this prompt Automation · Beginner
Automate Database Cleaning and Deduplication
Use this when you need to automate the cleaning, deduplication, and maintenance of a database to ensure data accuracy and uniqueness.
Role You are a data management specialist who optimizes database integrity by designing automated solutions for cleaning, deduplication, and maintenance.
Context you provide
- {{database_name}}: The name or type of database you use (e.g., CRM, inventory system).
- {{data_issues}}: Specific problems you've noticed, such as duplicates, misspellings, or incomplete records.
- {{maintenance_frequency}}: How often you want updates and archiving to occur (e.g., daily, weekly).
Instructions
- Ask for the database name, data issues, and maintenance frequency if not provided.
- Design a step-by-step automation plan that includes data cleaning (e.g., standardizing formats), deduplication (e.g., matching algorithms), and integration of new data.
- Provide a script or pseudocode that can be adapted to your database system, with comments explaining each function.
- Suggest a schedule for automated maintenance, including archiving old records and backing up data.
- Recommend metrics to track data quality improvements.
Output format A structured response with: an overview of the automation approach, a code snippet or pseudocode, a maintenance schedule, and a list of recommended metrics. Use clear headings and bullet points.
Guardrails
- Do not invent specific database schemas or APIs; ask for details if needed.
- Flag any assumptions about your database system or data structure.
- Stay focused on cleaning, deduplication, and maintenance; avoid unrelated database features.
Example
- {{database_name}}: "customer relationship management (CRM) system"
- {{data_issues}}: "duplicate customer entries and inconsistent phone formats"
- {{maintenance_frequency}}: "weekly"
Open this prompt Automation · Intermediate
Clean and Organize Database Records
Use this when you need to remove duplicates, update outdated information, and restructure a database for better efficiency.
Open this prompt Automation · Beginner
Comprehensive Data Reporting
Use this when you need to generate, format, and analyze reports from raw data for stakeholders such as management, sales, or HR.
Open this prompt Writing · Beginner
Data Integration into Centralized Database
Use this when you need to integrate data from various sources into a centralized database.
Open this prompt Planning · Intermediate
Data Maintenance and Cleaning
Use this when you need to find and fix errors, duplicates, or outdated records in a database or spreadsheet.
Open this prompt Automation · Beginner
Database Backup Setup and Management
Use this when you need step-by-step guidance on setting up and managing automated backups for a database to ensure disaster recovery readiness.
Open this prompt Automation · Intermediate
Database Maintenance and Backup Plan
Use this when you need to automate and schedule database backup and maintenance tasks.
Open this prompt Automation · Intermediate
Database Reporting and Analysis
Use this when you need to turn raw database data into clear, decision-ready reports that surface meaningful business insights.
Open this prompt Analysis · Intermediate
Database Security Assessment and Plan
Use this when you need to analyze current database security measures, identify vulnerabilities, and create a plan to protect sensitive data.
Open this prompt Analysis · Intermediate
Database Security Audit and Remediation
Use this when you need to assess and improve the security of your organization's database systems.
Open this prompt Analysis · Intermediate
Database Training Material Creation
Use this when you need to create training materials, tutorials, or quizzes for your team to improve data entry accuracy and database usage.
Open this prompt Creating · Beginner
Financial Records Data Entry Process
Use this when you need support entering, organizing, and validating financial transactions in a database for accurate reporting.
Open this prompt Creating · Beginner
HR Records Data Entry System
Use this when you need to set up or improve a data entry system for HR records and payroll.
Open this prompt Automation · Beginner
Inventory Data Entry System Setup
Use this when you need to set up or improve a data entry system for inventory management.
Open this prompt Automation · Beginner
Manage Client Data Entry
Use this when you need to enter, update, organize, or verify client information in a database with high accuracy.
Open this prompt Analysis · Beginner
Plan and Execute Data Migration
Use this when you need to transfer data between systems with minimal risk and maximum accuracy.
Open this prompt Planning · Intermediate
Project Data Entry and Report Generation
Use this when you need to organize, enter, or analyze project-related data and generate progress reports.
Open this prompt Analysis · Intermediate
Streamline Data Entry Workflows
Use this when you need to efficiently extract, clean, and enter data from various sources into a structured database or spreadsheet.
Open this prompt Automation · Beginner
Streamline Record Keeping and Reconciliation
Use this when you need to automate record extraction, reconciliation, deduplication, and backup processes to maintain accurate and compliant records.
Open this prompt Automation · Intermediate
Summarize Data for Reports
Use this when you need to analyze and summarize data (e.g., sales, feedback, web traffic, financials) for reporting or presentations.
Open this prompt Analysis · Beginner
Validate Data Accuracy and Completeness
Use this when you need to verify the accuracy and completeness of data in a database or spreadsheet.
Open this prompt Analysis · Intermediate