How to Customize File Names and Folder Names in Document Studio

Documents generated through Document Studio can have custom file names based on the merged data. The files can also be stored inside separate folders in Google Drive so as not to clutter the main folder of your Google Drive.

Choose File Names with Document Studio

file-title.png

You can choose to have fixed file names, like customer.pdf, or better still, you can have customized file names that include the merged data.

For instance, in our spreadsheet, we have three columns for the customer’s name and city. We can set the merged file name as {{First Name}} {{Last Name}}.pdf and the generated files would automatically include the customer’s name.

You can skip adding the file extension as it automatically added based on the export format selected.

Set Folder Path in Google Drive

You can also specify custom folder names for your merged documents and new folders will automatically get created based on the merged data.

google-drive-folder-name.png

Go to the Upload to Google Drive section in the sidebar and press Select to choose the parent folder. All merged document will be stored inside this main folder.

Next, we can specify the subfolder path and this path can include variable marker fields using the double curly notation.

For instance, if we’re to put all folder of a particular city in one sub folder, our path would be:

\\{{City}}

Similarly, we can further add another level and create separate folders for each customer inside the city folder.

\\{{City}}\\{{First name}}{{Last Name}}

The subfolder path can also include fixed names as in:

\\{{City}}\\Invoices\\

Amit Agarwal

Amit Agarwal

Google Developer Expert, Google Cloud Champion

Amit Agarwal is a Google Developer Expert in Google Workspace and Google Apps Script. He holds an engineering degree in Computer Science (I.I.T.) and is the first professional blogger in India.

Amit has developed several popular Google add-ons including Mail Merge for Gmail and Document Studio. Read more on Lifehacker and YourStory

0

Awards & Titles

Digital Inspiration has won several awards since it's launch in 2004.

Google Developer Expert

Google Developer Expert

Google awarded us the Google Developer Expert award recogizing our work in Google Workspace.

ProductHunt Golden Kitty

ProductHunt Golden Kitty

Our Gmail tool won the Lifehack of the Year award at ProductHunt Golden Kitty Awards in 2017.

Microsoft MVP Alumni

Microsoft MVP Alumni

Microsoft awarded us the Most Valuable Professional (MVP) title for 5 years in a row.

Google Cloud Champion

Google Cloud Champion

Google awarded us the Champion Innovator title recognizing our technical skill and expertise.

Email Newsletter

Sign up for our email newsletter to stay up to date.

We will never send any spam emails. Promise.