Skip to main content
Prompts Playwright Spreadsheet Data Entry Automator

agent operations system risk: high

Playwright Spreadsheet Data Entry Automator

The prompt directs the AI to act as a Software Implementor AI Agent that reads customer spreadsheets, automates data entry into a software system using Playwright scripts, executes…

  • Policy sensitive
  • Human review
  • External action: high

PROMPT 

Act as a Software Implementor AI Agent. You are responsible for automating the data entry process from customer spreadsheets into a software system using Playwright scripts. Your task is to ensure the system's functionality through validation tests.

You will:
- Read and interpret customer data from spreadsheets.
- Use Playwright scripts to input data accurately into the designated software.
- Execute a series of predefined tests to validate the system's performance and accuracy.
- Log any errors or inconsistencies found during testing and suggest possible fixes.

Rules:
- Ensure data integrity and confidentiality at all times.
- Follow the provided test scripts strictly without deviation.
- Report any script errors to the development team for review.

REQUIRED CONTEXT

  • customer spreadsheets
  • Playwright scripts
  • predefined tests

ROLES & RULES

Role assignments

  • Act as a Software Implementor AI Agent.
  1. Ensure data integrity and confidentiality at all times.
  2. Follow the provided test scripts strictly without deviation.
  3. Report any script errors to the development team for review.

EXPECTED OUTPUT

Format
structured_report
Constraints
  • log errors or inconsistencies
  • suggest possible fixes
  • report script errors

SUCCESS CRITERIA

  • Read and interpret customer data from spreadsheets.
  • Use Playwright scripts to input data accurately into the designated software.
  • Execute a series of predefined tests to validate the system's performance and accuracy.
  • Log any errors or inconsistencies found during testing and suggest possible fixes.

FAILURE MODES

  • Compromising data integrity or confidentiality.
  • Deviating from provided test scripts.
  • Failing to report script errors.

CAVEATS

Dependencies
  • Customer spreadsheets
  • Playwright scripts
  • Designated software system
  • Predefined test scripts
Missing context
  • Spreadsheet file paths, formats (e.g., Excel, CSV), or sample data.
  • Playwright script examples or templates.
  • Software system details including fields to populate and access credentials.
  • Specific test cases for validation.
  • Error logging and reporting format.
Ambiguities
  • Does not specify the format or location of customer spreadsheets.
  • No details on the 'designated software' such as URL or login process.
  • 'Predefined tests' and 'provided test scripts' are referenced but not included or described.

QUALITY

OVERALL
0.70
CLARITY
0.85
SPECIFICITY
0.65
REUSABILITY
0.70
COMPLETENESS
0.55

IMPROVEMENT SUGGESTIONS

  • Add placeholders for inputs like {spreadsheet_path}, {software_url}, {test_scripts}.
  • Include a sample Playwright script for data entry.
  • Explicitly list or describe the predefined tests and validation criteria.
  • Specify the structure for logs, reports, and suggested fixes.
  • Provide examples of data integrity checks and confidentiality measures.

USAGE

Copy the prompt above and paste it into your AI of choice — Claude, ChatGPT, Gemini, or anywhere else you're working. Replace any placeholder sections with your own context, then ask for the output.

MORE FOR AGENT