code-tests
Google Clasp to pull-push to Google Apps Script and keep code backed up in GitHub
GitHub Repository
https://github.com/jwilleke/code-tests
Code that I have used for Google Apps Script projects.
Apps Script
Script ID: 1HwK90MxJ8bNSfrrwsGKTbsvAfBSghCsSM7LtSzzyw8wTBtSz1PJQ3obG
The SpreadSheet
Works with the spreadsheet: https://docs.google.com/spreadsheets/d/1_aL5HOiEVUCf9Zz_qocSRdnd9ZSqBDT9tdke6V4rH_I/edit?usp=sharing
And the Form: https://docs.google.com/forms/d/e/1FAIpQLScFVnjy5F7ctx0K-9ldJb3I_gp_jJUbjdrM7aCY8KvfJuqB9g/viewform
My Detailed Docs https://docs.google.com/document/d/14jpnrHIrBDYQ5UzOLCdZSlv0WNclRf_cuOjsp-w_9ZQ/edit?usp=sharing
CLASP
https://github.com/google/clasp https://medium.com/geekculture/how-to-write-google-apps-script-code-locally-in-vs-code-and-deploy-it-with-clasp-9a4273e2d018
The four commands to master in clasp are:
- clasp login 1HwK90MxJ8bNSfrrwsGKTbsvAfBSghCsSM7LtSzzyw8wTBtSz1PJQ3obG
- clasp clone - clones script from Google (One time thing)
- clasp push -w - saves to Google (Then watches for you to save file and pushes to Google Every time)
- clasp pull - pulls script from Google
Project OAuth Scopes
- Connect to an external service https://www.googleapis.com/auth/script.external_request
- View and manage your forms in Google Drive https://www.googleapis.com/auth/forms
- See, edit, create, and delete all your Google Sheets spreadsheets https://www.googleapis.com/auth/spreadsheets
- See your primary Google Account email address https://www.googleapis.com/auth/userinfo.email
- See and download all your Google Drive files https://www.googleapis.com/auth/drive.readonly
- View groups on your domain https://www.googleapis.com/auth/admin.directory.group.readonly
- See info about users on your domain https://www.googleapis.com/auth/admin.directory.user.readonly
Errors
Dec 23, 2022, 5:12:00 AM Error ReferenceError: sheetModifiedName is not defined at onEditTimeStamp(onEditTimeStamp:18:29)
People API
personFields
string (FieldMask format)
Required. A field mask to restrict which fields on each person are returned. Multiple fields can be specified by separating them with commas. Defaults to all fields if not set. Valid values are:
- addresses
- ageRanges
- biographies
- birthdays
- calendarUrls
- clientData
- coverPhotos
- emailAddresses
- events
- externalIds
- genders
- imClients
- interests
- locales
- locations
- memberships
- metadata
- miscKeywords
- names
- nicknames
- occupations
- organizations
- phoneNumbers
- photos
- relations
- sipAddresses
- skills
- urls
- userDefined