emilyboda
supermamon
/ code.js
Last active
January 3, 2024 13:01
Example Google Apps Script WebApp to read/append to a Spreadsheet
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| How to setup | |
| ============ | |
| 1. Go to https://script.google.com and login | |
| 2. Click New Project | |
| 3. Give the project a name be clicking on "Untitled Project" and giving a new name | |
| 4. Copy this whole code and overwrite everything on Code.gs file. Click on the Save icon to save. | |
| 5. Go to Google drive and open the worksheet that you want to manipulate | |
| 6. Take a look at the url. It should be in this format -- https://docs.google.com/spreadsheets/d/spreadheet-id-as-some-long-seemingly-random-characters/edit#gid=478439860 |