With a tool like SugarCRM, you can keep your sales team organized and efficient so they can focus on what they do best – closing deals!  From tracking new leads, keeping in contact with those prospects, and tracking deals, SugarCRM can keep your business running smoothly.

Another great way to improve your sales process is to use Formstack Documents to automatically generate all your sales documents so your sales team can stay focused.  Easily set up all of your templates in Formstack Documents and you’ll never have to copy and paste again!

In this example, we’re going to show you how to automatically generate a sales proposal when we add a new opportunity to SugarCRM.  We’ll then automatically email this proposal directly to our customers for their review.

To get started, we’re going to set up our proposal template using a Word document.  Inside Word, we’re going to add our logo, contact information, and all the proposal information.  For the spots that we want to insert data from SugarCRM, we’re going to use merge fields like {$FirstName}, {$DealAmount}, etc.

Here’s what our proposal template looks like:

Once we have our template finished, we need to upload it to Formstack Documents.  From the Documents page in Formstack Documents, click the New Document button and then enter a name.  On the next step, pick Office Document as the document type and pick the file from your computer.

After you upload your template, you’ll be taken to the Settings tab where you can modify various options like the type of file that is generated and the name of the file.  For this example, we’re going to generate a PDF and include the name of our opportunity in the merged file name.

Next, we’re going to set up the email delivery for our document so that the proposal is emailed directly to our customer.  From the Deliver tab, go ahead and Edit the default email delivery.  For the To address, we’re going to use a merge field for our customer’s email address.  If you don’t have a merge field in your document for the email address, pick <<Other>> from the dropdown and then enter something like {$Email_To}.  Feel free to edit any of the other settings.

Once you have saved your email delivery, we are done with the setup process in Formstack Documents and we’re ready to integrate with SugarCRM.  To help with the integration between SugarCRM and Formstack Documents, we’re going to use our friends over at Zapier.

Inside Zapier, we’re going to create a New Zap.  For the Trigger we’re going to choose SugarCRM as the app and then New Opportunity as the trigger.

Once you authenticate your SugarCRM account, Zapier is going to load an example opportunity to make sure that everything is working.  Please follow those steps and continue.

Next, we’re going to set up the Action for our Zap.  For the app, we’re going to choose Formstack Documents and then Create Document Merge as the action.

Once you authenticate your Formstack Documents account, Zapier is going to load a list of the documents in your Formstack Documents account.  Go ahead and select the Proposal template that you just set up and Zapier will load a list of all the merge fields in your template.

For each of the merge fields, go ahead and select the corresponding fields from SugarCRM.  This tells Zapier how to send the data over to Formstack Documents so that it is populated in the correct spot on your template. 

Once you have matched up all of your merge fields, go ahead and save your zap then turn it on.  We’re ready for a test!  Login to SugarCRM and add a new opportunity.  Zapier will detect this opportunity and send the information over to Formstack Documents and your proposal will be generated.

Here’s what our proposal looked like ready to send to the client:

Congrats, you’re all finished!  You can now instantly generate all types of documents from SugarCRM.  Can you think of any other ways that you can use Formstack Documents to simplify your paperwork process?

Intellidocs Integration for SugarCRM Users

Zapier Integration

There's also a service called Zapier that allows you to set up "triggers" that will automatically send data to Formstack Documents for documents to be created.  For example, you could have a welcome letter automatically generated for each new lead that is added to Sugar - without having to click any buttons.

The setup process is pretty similar - you set up your document and delivery options in Formstack Documents, then you set up a new "Zap" in Zapier to send data from your SugarCRM instance to Formstack Documents. The only downside with Zapier is you cannot easily save the document back in SugarCRM - you'd have to set up a custom integration using the Webhook delivery option in Formstack Documents.

Was this article helpful?
0 out of 0 found this helpful



Please sign in to leave a comment.