Tutorials

Setting up a document approval process in HubSpot

27min
in this tutorial, we will explore how you can create a document approval process within hubspot using hubspot cloudfiles integration learn how to create workflows that set up a secure dataroom, collect documents systematically, and organize them into folders stored in your preferred external storage create a checklist of these documents, trigger email/slack notifications upon upload completion vet the document and send reminders to customers for any re upload what to expect by the end of this tutorial, you can expect to have an external dataroom to collect and organize documents within hubspot have a checklist to keep a track of required documents trigger e mail notification to notify customer about document upload completion or documents re upload the image below shows the expected output if you have a basic grasp of these concepts, you can expect to finish the tutorial in under 10 minutes refer to the gif below to have a visual understanding of this tutorial’s expected outcome 1 pre requisites before you start with the set up, please ensure you have installed cloudfiles and connected it to your cloud storage of choice install cloudfiles in hubspot cloudfiles is available on the app marketplace and can be installed using the standard app installation process check out installation guide for cloudfiles hubspot integration connect your storage login to your external storage of choice such as google drive, sharepoint etc through the cloudfiles interface this will give you instant access to your external files within hubspot the gif below shows the steps quickly check out quick start for file connector in hubspot for more information connect automation user for storage in addition to installing cloudfiles in hubspot, you also need to set an automation user for the workflow to work this is the integration user that will be used by the workflow actions to pass files into the cloud storage to connect an automation user, simply head over to app cloudfiles io http //app cloudfiles io/ > settings > integrations > google drive and login through your google account what is an 'automation user' and how does it work? https //help cloudfiles io/webapp/what is an automation user and how does it work this article explains everything you need to know about the automation user, including what it is, why it's useful, and how it operates after connecting the desired storage, we will proceed to create create documents upload dataroom with shareable link and a checklist to automatically mark the documents upload completion we’ll be creating multiple workflows for this which is detailed in the sections below creating workflow to get document collection link we will create a workflow to create a document request dataroom with shareable link that can be shared with the customers the uploaded documents will be stored in an internal folder which will be accessible within hubspot this is how the final workflow looks like the details of the workflow has been given below 1 create contact based workflow we will create a contact property that will fire the trigger for document collection workflow for this, create a single checkbox property in the hubspot contact settings we have created a property called ‘request documents’ create a new contact based workflow from scratch and select the trigger to fire ‘when filter criteria is met’ set the property as ‘request documents’ and set it to ‘yes’ to activate the trigger as shown in the gif below 2 create folder using ‘create folder’ action create folder action can be used to create folders in any location on any cloud storage platform from hubspot flow action we will use this action to first create the folder that will store the sensitive documents collected from the datatoom to use the “create folder” action, simply click on add button and search for ‘create folder’ as shown below once you add this action, it will ask you to fill in certain parameters this action requires a few parameters the library parameter is the desired cloud storage where you wish to create the folder select the desired storage from the drop down field the folder name is the name you wish to give your created folder we simply use the company’s name but you can also create a complex text formula variable as well the gif below shows how to populate the library & folder name parameter we also need to enter values for shared drive id & path to destination these are shared drive id this is important for google drive & sharepoint users only these cloud storages offer multiple 'drives' where documents can be uploaded path to destination this specifies the destination folder in which this new folder will be created these parameters can be easily copied from cloudfiles app library follow these steps find the cloudfiles widget from any hubspot record, and click on cloudfiles it will redirect you to your cloudfiles storage under the libraries tab, navigate to folder where you would like to store your files or simply create new folder copy the parameter from the meta data on the right side of the screen check the gif below for a quick walkthrough of these steps for a detailed description of the create folder action, refer to the create folder detailed guide here’s how our final create folder action looks like 3 show folder on record using ‘create attachment’ action the create attachment https //help cloudfiles io/hubspot/create attachment action action is used to associate created folder to hubspot records attaching (or associating) our newly created folder is important since this will enable us to see and operate on the folder contents right from the hubspot record to use this action, simply click on add button and search for ‘create attachment’ as shown below once you add this action, it will ask you to fill in certain parameters “shared drive id” and “library” parameters will be same as above the “ path to folder” will be the exact and full path of the newly created folder you can simply copy from the meta data info in the cloudfiles library using the same steps as specified in the shared drive id section above here’s how our final create attachment action looks like 4 create dataroom using ‘create dataroom’ action a dataroom is a file portal, where you can request files from your customers we will use “create dataroom” action to create a documents upload portal where customers can upload their requested documents to use this action, simply click on add button and search for ‘create dataroom’ as shown below once you add this action, it will ask you to fill in certain parameters “ name ” is the name of dataroom that appears on the dataroom, “ description ” is an optional field that can be used to give additional description for conveying more information to read more about this action, visit create dataroom action https //help cloudfiles io/hubspot/create dataroom action refer to the gif below to get a visual understanding of above steps here’s how our final create dataroom action looks like 6 show dataroom on record using ‘create attachment’ action the create attachment https //help cloudfiles io/hubspot/create attachment action action can also be used to associate created dataroom to hubspot records to use this action, simply click on add button and search for ‘create attachment’ as shown below after you add this action, you will have to fill 3 parameters for attaching a dataoom, library parameter should always be ‘cloudfiles’ resource type will be ‘dataroom’ and resource id will be ‘ new dataroom id ’ derived from the output of previous create dataroom action refer to the gif below to have a visual understanding of this steps here’s how our final create attachment action for dataroom looks like 7 create file request block using ‘add to dataroom’ the ‘ add to dataroom https //help cloudfiles io/hubspot/add to dataroom action ’ action enables you to insert files, folders and file request blocks to your cloudfiles datarooms using a workflow you can add this action as many times as needed to request the required files to use this action, simply click on add button & search for ‘add to dataroom’ as shown below once you add this action, it will ask you to fill in certain parameters “shared drive id” & “library” parameters will be same as above for remaining parameters, refer below dataroom id new dataroom id derived from the output of ‘create dataroom’ action type file request name name of documents requested add to destination yes path to destination folder full and exact folder path of sub folder created earlier description (optional) describe the requested documents refer to the gif below to have a visual understanding of this steps here’s how our final add to datatoom action looks like 8 create shareable link for dataroom using ‘share attachment’ action the share attachment https //help cloudfiles io/hubspot/share attachment action action enables you to share attachments using hubspot workflows sharing an attachment is exactly the same as manually creating a sharing link of a file / folder / dataroom from hubspot record to use this action, simply click on add button and search for ‘share attachment’ as shown below this action has only one parameter that can be set to specify the attachment to be shared you can derive this from the return value of previous create attachment action ‘new attachment id’ refer to the gif below have a visual understanding of this step 9 copy the sharing link to contact property using ‘copy property value’ action in this step, we will copy the link created in the last step to a contact property for this, first create a single line text property in the hubspot contact settings we created a property called ‘shared files portal link’ to copy the shared link to the above property, we will use the copy property value action https //knowledge hubspot com/workflows/choose your workflow actions for the ‘from’ parameter, we will choose the output ‘url’ of the last action for the ‘to’ parameter, we will use our newly created contact property the gif below shows the configuration for the copy property value action that’s it save and activate the flow your documents upload process is set in the next section, we will learn how to create the documents upload checklist create checklist for required documents after setting up the documents upload process, we will create a checklist to keep a track of uploaded documents this is how the checklist looks like to set up the checklist, we'll create a multiple checkbox property in hubspot contact settings, listing all required documents as customers upload each document, the respective checkboxes will be marked automatically when all checkboxes are marked, an email notification will alert the contact owner once the checklist is set up, we will create individual workflows for each document to verify the upload and mark the respective checkbox here’s how our final workflow looks like we will detail these elements in the sections below 1 create contact based workflow create a new contact based workflow from scratch and select the trigger to fire ‘when filter criteria is met’ set the property as ‘cloudfiles file received properties’ > ‘file request name’ as shown in the image below enter the name of the file requested refer to the gif below to have a visual understanding of this step once the trigger is set, in the next section, we will learn how to create the checklist containing a list of the required documents and how to set up a workflow to append uploaded document to the corresponding checkbox 2 set property value to append the document to the checklist we will create a checklist which will be visible in the contact property to do so, we will create a multiple checkbox property in the hubspot contact settings, listing all the documents to be requested from customers in this tutorial, we've created a property named 'upload checklist' and listed three required documents as shown below we will now create the action that will mark the appropriate checkbox in the checklist when documents are uploaded for this, add hubspot action ‘set property value’ in the target object field, select ‘contact’ property to set will be the checklist property created above once selected, append the required value as shown in the gif below this is how the final action looks like 3 notify if all documents uploaded next, we will check if all documents have been uploaded if they are, we will send an internal notification to the contact owner to check whether everything is uploaded, we use a simple branch element to send the notification, we use the ‘send internal email’ action you can also choose to send a slack notification duplicate the above workflow for other required documents just make a simple tweak append the respective document value to the 'upload checklist' property document vetting and re upload request after receiving the email confirming the completion of document uploads, you can access the uploaded documents within your hubspot by navigating to cloudfiles widget > contact folder during document vetting, if a rejection occurs and you need a file re upload, simply uncheck the document in the 'upload checklist' property this action can trigger an e mail to customers, requesting the re upload of the specified document along with the dataroom link you can chose to request document re upload as many times as needed once satisfied, you can setup a workflow to trigger an email to the customer telling them the uploads are complete to do so, you can have a single checkbox property on your contact called ‘documents upload completed’ and trigger the workflow when this changes to yes that’s it! that’s how you can set up a streamlined document approval process within hubspot test the workflow to test the document approval process, create a new contact or select an existing contact add all the properties related to the approval process created above set ‘request documents’ property to ‘yes’ to trigger the workflow give it a minute to execute refresh the page you will be able to see the dataroom link in the ‘document upload link’ property and also the folder attachment in the cloudfiles widget in the right side click on the dataroom link and upload documents as requested once you have uploaded the documents, you will see the respective checkboxes get ticked you can check the uploaded documents and mark the upload complete property accordingly to trigger external email to customer these steps have been illustrated in the gif below for a better understanding