Tired of coding Google Apps Script inside the browser editor? In this step-by-step tutorial, I’ll show you how to set up VS Code + Clasp on Windows so you can code locally with autocompletion, formatting, and an effortless one-line setup for new projects.
By the end, you’ll be able to create and connect new Google Apps Script projects (like Google Sheets add-ons) directly from VS Code with a single command. 🚀
In this video, we’ll cover:
Downloading & installing VS Code
Installing Node.js (required for Clasp)
Installing & configuring Clasp
Linking your Google account
Adding helpful VS Code extensions (Prettier, HTML Boilerplate)
Building a custom template system for new Apps Script projects
Creating a one-line command (newClasp) to instantly spin up a new project
This setup will save you hours and make coding with Google Apps Script far more enjoyable and professional.
📌 Helpful snippets & code blocks from this video are in the description below for easy copy-paste.
jsconfig.json file:
{
"compilerOptions": {
"target": "ES6",
"checkJs": true,
"typeRoots": ["./node_modules/@types"]
},
"include": ["**/*.js", "**/*.gs", "**/*.html"]
}
$Profile file:
function newclasp {
param($name, $id)
Copy-Item -Recurse -Path "C:\FILE PATH HERE" -Destination $name
Set-Location $name
clasp login
clasp clone $id
}
missing $profile link command:
New-Item -Path $PROFILE -Type File -Force
If you found this helpful, don’t forget to like, subscribe, and hit the bell so you don’t miss the next tutorial.
