Automation Sample Collection

A small collection of workflow-automation samples. All code is open on GitHub (SHOW-17/ai-automation-samples).

↗ Open the GitHub repo
SAMPLE 01

CSV Sales Report Generator

Turn raw sales CSV into a chart-rich HTML report in one command

Aggregate monthly sales CSV and produce an HTML report — half-day work compressed to 30 seconds. Pure Python, single HTML output.

  • ✓1,426 rows of sample data included
  • ✓KPI cards + line/donut charts + top 10 products
  • ✓Sortable/filterable detail table
  • ✓Zero dependencies — no pip install needed
Python 3.10+Chart.js (CDN)標準ライブラリのみ
SAMPLE 02

AI Article Generator

Multi-stage pipeline: keyword → outline → section body

Beyond 'ask ChatGPT to write an article' — multi-stage pipeline: SEO outline → per-section content → formatted output. Includes bulk processor and WordPress publisher.

  • ✓3 fully-generated sample articles (4000+ chars)
  • ✓Markdown / HTML / JSON output
  • ✓Bulk CSV processor included
  • ✓Optional WordPress auto-post
Python 3.10+Anthropic SDK (optional)モックモード対応
SAMPLE 03

RSS → Social Posts Generator

Auto-generate X / Threads / note posts from RSS feeds

From RSS to summary + 3 X variants + Threads + note intro, all in one go. Copy-friendly HTML report output. Posting itself stays manual to respect platform ToS.

  • ✓Auto-enforces 140-char limit for X
  • ✓Keyword-based auto hashtagging
  • ✓Threads version with emojis (~300 chars)
  • ✓HTML report with copy buttons
Python 3.10+標準ライブラリ (xml.etree)ハッシュタグ自動付与
SAMPLE 04

Multi-site Price Monitor

Daily price tracking with threshold alerts

Periodically scrape multiple product pages, alert on threshold-exceeding changes via Slack. 30-day history visualization included. Production-ready with exponential backoff and jitter.

  • ✓5 products × 30 days of demo history
  • ✓Threshold-based change detection
  • ✓Slack Webhook integration
  • ✓Exponential backoff + jitter delays
Python 3.10+BeautifulSoup4 (optional)Slack Incoming Webhook
SAMPLE 05

Automation Consulting Templates

Hearing sheet / inventory / roadmap / proposal / minutes

Five document templates for scoping automation — hearing sheet, inventory, roadmap, proposal and minutes. Reusable as-is to sort out what should become a system.

  • ✓Pre-meeting hearing sheet (15 questions)
  • ✓Business inventory sheet with examples
  • ✓3-month roadmap template
  • ✓Proposal + meeting minutes templates
Markdown業種を選ばず再利用可MITライセンス
SAMPLE 06

Excel Monthly Report

Merge 5 store Excels into a single HQ-ready workbook

The classic 'multiple store Excels → HQ report' workflow, automated. Auto-formatted summary, per-store, per-product, and detail sheets — all styled.

  • ✓5 stores × 1 month sample input included
  • ✓Summary + per-store + per-product + detail sheets
  • ✓Auto formatting, borders, colors
  • ✓Auto-filter and frozen panes
Python 3.10+openpyxl 3.1+純Excelネイティブ
SAMPLE 07

Landing Page Templates

Salon / Cafe / Consultant — single-file LPs

Three ready-to-use landing page templates for local small businesses. Self-contained HTML+CSS+JS in a single file — drop on any host.

  • ✓Relaxation salon LP
  • ✓Cafe LP with photo menu
  • ✓Consultant LP with contact form
  • ✓Fully responsive + Schema.org
HTML5 / CSS3 / Vanilla JSSchema.org構造化データ依存ゼロ

Read the code on GitHub

Every sample in this collection is on GitHub, with example outputs. For other experiments, head back to the lab's home page.

↗ See everything on GitHub