A Real 3 AM Wake-Up Call
Xiao Li, an operations manager at a restaurant chain in Beijing’s Chaoyang District, wakes up at 3 AM every Saturday.
He needs to download order data from Meituan, Ele.me, and Douyin (TikTok China), manually cross-check everything in Excel, and compile a weekly report for his boss. The process takes 4-5 hours, and one wrong number can trigger a cascade of problems.
This scenario plays out across hundreds of thousands of small businesses in China every single week. They don’t lack the will to go digital—they lack the ability.
And you can solve this problem using AI + Excel. That’s where your side hustle begins.
Why This Is One of the Best AI Side Hustles in 2026
Huge Market Gap: Massive Demand, Tiny Supply
China has over 180 million market entities, with 95% being micro and small businesses. These businesses share common pain points:
- Data scattered across platforms: Food delivery apps, POS systems, cash registers, social media backends
- Extremely inefficient manual processing: Hours spent each month just moving data around
- No data analysis capability: They have data but can’t interpret it or use it for decisions
They need a “one-click report generator,” not a data scientist.
And this demand is almost entirely unmet. Most Excel service providers only know basic operations. Those who combine AI + automation are extremely rare.
AI Makes It Effortless
You don’t need to know how to code. You just need:
- AI Large Language Models (ChatGPT, Claude, DeepSeek): Generate Excel formulas, SQL queries, and data cleaning scripts on demand
- DuckDB: A database engine that processes millions of rows in under 1 second, reading Excel files directly
- Excel / Google Sheets: The tools business owners already trust
The real moat isn’t technical—it’s the willingness to find this need and solve it.
Transparent Pricing, Strong Margins
| Service Type | Price Range | First Setup | Monthly Maintenance |
|---|---|---|---|
| Single report template | ¥500 - ¥1,500 ($70-$210) | 3-6 hours | — |
| Automated data pipeline | ¥800 - ¥3,000/month ($110-$420) | 6-12 hours | 1-2 hours |
| Dashboard + insight report | ¥2,000 - ¥8,000 ($280-$1,120) | 2-5 days | 2-4 hours |
Handling 3-5 clients per month easily generates ¥5,000-¥15,000/month ($700-$2,100). And once clients adopt your automated workflow, renewal rates typically exceed 85%.
5 Core Skills You Need
Skill 1: Use AI to Generate Complex Excel Formulas Instantly
The first problem most business owners face is “I don’t know how to write this formula.”
Instead of: search Baidu → read tutorials → debug manually…
Just ask AI:
“I have a sales spreadsheet with columns: Date (A), Category (B), Revenue (C). Help me write a formula that aggregates monthly sales by category and calculates month-over-month growth rate.”
AI gives you a complete solution in 3 seconds, including step-by-step instructions.
Skill 2: Use DuckDB to Process 100K+ Rows in Under 1 Second
Excel chokes past 100,000 rows. DuckDB does the same analysis in under a second:
-- Read Excel directly, no import needed
SELECT
strftime(order_date, '%Y-%m') as month,
category,
SUM(revenue) as total_sales,
COUNT(*) as order_count,
AVG(unit_price) as avg_order_value
FROM read_auto('monthly_orders.xlsx')
WHERE order_date >= '2026-01-01'
GROUP BY month, category
ORDER BY month, total_sales DESC;
This is dimensional dominance. While others are still doing VLOOKUP row by row, you’ve already completed the full analysis with SQL.
Skill 3: Build “Upload-and-Get-Report” Automated Workflows
The real value isn’t “making a report for a client”—it’s “giving the client a system where they can generate reports themselves every month with one click.”
Workflow design:
- Client exports raw data from each platform (CSV/Excel) monthly
- Uploads to your automated template folder
- Clicks “Generate Report” button
- System automatically: cleans data → analyzes → generates charts → outputs PDF/Excel
Advanced move: Use Make (formerly Integromat) or Zapier to connect platform APIs. Data auto-fetches, auto-analyzes, and auto-emails to the client. One system can serve 20+ clients with near-zero marginal cost.
Skill 4: Use AI to Generate Data Interpretations and Business Recommendations
After the report is ready, what business owners really need is: “Tell me what this means and what I should do about it.”
Let AI write the interpretation:
“Based on the following sales data, write a 300-word business analysis report including: overall trend assessment, best and worst-performing categories, anomaly alerts, and actionable recommendations for next month. Write in the tone of an experienced business consultant.”
The AI-generated content is professional and insightful—you just tweak the tone to make the client feel “this person truly understands my business.”
Skill 5: Design Clean, Actionable Dashboards
Business owners don’t need fancy charts. They need key metrics at a glance:
- Core KPI cards: Monthly revenue, order count, average order value, YoY change
- Trend line chart: 12-month sales trajectory
- Category breakdown pie chart: Sales contribution by product category
- Anomaly highlighting: Red flags for deviations that need attention
Using Excel’s conditional formatting + slicers, you can build professional dynamic dashboards.
Where to Find Clients: 4 High-Efficiency Channels
Channel 1: Local Business District Outreach (Highest Conversion)
Walk into commercial streets, wholesale markets, and restaurant districts in your city and talk to business owners:
“Boss, I notice you spend a lot of time in Excel reconciling accounts every day? I have a tool that can automate this process for you—one click and your reports are ready, for just a few hundred yuan a month.”
Key phrase: Don’t say “data analysis.” Say “save you time.” Business owners care about results, not technology.
Channel 2: Xianyu (Idle Fish) / Taobao
Search for “Excel help,” “data organization,” “report customization.” You’ll find this niche has very little competition.
Differentiation strategy:
- Emphasize “AI automation” vs. “manual work”
- Position as “build once, benefit forever”
- Pricing: Start at ¥399, gradually increase to ¥999-¥2,999 after building reviews
Channel 3: Xiaohongshu (Little Red Book) / Douyin Content
Post before-and-after case studies—the strongest trust builder:
“After building an automated report for a bubble tea shop, they discovered Wednesday afternoons had the lowest traffic. A limited-time discount campaign boosted same-day revenue by 40%.”
“Using AI to analyze 3 years of data revealed one product had the highest margin but lowest volume. After adjusting strategy, monthly profit increased by ¥20,000.”
“Used to spend 3 days per month on reports. Now it takes 30 minutes—here’s my automation workflow.”
Channel 4: Referrals from Existing Clients
Your first client often comes from someone you already know. After completing a project, actively ask for referrals:
“Mr. Wang, do any of your friends also run restaurants or retail stores? If they’re also struggling with reports, please introduce me. If it works out, I’ll treat you to a nice meal.”
Referred clients convert at 5-10x the rate of cold outreach.
Complete Case Study: From Zero to ¥8,000/Month in 90 Days
Days 1-14: Skill Development
- Install DuckDB, complete 5 exercises from the official tutorial
- Use ChatGPT to generate 3 Excel templates for different industries (restaurant, retail, services)
- Test templates with your own data to ensure stability
Days 15-30: Free Case Building
- Find 3 friends who run small businesses, offer to build their automated reports for free
- Document the entire process (tools used, problems solved, time saved)
- Ask for testimonials and referral commitments
Days 31-60: Start Charging
- List services on Xianyu, starting at ¥599
- Visit 2 local business districts for outreach
- Goal: Sign 2 paying clients
Days 61-90: Scale Up
- Solidify solutions from first two clients into universal templates
- Launch monthly subscription service (¥500-¥1,500/month)
- Acquire new clients through referrals and Xiaohongshu content
- Goal: 5 paying clients, ¥5,000-¥8,000/month
Tool Recommendation List
| Tool | Purpose | Price |
|---|---|---|
| DuckDB | Fast data analysis engine | Free & open source |
| ChatGPT / Claude / DeepSeek | AI formula generation, data interpretation | Free / Subscription |
| Excel / Google Sheets | Report presentation and interaction | Free / Subscription |
| Make (formerly Integromat) | Workflow automation orchestration | Free tier available |
| Zapier | Cross-app data synchronization | Free tier available |
| Canva | Data visualization design | Free tier available |
| Notion | Service documentation and client management | Free tier available |
Frequently Asked Questions
Q: I have no data analysis experience. Can I still do this? A: Absolutely. Your core tool is AI, not your own expertise. AI writes the formulas, generates the SQL, interprets the data—you just act as the “translator,” converting client needs into instructions AI can understand.
Q: What if the client doesn’t know how to use a computer well? A: You deliver a “idiot-proof” template. The client only needs to: ① Export raw data ② Upload to the designated folder ③ Open Excel and click “Generate.” The whole process takes under 3 minutes.
Q: How long can this side hustle last? A: As long as businesses operate, they need data reports. And since your service is subscription-based, you build stable passive income. As your client base grows, your revenue curve becomes increasingly smooth.
Q: Won’t competition increase over time? A: Currently, service providers who combine “AI + automation” are extremely rare. Most competitors only know basic Excel operations—their pricing is low but so is their efficiency. Your differentiation is crystal clear.
Q: Can I do this completely remotely? A: Yes. 90% of the work can be done online: remote consultation to understand needs → cloud collaboration to build templates → online training for clients. You just need a reliable screen-sharing tool (like Tencent Meeting).
Take Your First Step Today
- Today: Download DuckDB (duckdb.org), run your first SQL query
- This week: Use AI to generate an Excel data cleaning template
- Within 2 weeks: Find 1 friend with a small business, offer to automate their monthly reports for free
- Within 1 month: Complete your first paid case, starting at ¥599
- Within 90 days: Have 5+ stable clients, earning ¥5,000+/month
The market window won’t stay open forever. When more AI tools become available in this space, first-mover advantage will disappear. Start now—it’s easier than you think.
For the DuckDB technical content mentioned in this article, visit DuckDBLab.com to explore more AI + data analysis possibilities.