How to use google API in Apps Scripts on Google Sheet?

user_12097673 0
Viewed 72

I know my question sounds a bit mouthful, so just let me make my point clear: I need to do something like bringing data from Google Sheet to AWS (i.e. Athena), or vice versa.

However, because Google API is in need anyway, I surprisingly found that require() is not even a function in such kind of JS' twin-like language at all. Therefore, how can we use any third-party libraries on it?

Example (github repo):

const {google} = require('googleapis');
google-apps-script node.js google-sheets google-api javascript
1 Answers

You can use Gmail, Calendar, Drive, and most other Google Workspaces APIs in Apps Script by enabling Advanced Services.

  • Open the Apps Script project.
  • At the left, click Editor code.
  • At the left, next to Services, click Add a service add.
  • Select an advanced Google service and click Add.

Here's an example on how to use the Drive API inside Apps Script.

user_5121270
Related