Better Sheets

DriveApp

What it does

Create, find, and manage files and folders in Google Drive.

Methods used

.createFile() .createFolder() .getBlob() .getFileById() .getFolderById() .getFoldersByName() .getUrl() .makeCopy()

4 Related snippets

Official Google docs

Explore

Related methods

.createFolder()
Creates a new folder in Drive.
.createFile()
Creates a new file in Drive from a name and content.
.addFile()
Moves a file into a folder.
.getFilesByName()
Finds files in Drive that match a given name.
.searchFiles()
Searches Drive files using a query string.

More Apps Script

2 Better Sheets tutorials

Automatic Screenshots in Apps Script

Advanced

Automatic Weekly Backup of Google Sheets

Discover how to Save Your Sheets Every Week Automatically

Intermediate

Related blog posts

Written guides about DriveApp in Google Apps Script.

Browse the blog

Automatic Weekly Backup of Google Sheets

How can we create backups of Google sheets every week or every day or every month?

What's Better Than Google Sheets?

Nothing is better than Google Sheets. You just need to learn more about the unlimited power of Google Sheets. Functions, Formulas, Apps Script and more.

How to reference a different Google Spreadsheet in Apps Script?

Transferring Data Between Cells in Different Spreadsheets