Scripting Google Sheets with AppScript, Typescript, and Clasp - Hands-On Tutorial

While preparing skip-traced homeowner data for a cold calling campaign, I had to go through a manual process to split out all the numbers associated with a single person. Figured I would share with you my script for making that happen! This intermediate tutorial will walk you through a practical usage of the Google Sheets AppScript API( https://developers.google.com/apps-sc... ) . But instead of using the AppScript console (which is a poor developer experience), I install the clasp cli and use typescript. Auto Code-Completion for the win! If you're in a rush, or don't want to learn about this code, check out this repo, where you can copy and paste the `numberSplitter.js` file into your own Google Sheet and see it in action. https://github.com/bookRa/AppScriptTu... All data used in this video is randomized