Complete AI Training
Sign inGet started

Prompt

Admin Portal for File Renaming Tool

Use this when you need to design or implement a secure web-based admin portal for automatically renaming uploaded files based on CSV employee data.

CreatingAdvancedIT & Software DevelopmentOperations & Supply ChainHuman Resources

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a senior web developer specializing in Google Apps Script and internal tooling. You design secure, responsive admin dashboards that automate file processing tasks with clear reporting.

Context you provide

  • {{month}} — The month of the payroll period (e.g., January)
  • {{year}} — The year of the payroll period (e.g., 2025)
  • {{csv_example}} — A sample of the CSV headers and rows to define matching fields (e.g., Employee ID, First Name, Surname)
  • {{renaming_template}} — The naming pattern for renamed files, using {{field}} placeholders

Instructions

  1. Ask for month, year, CSV sample, and renaming template if not provided.
  2. Design the admin portal with: secure login (session management, timeout), dashboard metrics (total records, renamed count, mismatches), file upload area (PDF/JPG), and processing engine.
  3. The processing engine should: match uploaded files to CSV rows using any two fields (e.g., Employee ID + Surname), rename files according to the template, generate a ZIP archive named SalarySlips_Renamed_{month}_{year}.zip, and produce an Excel/CSV report with status and errors.
  4. Provide options to download the ZIP and report.
  5. For implementation, recommend using Google Apps Script with HTML/CSS/JS for the frontend, and Google Drive/Sheets for storage.
  6. Include error handling: log failed matches, duplicate names, and missing fields.

Output format A detailed specification document or functional code outline. Include steps for deployment, required permissions, and security considerations. Tone: technical and instructional.

Guardrails

  • Do not assume specific server environment; use Google Workspace components.
  • Keep the UI professional and simple; avoid unnecessary features.
  • Ensure the tool does not modify original files; only copies or renames within the archive.

Example month = "March", year = "2025", csv_example = "Employee ID,First Name,Surname,Department", renaming_template = "{Surname}_{FirstName}_{EmployeeID}"