How to Customize File Names and Folder Names in Document Studio

H
Published 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\\

📮  Subscribe to our Email Newsletter for Google tips and tutorials!
Published in: Document Studio

Looking for something? Find here!

Meet the Author

Web Geek, Google Developer Expert
A
Amit Agarwal

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. He is the developer of Mail Merge for Gmail and Document Studio. Read more on Lifehacker and YourStory

Get in touch

Google Add-ons

Do more with your Gmail and GSuite account
G

We build bespoke solutions that use the capabilities and the features of Google Workspace for automating business processes and driving work productivity.

  1. Mail Merge with Attachments
    Send personalized email to your Google Contact with a Google Sheet and Gmail
  2. Save Emails and Attachments
    Download email messages and file attachments from Gmail to your Google Drive
  3. Google Forms Email Notifications
    Send email notifications to multiple people when a new Google Form is submitted
  4. Document Studio
    Create beautiful pixel perfect documents merging data from Google Sheets and Google Forms
  5. Creator Studio for Google Slides
    Turn your Google Slides presentations into animated GIFs and videos for uploading to YouTube