Scripting Google Sheets with AppScript, Typescript, and Clasp - Hands-On Tutorial
Channel: Omar Abdelbadie
Date: 2020-06-07

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-script ) . 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/AppScriptTutorial

All data used in this video is randomized