Inspired by this gist.
- Create a new App Script project.
- Paste the content of the file
google-app-script-crud.gs
in the defaultCode.gs
file. - Create a new Spreadsheet.
- Copy the Spreadsheet ID found in the URL into the variable
SHEET_ID
located in line 1 of your file.