2

Scripting on google's IDE is a big pain, it's very laggy and it just sucks.

How can I make the google script editor work on my PC?

I tried downloading this Clasp

Also I added a library from google to javascript.

but when I run it it gives me this error:

var ss = SpreadsheetApp.getActiveSpreadsheet();
           ^

ReferenceError: SpreadsheetApp is not defined

How can I fix this?

What I'm basically trying to do with this script is to send an email based on a bunch of conditions on a google sheets.

TheMaster
  • 45,448
  • 6
  • 62
  • 85
Alejandro Rosales
  • 111
  • 7

2 Answers2

3

Solution

In order to be able to run an Apps Script project remotely from your local machine, you need to use the clasp command run as you will be required to also use some kind of authorization (you will basically need to connect your local project to your remote Apps Script project and verify it is you the one trying to run it).

Here is a complete guide on how to use this command but just to summarise a bit you basically will need to set up a Project ID and create an OAuth Client ID to then be able to login using the credentials obtained from it clasp login --creds creds.json1.

This is an example of running a function using the command run:

clasp run 'functionName'

I hope this has helped you. Let me know if you need anything else or if you did not understood something. :)

Mateo Randwolf
  • 2,823
  • 1
  • 6
  • 17
1

Adding the google-apps-script library to webstorm might also help you out.

Follow the instructions here, but search for "google-apps-script" in the download library modal. Instead of "chrome" which is what this article is about.

How do I use WebStorm for Chrome Extension Development?

You'll then be able to create *.gs files. Open them as javascript.

Dalton Gray
  • 31
  • 3