Instead of letting your daily counter sales and WhatsApp orders sit jumbled in a notebook, you can paste that raw data into an AI to instantly clean up your numbers. This simple workflow will help you build visual dashboards, spot buying trends, and create a step-by-step strategy to scale your high-margin online sales. The Prompts 1. The Data Cleaner Prompt Role: Senior Data Analyst & Retail Operations Specialist. Task: Parse, clean, and standardize unstructured retail sales data into a structured format. Context: I have raw, messy sales records from my retail business tracking two primary revenue channels: in-store (counter) and online (WhatsApp orders). Input Data: [PASTE YOUR RAW / UNORGANIZED DATA HERE] Instructions: 1. Extract and clean all transaction records. Group them by month. 2. Create standard columns: Period, Counter Sales, WhatsApp Sales, Total Revenue, and WhatsApp Share %. 3. Highlight any anomalies or missing dates. 4. Output the cleaned data in a neat Markdown table and a downloadable CSV code block. 2. The Deep Analysis Prompt 2.. The CFO Role: Chief Financial Officer (CFO) & Retail Strategist. Task: Perform data mining and trend analysis on multi-channel sales performance. Dataset: [PASTE THE CLEANED TABLE FROM PROMPT 1 HERE] Instructions: 1. Channel Shift Analysis: Calculate the month-over-month growth rate for both counter and WhatsApp sales. 2. Seasonality & Trend Detection: Identify slump months and whether dips in counter sales correlate with spikes in WhatsApp orders. 3. Root Cause Analysis: Outline the probable customer behavior factors driving these changes (e.g., convenience, delivery preferences). 4. Output the results using clear executive headings, metric callouts, and bullet-pointed diagnostic insights. 3. The Visual Dashboard Prompt (Best for Claude) 3.. The data Visualizer Role: Full-Stack Data Visualization Specialist. Task: Build an interactive React dashboard component using Tailwind CSS and Recharts inside Claude Artifacts.

The exact prompt I used to build my Gemini Spark money system (steal it) A lot of you asked for the actual prompt from the video; here it is, word for word. Paste this into Gemini Spark, connect your Gmail, and it'll build you a full 3-tab Google Sheet: Expenses, Investments, and a monthly Big Picture with your savings and investment rate. Prompt Go through my Gmail from the last 3 months. I want a complete picture of my money — what came in, what went out, and what I invested. Create ONE new Google Sheet called "My Money — Last 3 Months" with THREE tabs. ──────────────────────────── TAB 1 — "Expenses" ──────────────────────────── Every email showing money actually spent: order confirmations, payment receipts, invoices I paid, subscription renewals, UPI and card debit alerts, and bill payments. Columns: Date | Merchant | Amount (INR) | Category | Payment method | Recurring? (Yes/No/Not sure) | Gmail link Categories: Food & delivery, travel, shopping, bills & utilities, subscriptions, business, other. At the bottom: total per category, then a separate list of every recurring merchant with its monthly amount. Do NOT put investments in this tab. ──────────────────────────── TAB 2 — "Investments" ──────────────────────────── Money I put away, not money I spent. Look for: mutual fund and SIP confirmations, CAMS or KFintech statements, stock or broker contract notes, FD and RD confirmations, PPF or NPS contributions, gold or crypto purchases, and insurance premiums with an investment component. Columns: Date | Platform/Fund name | Type | Amount (INR) | SIP or one-time | Gmail link Types: Mutual fund, stocks, FD/RD, PPF/NPS, gold, crypto, insurance, and other. At the bottom: total invested per type, and a list of every active SIP with its monthly amount and date. ──────────────────────────── TAB 3 — "The Big Picture" ──────────────────────────── A monthly comparison. One row per month, plus a total row. Columns: Month | Income found | Spent | Invested | Left over | Savings rate % | Investment rate %