CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetsgoogle-drive-apifile-rename
user1955215
user1955215

Reputation: 743

Rename files in Google Drive that have been collected through Google Forms

I am collecting Friends photos through a Google Form. The Form has only two fields Name (text) and Photo (upload).

The uploaded photo is stored in a folder in Google Drive and a hyperlink appears in the Google sheet to the name.

The issue I am facing is that the photo stored in Google Drive usually has a name generated while taking the photo and is not the name of the person whose photo it is. I want the photo file name to be the same as the person's name.

I don't know much of Google Scripts and would like help in using a script to rename the files in the Google Drive with the name of the uploader which is in the Google Sheet.

Upvotes: 0

Views: 1999

Answers (1)

IT Consulting
IT Consulting

Reputation: 7

To rename uploaded files in Google Drive that have been collected through Google Forms you can

  • create your own apps script that will process all files received via Google Form, as described here or here, or

  • use my Google Forms add-on Form Uploads Manager that renames the uploaded files, move them to the Google Drive folders you specified and can add a description for each uploaded file, which makes it easy to find files using the built-in Google Drive search. A detailed description of the add-on settings is available on the app home page.

Disclaimer: This is my Google Forms add-on, which I created for my own purposes, and after successful use I posted it on the Google Workspace Marketplace. After a 1 week trial (which might be enough to reach your goals), a paid add-on subscription is required.

Upvotes: 0

Related Questions