Repository files navigation

Everything to get you quickly up and running with modern tooling that supports imports andexports right inside of your Google Spreadsheet scripts (Google Apps Script).

All of below technologies preconfigured to work with Google Apps Script:

• TypeScript
• rollup (for imports and exports)
• axios as a standardized fetch library (instead of the Google proprietary fetch)
• jest
• clasp
• some example code

• Clone the repo.
• Runyarn
• Authenticate with your Google Account:yarn google:login
• Ensure your Google account allows API access, byswitching it on
• Create the linked Spreadsheet in your account:yarn google:create --title "My new Spreadsheet"
• Move thebuild/.clasp.json file to the project directory (e.g. by runningmv build/.clasp.json .clasp.json)
• Publish the code after making changes using:yarn google:publish
• FollowGoogle's developerreferenceand theirguides,but remember toexport the functions inindex.ts to expose them.
• Remember to set relevantoauthScopes inbuild/appsscript.json