Automate generating Files from templates
Drive Connect Automation allows users to automatically generate a Drive Connect template and link it to the Drive Links component by selecting the New File from Template operation in a Record-Triggered or Schedule-Triggered flow.
For more information on setting up a flow using the Automate Drive action, see the Using Drive Connect Automation with Salesforce flows article.
New File from Template
In your flow, open a new action element node and follow the steps below:
- Click the Operation picklist and select New File from Template
- Under Template, click Select a Template
- Select a template file from your Drive Connect templates folder within the Google picker
- Select a Destination for the template to be created in Drive. For more information on destination locations, see the Automate Drive Destination Locations article.
- Select a Generated File Format of each file type:
Google Doc
PDF Document (.pdf)
Microsoft Word (.docx)
Google Sheet
PDF Document (.pdf)
Comma Separated Values (.csv)
Microsoft Excel (.xlsx)Note:Drive Connect’s merge capability for Google Sheets is limited to merging data into a sheet’s name using our “Generated Name” field
Google Slide
PDF Document (.pdf)
Microsoft PowerPoint (.pptx)
that will generate the file on automation to the selected type.
Note: If you receive a warning regarding insufficient access for the Automated Process User, ensure the folder location you select is accessible by the Automated Process User with full edit rights. For more information, please see the Granting Access to Folders in Drive article.
- Optionally set whether the new file should be linked to the Salesforce record
Child Operations
When selecting New File from Template as your top-level operation, you can add additional child operations by selecting Add Child Operation
Below is a breakdown of each child operation and their behavior:
Save File to Salesforce
This child operation will save the generated Drive Connect template from the parent operation to salesforce. For more information on using Save File to Salesforce, see the Save a linked Google Drive File to Salesforce article.
Note: You can add Update Record Field as a child operation to Save to Salesforce. The values for this are: Salesforce Content Document ID, Salesforce Content Version ID, Salesforce Content Document Record URL, Salesforce Content Document Public Link.
New Drive Shortcut
This child operation allows you to auto-create a Drive Shortcut of the parent Drive file in any destination location. If selecting this operation, complete the following steps below:
- For Shortcut Name, the parent file name can be modified
- Similar to files, you can utilize merge fields in the shortcut name by selecting the brackets button within the field
- Similar to files, you can utilize merge fields in the shortcut name by selecting the brackets button within the field
- Select a Destination for the shortcut to be created in Google Drive. For more information on destination locations, see the Automate Drive Destination Locations article
New Link to Parent
This child operation allows you to link the parent-level file to the parent Salesforce record. If selecting this operation, complete the following steps below:
- Select a Lookup Field to Parent Record
Update Record Field
This child operation allows you to update a field from a Salesforce record with a value of either Google Drive Folder URL, Google Drive Folder ID, Salesforce Content Document ID or Salesforce Content Version ID. If selecting this operation, complete the following steps below:
- Select a Field that will be updated when the automation triggers
- Select a Value
For more information on saving and activating your flow, see the Using Drive Connect Automation with Salesforce flows article.