Topics

• Spreadsheet Service
• DriveApp Service - Files by type and search string
• Query Function
• DriveApp
• DriveApp - getFileById(id)
• DriveApp Service

Examples

• Sheet
• Get files by file type with matching string in file name
• Copy a value from one sheet to current sheet
• Get a file from Google Drive using the file ID
• Create a new folder in Google root drive
• Create new file in Google Drive of a certain Mime type
• Create a new text file in Google root drive folder
• Create a new file in Google Drive from a blob
• Get all folders - put folders into a continuation token - then retrieve from token
• Get all files - put them into a continuation token - then retrieve them