Overview

Vibe Coding guide for non-technical users

This guide is written for non-technical roles. You do not need to build a backend or understand databases. If you can use Google Sheets, you can use it as your database and ship a working system fast.

GSheet-CRUD turns Google Sheets into a full REST API. You only need to describe your business needs and the AI can assemble the UI and features.

Quick start

1. Create a new Sheet and grant access

Create a Google Sheet and add the email below as an Editor. This is a fixed company DevOps account and should not be replaced.Sharing with this email does not pose a data leakage risk.

email
[email protected]

If you only need a temporary sheet, you can use:Sample Sheet

2. Create a new project on your computer

Example project name: manage_demo

bash
mkdir manage_demo
cd manage_demo

3. Install the GSheet-CRUD Skill

Copy and run:

bash
npx skills add [email protected]:axinan/fe/platform/gsheet-crud.git

4. Use this prompt to generate the app

text
According to the requirements in SKILL.md, use
https://docs.google.com/spreadsheets/d/1mFZCZ7UUoaOKYpCwhMCgzkkUuz83VyvsgqW3kbJ2xMI/edit?gid=0#gid=0
as the database to build a simple student management system.

Use Vite + React + Tailwind CSS + shadcn.

5. Wait for the page to generate

When generation completes, preview the page directly.

URL Format

url
https://gsheet-sql.dev.iglooinsure.com/api/{doc_id}/{sheet_name}
  • doc_id — Google Sheets document ID (from URL: docs.google.com/spreadsheets/d/{doc_id}/edit)
  • sheet_name — Sheet name (optional, defaults to Sheet1)

GET — Query Data

Get all data from a sheet:

bash
curl 'https://gsheet-sql.dev.iglooinsure.com/api/1fQqyNzfEC33vwGrfNLd_WTQjA39B1J_9kmEPFLfCUNc'

Filter with query parameters:

bash
curl 'https://gsheet-sql.dev.iglooinsure.com/api/1fQqyNzfEC33vwGrfNLd_WTQjA39B1J_9kmEPFLfCUNc?name=John&age=25'

Response:

json
{
  "data": [
    {"name": "John", "age": 25, "email": "[email protected]"}
  ]
}

POST — Insert Data

Insert a single record:

bash
curl 'https://gsheet-sql.dev.iglooinsure.com/api/1fQqyNzfEC33vwGrfNLd_WTQjA39B1J_9kmEPFLfCUNc' \
  -H 'Content-Type: application/json' \
  -d '{"name": "Mike", "age": 28, "email": "[email protected]"}'

Insert multiple records:

bash
curl 'https://gsheet-sql.dev.iglooinsure.com/api/1fQqyNzfEC33vwGrfNLd_WTQjA39B1J_9kmEPFLfCUNc' \
  -H 'Content-Type: application/json' \
  -d '[
    {"name": "Mike", "age": 28},
    {"name": "Sarah", "age": 35}
  ]'

PUT — Update Data

Use query parameters to match records, update with request body:

bash
curl -X PUT 'https://gsheet-sql.dev.iglooinsure.com/api/1fQqyNzfEC33vwGrfNLd_WTQjA39B1J_9kmEPFLfCUNc?name=John' \
  -H 'Content-Type: application/json' \
  -d '{"age": 26, "email": "[email protected]"}'

Note: All records matching the query will be updated.

DELETE — Delete Data

Delete by query parameters:

bash
curl -X DELETE 'https://gsheet-sql.dev.iglooinsure.com/api/1fQqyNzfEC33vwGrfNLd_WTQjA39B1J_9kmEPFLfCUNc?name=John'

Or specify criteria in the request body:

bash
curl -X DELETE 'https://gsheet-sql.dev.iglooinsure.com/api/1fQqyNzfEC33vwGrfNLd_WTQjA39B1J_9kmEPFLfCUNc' \
  -H 'Content-Type: application/json' \
  -d '{"name": "John", "age": 25}'

Warning: All matching records will be deleted. Use with caution.