GAS AI BuilderApps Script Assistant Sign in

Google Apps Script recipes

Tested code for the jobs most Apps Script projects need. Copy it into your project, or let GAS AI Builder add it for you.

Sheets as a database

Web app

Dates, text and numbers

Email, Docs, Forms and PDF

Drive files

Triggers and long jobs

APIs, cache and settings

Sheet formulas

=EMAIL_VALID(text) – check email addressesTRUE when the text looks like an email address; catches spaces, missing @ and common typos like gmial.com.=EMAIL_VALID()=HARI_KERJA_LIBUR(start; end; holidays) – working days with a holiday tabCounts working days between two dates, skipping the holidays listed in a range; =HARI_KERJA_LIBUR(B2; C2; Libur!A:A; 6) counts Saturdays as work days.=HARI_KERJA_LIBUR()=JSON_GET(json; path) – read a value from JSON in a cell=JSON_GET(A2; "customer.name") or "items.0.price" pulls one value out of JSON stored in a cell.=JSON_GET()=NOMOR_HP(phone) – one format for phone numbers"0812-3456-7890" and "+62 812 3456 7890" both become 6281234567890, the form WhatsApp links need.=NOMOR_HP()=RUPIAH(amount) – "Rp 1.250.000" as textFormats a number as rupiah text with dots between thousands, for labels, emails and documents made from the Sheet.=RUPIAH()=SLUG(text) – short ids from names"Kopi Susu Gula Aren (Large)" becomes "kopi-susu-gula-aren-large", for codes, file names and links.=SLUG()=TANGGAL_INDO(date) – "Selasa, 3 November 2026"Writes a date with Indonesian day and month names; =TANGGAL_INDO(A2; FALSE) leaves out the day name.=TANGGAL_INDO()=TERBILANG(amount) – numbers in Indonesian words=TERBILANG(1250000) gives "satu juta dua ratus lima puluh ribu rupiah". Works on a whole column too.=TERBILANG()=UMUR(birth date) – age or length of service=UMUR(B2) gives "34 tahun 2 bulan"; =UMUR(B2; C2) counts up to another date (e.g. masa kerja until leaving).=UMUR()

Let the AI put it in your appGAS AI Builder knows every recipe here. Describe your app and it uses these where it fits, in a Google Apps Script project in your own Drive.

Start building