How to use Sheets Advanced Service in Google App Script

[Tuan Do]

I am trying to use `batchUpdate` in Google App Script. I found this example link which shows me how to do it. However, when I use it in my normal Google App Script, it says `ReferenceError: Sheets is not defined`. I wonder how I can use Sheets Advanced Service in Google App Script so that I can use `batchUpdate`.

Thanks a lot

[cbmserv...@gmail.com]

Share your code if you want us to identify what you may have done wrong.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/39a04df8-3979-4e11-9256-91c2bf189f05n%40googlegroups.com.

[Tuan Do]

I just use code in the example in that link.

````

function changeTitle(){

     var updateSpreadsheetPropertiesRequest = Sheets.newUpdateSpreadsheetPropertiesRequest();
     updateSpreadsheetPropertiesRequest.properties = Sheets.newSpreadsheetProperties();
     updateSpreadsheetPropertiesRequest.properties.title = title;
     updateSpreadsheetPropertiesRequest.fields = 'title';

}

`````

The error is ReferenceError: Sheets is not defined

[CBMServices Web]

If this is all of your code, then sheets is not defined. You need to declare it before using it.

Am sure the example has that defined. So make sure you copy over all of the code.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/31c1c748-0c94-46d5-8ffa-a4d1838a3eaan%40googlegroups.com.

[David Tew]

Perhaps you have not yet enabled Advanced Services for Sheets . See here 

https://ctrlq.org/google.apps.script/docs/guides/services/advanced.html

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAFX%2Bz3XefbaS-HX8kWc6k5Rz%2B5XAEdL6%2BryDU1s5F4dTSC9i9w%40mail.gmail.com.

--

Regards

David Tew

01522 704293

[Tuan Do]

Thank you David, everything works now. A quick follow up question if you don't mind: I am developing an add-on (to be published on Google Workspace Marketplace) for other users to use. I am just curious whether they will also need to enable Sheets API to fully use my add-on? Thanks

[David Tew]

I don’t know this answer since I’ve never made an add-on.  Bruce and others will know - hopefully someone’s around here soon. I’d like to know too, as it goes.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/9eb0536f-e02f-4cd6-81e5-ac6030fcc288n%40googlegroups.com.

[Andrew Roberts]

There is only one script project associated with an Add-on, and as you have enabled the Advanced service in that any users of the Add-on won't have to enable it too.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAC80mJQd1bkjbtgVPdmuxfVFGFFLbD2U95dGmjfMwXgD1boo5Q%40mail.gmail.com.

[David Tew]

Thanks Andrew

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAN1QPJQgtKrhy4zaKDKQVmfrMZ-sjqMduBHZ5Prt2TPrKN-uoQ%40mail.gmail.com.

[Tuan Do]

Thank you Andrew