Tuesday 20 June 2023

Bulk duplicate Google Drive files

The following Google Apps Script tool is designed to take a single Google Drive file e.g. a Doc / Sheet / Slide and make duplicates/copies of it with unique file names. The tool will also create a clickable link within the Google Sheet to each new file copy.

Screenshot of the tool for duplicating Drive files
Screenshot of the tool for duplicating Drive files

Tuesday 6 June 2023

Auto close Google Form after X responses

The following Google Apps Script is designed to automatically close a Google Form once it has reached the number of responses you specify.

Use Apps Script code to automatically close a Google Form
Use Apps Script code to automatically close a Google Form