ReferenceError: "Drive" is not defined

Question

In Google App Maker, I am writing a function in ServerScript that will convert a user-uploaded Excel spreadsheet to Google spreadsheet. I am using this piece of code (https://stackoverflow.com/a/35597644/9878092), but I am getting

ReferenceError: "Drive" is not defined.

I tried using the line of code that I got directly from the link:

file = Drive.Files.insert(file, xlsxBlob, {

and my own edited version:

file = Drive.Files.update(file, ssFileID, xlsxBlob, {

Where ssFileID is the file id of the pre-made Google Sheet I want to insert the data from a user-uploaded Excel spreadsheet into. How do I fix this error?

Did you make sure to enable the Drive API under App Settings>Advanced Services? — Markus Malessa, Jun 12 '18 at 18:21
@MarkusMalessa Just enabled the Drive API, it solved the error! Thank you so much! — Eric, Jun 12 '18 at 18:49
Make sure you read the links in answers, not just copy (and attribute) the code ;) — tehhowch, Jun 12 '18 at 23:58

score 9 · Accepted Answer · answered Oct 14 '18 at 11:36

You have multiple issues:

"Drive" is not defined" error, see this

Open menu from your script ( the place you start with Code.gs) and use : Resources - Advanced Google services and check on the Drive API v2

Use files from drive to change and upload
- your source code can identify the files and used ;
- define the resources and blob ;
- enable the Advanced Drive API Service: var file = Drive.Files.insert(resource, blob, ...) ;

score 8 · Answer 2 · edited Feb 12 '21 at 22:32

8

I was having the same problem. It was resolved by adding Drive Services to the project. Snapshot attached to show how to do it.

Add Drive :

Add Services

edited Feb 12 '21 at 22:32

Jin Lee

3,194
12
46
86

answered Feb 12 '21 at 18:43

RMS

81
1
1

score 1 · Answer 3 · answered Jul 25 '22 at 00:18

1

Run this line first: from google.colab import drive

answered Jul 25 '22 at 00:18

Franch Dressing

31
2
7

ReferenceError: "Drive" is not defined

3 Answers3

Linked