Now you can save your edited script and hit “Run”.

Now hit enter and then add the line “childFile.getOwner().getName()” to line #79. Choose the file or folder you want to upload. At the top left, click New File Upload or Folder Upload. You can upload files into private or shared folders. Next, to get the owner names from Google Drive to add to the spreadsheet, add a request by first putting a “,” after “childFile.getSize()” on line #78. On your computer, you can upload from or your desktop. First, add a column with the label “Owner” to the spreadsheet by adding the word “Owner” to the list of values that will be passed to the method that is creating the spreadsheet rows and columns (on line 36). Check Google’s Drive Service and the Spreadsheet Service reference guides to see the full range of endpoints/methods and parameters that are available.ĮXAMPLE: To add the “Owner”, you will need to modify the script in two places. Google Docs prepares your files and folders for download, which can take several minutes if a lot of files are included.

Use the context menu (either right-click or the three-dot menu) and choose the Add a. If you have a document stored in Google Docs and would like to download an offline copy, it’s easy to convert Google Docs to Microsoft Word format. Select a file or a folder you want to shortcut to. This script uses Google Apps Script’s Drive and Spreadsheet services to access Google Drive and populate the spreadsheet. While Google Docs has always been a popular choice for those who want to access, share, and sign documents with ease, there are times when you need your documents in a tried-and-true format, such as DOCX. You can adjust the script if you want it to collect additional details like the “Owner” of the files that you are inventorying.

Save google doc in multiple folders