LIVE CODING

All my live coding projects published on YouTube channel can be found here in the projects folder.

List of projects

Index	Project Folder	YouTube	Date released	Category	About
LC001	Google Doc Automation with DocPro	Watch	4/Oct/2021	document	Create a doc with data from sheet automatically with text, image, and table replacement
LC002	Send & Track Gmail	Watch	9/Oct/2021	spreadsheet	Send an email and track it with apps script
LC003	Google Doc to Web App	Watch	10/Oct/2021	doc	Turn a google doc into a web app
LC004	Form with Multiple Dependent Dropdowns	Watch	11/Oct/2021	spreadsheet	A form built with multiple dependent dropdowns
LC005	Build a Project with TypeScript	Watch	13/Oct/2021	spreadsheet	Build a Poroject with TypeScript and Clasp
LC006	Mail Merge with Draft as Template	Watch	22/Oct/2021	spreadsheet	Mail merge with Gmail Draft as a template
LC007	Read Data from PDF to Sheet	Watch	7/Nov/2021	spreadsheet	Read text data from PDF with ORC provided by Google Drive API
LC008	IMDb Web Crawler	Watch	19/Nov/2021	spreadsheet	A web scrapper built with apps script
LC009	Dependent Dropdowns in Google Sheet	Watch	19/Nov/2021	spreadsheet	Create dependent dropdowns in Google Sheet
LC010	CRUD App with Vue/Bootstrap/GAS	Watch	11/Dec/2021	spreadsheet	A CRUD Web App with Vue/Bootstrap/GAS
LC011	Web App with Router & State Mgmt	Watch	1/Jan/2022	spreadsheet	A Web App with Vue/Vuex/VueRouter/Vuetify/GAS
LC012	Clock In/Out with Google Forms	Watch	5/Feb/2022	spreadsheet googleform	Clock In/Out with Google Forms and Apps Script
LC013	Document Signing with Google Form	Watch	16/Feb/2022	googledoc googleform	Add Signature with Google Form and Google Doc
LC014	World Tides Notification	Watch	24/Feb/2022	googlesheet	Create Tide Events in Google Calendar
LC015	Rich Text Formatter	Watch	27/Feb/2022	googlesheet	A rich text formatter for Google Sheet
LC016	Twilio SMS Google Sheet	Watch	1/Mar/2022	googlesheet	Send SMS from Google Sheet with Twilio API
LC017	Sheet Protect API	Watch	3/Apr/2022	googlesheet	Add protection to Google Sheet
LC018	GAS Vue3 Template	Watch	18/Sep/2022	googlesheet	Web App with Vue3 and Apps Script
LC019	Export Sheets as PDF	Watch	01/Apr/2023	googlesheet	UrlfetchApp.fetchAll
LC020	Debounce OnEdit Event in Google Sheets	Watch	05/Sep/2023	googlesheet	UrlfetchApp.fetchAll
LC021	Add Validations to Prompts in Google Sheets	Watch	05/Jan/2024	googlesheet	Validations Prompts in Google Sheet
LC022	Single Function to Handle Custom Menus	Watch	06/Jan/2024	sheets slides docs forms	Custom menus with Apps Script

Build commands

Install node packages

npm install

Push the local project to the remote Google Apps Script project

npm run push --i=[project_index=LC001]

or

cd ./src/projects/[project folder]; clasp push

Pull the remote Google Apps Script project to local

npm run pull --i=[project_index=LC001]

or

cd ./src/projects/[project folder]; clasp pull

Open the remote Google Apps Script project

npm run open --i=[project_index=LC001]

or

cd ./src/projects/[project folder]; clasp open

Build a document.md from JSDOC

npm run doc --i=[project_index=LC001]

or

cd ./src/projects/[project folder]; jsdoc2md *.js > DOCUMENT.md