Create Spreadsheet App CLI

A command-line tool to generate advanced spreadsheet applications with Express, JavaScript, and Google Sheets integration.

Features

• 🚀 Quick Setup: Generate a complete Express.js application in seconds
• 📊 Google Sheets Integration: Built-in Google Sheets API integration
• 🔒 Security First: Includes Helmet, CORS, rate limiting, compression, and logging
• 📝 Minimal Boilerplate: Only essential middleware and error handling
• ☁️ Deployment Ready: Compatible with Vercel and Render

Installation

Using npx (Recommended - No Installation Required)

npx create-spreadsheet-app create my-app

Global Installation (Alternative)

npm install -g create-spreadsheet-app
create-spreadsheet-app create my-app

Usage

cd my-app
npm install
cp .env.example .env
# Edit .env with your Google Sheets credentials
npm run dev

What's Included

• Express.js: Modern, minimal server
• Google Sheets API: CRUD integration
• helmet, cors, morgan, compression, express-rate-limit: Security and performance
• Error handling: Centralized, plain JavaScript
• Validation: (Optional) Zod support for request validation

Project Structure

my-app/
├── config/
│   └── sheet.config.js      # Google Sheets configuration (plain JS)
├── middlewares/
│   ├── error.middleware.js  # Error handling middleware (plain JS)
│   └── validate.middleware.js # Request validation (plain JS, optional)
├── routes/
│   └── index.js             # API routes
├── .env.example             # Environment variables template
├── .gitignore               # Git ignore file
├── index.js                 # Express app entry point
├── package.json             # Dependencies and scripts
└── README.md                # Project documentation

Environment Variables

| Variable | Description | Default | |----------|-------------|---------| | PORT | Server port | 3000 | | GOOGLE_SHEET_ID | Your Google Spreadsheet ID | Required | | GOOGLE_SERVICE_ACCOUNT_EMAIL | Google service account email | Required | | GOOGLE_PRIVATE_KEY | Google service account private key | Required | | NODE_ENV | Environment | development |

Troubleshooting

• Missing dependencies: Make sure you run npm install in your generated project directory.
• TypeScript errors: This boilerplate is now plain JavaScript. If you see TypeScript errors, remove any .ts files or references.
• Google Sheets errors: Double-check your .env values and Google Cloud credentials.
• Module not found: Ensure you have installed all dependencies listed in package.json.

License

MIT License - see LICENSE file for details

Support

• 📖 Documentation
• 🐛 Report Issues
• 💬 Discussions