The OneDrive API is Microsoft’s version of Google Drive. The API is very similar to the Drive API, so I’m going to port Drive JSON API for apps script over so you can use OneDrive from Apps Script.


Like Google, Microsoft use Oauth2, so we’ll use EzyOauth2 – taking some pain out of Apps Script API authentication to handle that dialog. You’ll need to copy the patterns shown in EzyOauth2 patterns and head over to the Microsoft developers site to create an application using the Live SDK to get connected.

Setting up EzyOauth2 patterns for your app for OneDrive is written up in Oauth2 authentication for Microsoft OneDrive