Smart Prompt Editor

Customize logic and build a professional dashboard interface.

Prompt_Architect

Core Logic

•

•Create a single index.html file that includes HTML, Tailwind CSS, and JavaScript, and build charts using . Use only CDN resources, and use mockup images from Unsplash.

•Create a code.gs file to use in Google Apps Script. The function in code.gs should send data from the sheet in Google Sheets to index.html for rendering.

•Set rendering conditions so that when running index.html, if it cannot connect to GAS, it should use predefined mockup data (dev mode). If it connects, load data from Sheets and wait 3 seconds before rendering the UI.

Visual Theme Configuration

Color Theme

#06b6d4

Charts Upgrade

Add tooltips, data labels, and markers.

Layout Refinement

Refine cards and tables for a modern look.

Layout Hierarchy

Data Architecture

Sheet Name:

sheetName

HEAD

DATA

My dataset contains multiple rows. I will provide you with the header and the first row so you can clearly understand the data structure.

Prompt 2

STRICT RULES:
- Do NOT modify, replace, or change the data source under any circumstances.
Keep the existing data flow exactly as it is, including google.script.run...() and all related logic.
- Do not add new APIs, mock data, fetch/axios calls, or generate new data structures.
Only update UI/UX, layout, styling, and visualization based on the existing data.
All charts, KPI cards, and tables must strictly use the current data without altering its structure or origin.

All cards and charts on the main dashboard page must remain completely unchanged.
Do not modify, remove, or replace any existing components in the main view.

Create new sections for the following:
  1. Orders Section
  KPI summary cards
  Line chart for trends
  Data table for detailed orders
  2. Products Section
  KPI summary cards
  Bar chart for product performance
  Data table for product details
  3. Customer Section
  KPI summary cards
  Pie chart for customer distribution/segmentation

Global Feature Requirement:
  Implement a unified filter function that supports:
  Day, Month, Year
  This filter must work consistently across ALL charts and sections.
  Chart Enhancement Requirement
  Add meaningful annotations/labels to all charts to improve data interpretation and insights.