Blog

Automatically Populate Quotes from Netsuite with Workato

Blog

Automatically Populate Quotes from Netsuite with Workato

Blog

Automatically Populate Quotes from Netsuite with Workato

Blog

Automatically Populate Quotes from Netsuite with Workato

Blog

Automatically Populate Quotes from Netsuite with Workato

Download PDFDownload PDF
Blog

Automatically Populate Quotes from Netsuite with Workato

Lacey Jackson
/
November 4, 2017
Blog

Automatically Populate Quotes from Netsuite with Workato

MIN
/
November 4, 2017
About the Episode
Episode Highlights
Meet our Guest
Episode Transcript

With an ERP tool like Netsuite you can keep track of many aspects of your business and make sure your team is performing their best and focused on doing work faster.

Another way you can improve your business processes is by using Formstack Documents to automatically populate document templates (contracts, quotes, letters, etc) with data from Netsuite.  You’ll never have to search for a template or copy & paste again.

In this example we’re going to show you how to automatically populate a quote when we add a new opportunity to Netsuite.  To help with the integration between Formstack Documents and Netsuite, we’re going to use our friends over at Workato.

To get started, we’re going to setup the template for our quote using a Word document.  Inside Word, we’re going to setup the repeating information in our quote like our logo, contact info, etc.  Then for the spots that we want to insert our customer/opportunity info, we’re going to use merge fields that look like {$OpportunityName}, {$Amount}, etc.

You can name these merge fields anything you’d like and we’ll connect them to the correct Netsuite fields using Workato.

Here’s what our quote template looks like:


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


After you’ve uploaded 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.  In this example, we’re going to produce a PDF document and include the name of the opportunity in the file name.


Next, we’re going to setup the delivery of our document so that is emailed directly to our customer for their review.  Under the Deliver tab, we’re going to edit the default email delivery.  For the “To” address, we’re going to use a merge field for our customer’s email address.

Feel free to edit any of the other email settings – you can use merge fields in any of those settings.


Once you have updated the email delivery, we are done with the setup process inside Formstack Documents, and we’re ready to setup the integration with Netsuite using Workato.

Inside Workato, we’re going to create a New Recipe.  For the trigger, we’re going to choose Netsuite as the app, then New Standard Object as the trigger.


Once you authenticate your Netsuite account, you’ll need to pick the standard object that you want to pull data from, so go ahead and pick the Opportunity object.


Next, we’re going to setup the action of our recipe.  Go ahead and choose WebMerge as the app then Merge Document as the action.


After you authenticate your Formstack Documents account, Workato is going to load a list of the documents in your account.  Go ahead and pick the template that you setup in Formstack Documents and Workato will load a list of the merge fields in your document.

For each merge field, you need to pick the corresponding field from Netsuite.  This tells Workato how to send 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 finish the recipe and then we’re ready for a test!  Login to Netsuite and add a new opportunity.  Workato will detect this new opportunity, send the data over to Formstack Documents , then your quote will be emailed out!

Here's what our test quote looked like:


Congrats, you’re all finished!  You can now automatically generate all kinds of document from Formstack Documents using Workato. Check out the video below to learn more about leveling up your document generation process with Formstack Documents.

Blog

Automatically Populate Quotes from Netsuite with Workato

Blog

Automatically Populate Quotes from Netsuite with Workato

Get the Report

Great, thank ya!

You can now access the content.
Oops! Something went wrong while submitting the form.
Blog

Automatically Populate Quotes from Netsuite with Workato

Panelists
No items found.
Introduction
Introduction

Great, thank ya!

You can now access the content.
Download NowDownload Now
Oops! Something went wrong while submitting the form.

With an ERP tool like Netsuite you can keep track of many aspects of your business and make sure your team is performing their best and focused on doing work faster.

Another way you can improve your business processes is by using Formstack Documents to automatically populate document templates (contracts, quotes, letters, etc) with data from Netsuite.  You’ll never have to search for a template or copy & paste again.

In this example we’re going to show you how to automatically populate a quote when we add a new opportunity to Netsuite.  To help with the integration between Formstack Documents and Netsuite, we’re going to use our friends over at Workato.

To get started, we’re going to setup the template for our quote using a Word document.  Inside Word, we’re going to setup the repeating information in our quote like our logo, contact info, etc.  Then for the spots that we want to insert our customer/opportunity info, we’re going to use merge fields that look like {$OpportunityName}, {$Amount}, etc.

You can name these merge fields anything you’d like and we’ll connect them to the correct Netsuite fields using Workato.

Here’s what our quote template looks like:


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


After you’ve uploaded 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.  In this example, we’re going to produce a PDF document and include the name of the opportunity in the file name.


Next, we’re going to setup the delivery of our document so that is emailed directly to our customer for their review.  Under the Deliver tab, we’re going to edit the default email delivery.  For the “To” address, we’re going to use a merge field for our customer’s email address.

Feel free to edit any of the other email settings – you can use merge fields in any of those settings.


Once you have updated the email delivery, we are done with the setup process inside Formstack Documents, and we’re ready to setup the integration with Netsuite using Workato.

Inside Workato, we’re going to create a New Recipe.  For the trigger, we’re going to choose Netsuite as the app, then New Standard Object as the trigger.


Once you authenticate your Netsuite account, you’ll need to pick the standard object that you want to pull data from, so go ahead and pick the Opportunity object.


Next, we’re going to setup the action of our recipe.  Go ahead and choose WebMerge as the app then Merge Document as the action.


After you authenticate your Formstack Documents account, Workato is going to load a list of the documents in your account.  Go ahead and pick the template that you setup in Formstack Documents and Workato will load a list of the merge fields in your document.

For each merge field, you need to pick the corresponding field from Netsuite.  This tells Workato how to send 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 finish the recipe and then we’re ready for a test!  Login to Netsuite and add a new opportunity.  Workato will detect this new opportunity, send the data over to Formstack Documents , then your quote will be emailed out!

Here's what our test quote looked like:


Congrats, you’re all finished!  You can now automatically generate all kinds of document from Formstack Documents using Workato. Check out the video below to learn more about leveling up your document generation process with Formstack Documents.

Panelists
No items found.
Infographic

Automatically Populate Quotes from Netsuite with Workato

Learn how to automatically populate quotes, invoice, contracts and more from Netsuite.
Download InfographicDownload Infographic

With an ERP tool like Netsuite you can keep track of many aspects of your business and make sure your team is performing their best and focused on doing work faster.

Another way you can improve your business processes is by using Formstack Documents to automatically populate document templates (contracts, quotes, letters, etc) with data from Netsuite.  You’ll never have to search for a template or copy & paste again.

In this example we’re going to show you how to automatically populate a quote when we add a new opportunity to Netsuite.  To help with the integration between Formstack Documents and Netsuite, we’re going to use our friends over at Workato.

To get started, we’re going to setup the template for our quote using a Word document.  Inside Word, we’re going to setup the repeating information in our quote like our logo, contact info, etc.  Then for the spots that we want to insert our customer/opportunity info, we’re going to use merge fields that look like {$OpportunityName}, {$Amount}, etc.

You can name these merge fields anything you’d like and we’ll connect them to the correct Netsuite fields using Workato.

Here’s what our quote template looks like:


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


After you’ve uploaded 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.  In this example, we’re going to produce a PDF document and include the name of the opportunity in the file name.


Next, we’re going to setup the delivery of our document so that is emailed directly to our customer for their review.  Under the Deliver tab, we’re going to edit the default email delivery.  For the “To” address, we’re going to use a merge field for our customer’s email address.

Feel free to edit any of the other email settings – you can use merge fields in any of those settings.


Once you have updated the email delivery, we are done with the setup process inside Formstack Documents, and we’re ready to setup the integration with Netsuite using Workato.

Inside Workato, we’re going to create a New Recipe.  For the trigger, we’re going to choose Netsuite as the app, then New Standard Object as the trigger.


Once you authenticate your Netsuite account, you’ll need to pick the standard object that you want to pull data from, so go ahead and pick the Opportunity object.


Next, we’re going to setup the action of our recipe.  Go ahead and choose WebMerge as the app then Merge Document as the action.


After you authenticate your Formstack Documents account, Workato is going to load a list of the documents in your account.  Go ahead and pick the template that you setup in Formstack Documents and Workato will load a list of the merge fields in your document.

For each merge field, you need to pick the corresponding field from Netsuite.  This tells Workato how to send 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 finish the recipe and then we’re ready for a test!  Login to Netsuite and add a new opportunity.  Workato will detect this new opportunity, send the data over to Formstack Documents , then your quote will be emailed out!

Here's what our test quote looked like:


Congrats, you’re all finished!  You can now automatically generate all kinds of document from Formstack Documents using Workato. Check out the video below to learn more about leveling up your document generation process with Formstack Documents.

With an ERP tool like Netsuite you can keep track of many aspects of your business and make sure your team is performing their best and focused on doing work faster.

Another way you can improve your business processes is by using Formstack Documents to automatically populate document templates (contracts, quotes, letters, etc) with data from Netsuite.  You’ll never have to search for a template or copy & paste again.

In this example we’re going to show you how to automatically populate a quote when we add a new opportunity to Netsuite.  To help with the integration between Formstack Documents and Netsuite, we’re going to use our friends over at Workato.

To get started, we’re going to setup the template for our quote using a Word document.  Inside Word, we’re going to setup the repeating information in our quote like our logo, contact info, etc.  Then for the spots that we want to insert our customer/opportunity info, we’re going to use merge fields that look like {$OpportunityName}, {$Amount}, etc.

You can name these merge fields anything you’d like and we’ll connect them to the correct Netsuite fields using Workato.

Here’s what our quote template looks like:


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


After you’ve uploaded 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.  In this example, we’re going to produce a PDF document and include the name of the opportunity in the file name.


Next, we’re going to setup the delivery of our document so that is emailed directly to our customer for their review.  Under the Deliver tab, we’re going to edit the default email delivery.  For the “To” address, we’re going to use a merge field for our customer’s email address.

Feel free to edit any of the other email settings – you can use merge fields in any of those settings.


Once you have updated the email delivery, we are done with the setup process inside Formstack Documents, and we’re ready to setup the integration with Netsuite using Workato.

Inside Workato, we’re going to create a New Recipe.  For the trigger, we’re going to choose Netsuite as the app, then New Standard Object as the trigger.


Once you authenticate your Netsuite account, you’ll need to pick the standard object that you want to pull data from, so go ahead and pick the Opportunity object.


Next, we’re going to setup the action of our recipe.  Go ahead and choose WebMerge as the app then Merge Document as the action.


After you authenticate your Formstack Documents account, Workato is going to load a list of the documents in your account.  Go ahead and pick the template that you setup in Formstack Documents and Workato will load a list of the merge fields in your document.

For each merge field, you need to pick the corresponding field from Netsuite.  This tells Workato how to send 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 finish the recipe and then we’re ready for a test!  Login to Netsuite and add a new opportunity.  Workato will detect this new opportunity, send the data over to Formstack Documents , then your quote will be emailed out!

Here's what our test quote looked like:


Congrats, you’re all finished!  You can now automatically generate all kinds of document from Formstack Documents using Workato. Check out the video below to learn more about leveling up your document generation process with Formstack Documents.

Collecting payments with online forms is easy, but first, you have to choose the right payment gateway. Browse the providers in our gateway credit card processing comparison chart to find the best option for your business. Then sign up for Formstack Forms, customize your payment forms, and start collecting profits in minutes.

Online Payment Gateway Comparison Chart

NOTE: These amounts reflect the monthly subscription for the payment provider. Formstack does not charge a fee to integrate with any of our payment partners.

FEATURES
Authorize.Net
Bambora
Chargify
First Data
PayPal
PayPal Pro
PayPal Payflow
Stripe
WePay
ProPay
Monthly Fees
$25
$25
$149+
Contact First Data
$0
$25
$0-$25
$0
$0
$4
Transaction Fees
$2.9% + 30¢
$2.9% + 30¢
N/A
Contact First Data
$2.9% + 30¢
$2.9% + 30¢
10¢
$2.9% + 30¢
$2.9% + 30¢
$2.6% + 30¢
Countries
5
8
Based on payment gateway
50+
203
3
4
25
USA
USA
Currencies
11
2
23
140
25
23
25
135+
1
1
Card Types
6
13
Based on payment gateway
5
9
9
5
6
4
4
Limits
None
None
Based on payment gateway
None
$10,000
None
None
None
None
$500 per transaction
Form Payments
Recurring Billing
Mobile Payments
PSD2 Compliant

With an ERP tool like Netsuite you can keep track of many aspects of your business and make sure your team is performing their best and focused on doing work faster.

Another way you can improve your business processes is by using Formstack Documents to automatically populate document templates (contracts, quotes, letters, etc) with data from Netsuite.  You’ll never have to search for a template or copy & paste again.

In this example we’re going to show you how to automatically populate a quote when we add a new opportunity to Netsuite.  To help with the integration between Formstack Documents and Netsuite, we’re going to use our friends over at Workato.

To get started, we’re going to setup the template for our quote using a Word document.  Inside Word, we’re going to setup the repeating information in our quote like our logo, contact info, etc.  Then for the spots that we want to insert our customer/opportunity info, we’re going to use merge fields that look like {$OpportunityName}, {$Amount}, etc.

You can name these merge fields anything you’d like and we’ll connect them to the correct Netsuite fields using Workato.

Here’s what our quote template looks like:


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


After you’ve uploaded 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.  In this example, we’re going to produce a PDF document and include the name of the opportunity in the file name.


Next, we’re going to setup the delivery of our document so that is emailed directly to our customer for their review.  Under the Deliver tab, we’re going to edit the default email delivery.  For the “To” address, we’re going to use a merge field for our customer’s email address.

Feel free to edit any of the other email settings – you can use merge fields in any of those settings.


Once you have updated the email delivery, we are done with the setup process inside Formstack Documents, and we’re ready to setup the integration with Netsuite using Workato.

Inside Workato, we’re going to create a New Recipe.  For the trigger, we’re going to choose Netsuite as the app, then New Standard Object as the trigger.


Once you authenticate your Netsuite account, you’ll need to pick the standard object that you want to pull data from, so go ahead and pick the Opportunity object.


Next, we’re going to setup the action of our recipe.  Go ahead and choose WebMerge as the app then Merge Document as the action.


After you authenticate your Formstack Documents account, Workato is going to load a list of the documents in your account.  Go ahead and pick the template that you setup in Formstack Documents and Workato will load a list of the merge fields in your document.

For each merge field, you need to pick the corresponding field from Netsuite.  This tells Workato how to send 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 finish the recipe and then we’re ready for a test!  Login to Netsuite and add a new opportunity.  Workato will detect this new opportunity, send the data over to Formstack Documents , then your quote will be emailed out!

Here's what our test quote looked like:


Congrats, you’re all finished!  You can now automatically generate all kinds of document from Formstack Documents using Workato. Check out the video below to learn more about leveling up your document generation process with Formstack Documents.

With an ERP tool like Netsuite you can keep track of many aspects of your business and make sure your team is performing their best and focused on doing work faster.

Another way you can improve your business processes is by using Formstack Documents to automatically populate document templates (contracts, quotes, letters, etc) with data from Netsuite.  You’ll never have to search for a template or copy & paste again.

In this example we’re going to show you how to automatically populate a quote when we add a new opportunity to Netsuite.  To help with the integration between Formstack Documents and Netsuite, we’re going to use our friends over at Workato.

To get started, we’re going to setup the template for our quote using a Word document.  Inside Word, we’re going to setup the repeating information in our quote like our logo, contact info, etc.  Then for the spots that we want to insert our customer/opportunity info, we’re going to use merge fields that look like {$OpportunityName}, {$Amount}, etc.

You can name these merge fields anything you’d like and we’ll connect them to the correct Netsuite fields using Workato.

Here’s what our quote template looks like:


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


After you’ve uploaded 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.  In this example, we’re going to produce a PDF document and include the name of the opportunity in the file name.


Next, we’re going to setup the delivery of our document so that is emailed directly to our customer for their review.  Under the Deliver tab, we’re going to edit the default email delivery.  For the “To” address, we’re going to use a merge field for our customer’s email address.

Feel free to edit any of the other email settings – you can use merge fields in any of those settings.


Once you have updated the email delivery, we are done with the setup process inside Formstack Documents, and we’re ready to setup the integration with Netsuite using Workato.

Inside Workato, we’re going to create a New Recipe.  For the trigger, we’re going to choose Netsuite as the app, then New Standard Object as the trigger.


Once you authenticate your Netsuite account, you’ll need to pick the standard object that you want to pull data from, so go ahead and pick the Opportunity object.


Next, we’re going to setup the action of our recipe.  Go ahead and choose WebMerge as the app then Merge Document as the action.


After you authenticate your Formstack Documents account, Workato is going to load a list of the documents in your account.  Go ahead and pick the template that you setup in Formstack Documents and Workato will load a list of the merge fields in your document.

For each merge field, you need to pick the corresponding field from Netsuite.  This tells Workato how to send 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 finish the recipe and then we’re ready for a test!  Login to Netsuite and add a new opportunity.  Workato will detect this new opportunity, send the data over to Formstack Documents , then your quote will be emailed out!

Here's what our test quote looked like:


Congrats, you’re all finished!  You can now automatically generate all kinds of document from Formstack Documents using Workato. Check out the video below to learn more about leveling up your document generation process with Formstack Documents.

With an ERP tool like Netsuite you can keep track of many aspects of your business and make sure your team is performing their best and focused on doing work faster.

Another way you can improve your business processes is by using Formstack Documents to automatically populate document templates (contracts, quotes, letters, etc) with data from Netsuite.  You’ll never have to search for a template or copy & paste again.

In this example we’re going to show you how to automatically populate a quote when we add a new opportunity to Netsuite.  To help with the integration between Formstack Documents and Netsuite, we’re going to use our friends over at Workato.

To get started, we’re going to setup the template for our quote using a Word document.  Inside Word, we’re going to setup the repeating information in our quote like our logo, contact info, etc.  Then for the spots that we want to insert our customer/opportunity info, we’re going to use merge fields that look like {$OpportunityName}, {$Amount}, etc.

You can name these merge fields anything you’d like and we’ll connect them to the correct Netsuite fields using Workato.

Here’s what our quote template looks like:


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


After you’ve uploaded 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.  In this example, we’re going to produce a PDF document and include the name of the opportunity in the file name.


Next, we’re going to setup the delivery of our document so that is emailed directly to our customer for their review.  Under the Deliver tab, we’re going to edit the default email delivery.  For the “To” address, we’re going to use a merge field for our customer’s email address.

Feel free to edit any of the other email settings – you can use merge fields in any of those settings.


Once you have updated the email delivery, we are done with the setup process inside Formstack Documents, and we’re ready to setup the integration with Netsuite using Workato.

Inside Workato, we’re going to create a New Recipe.  For the trigger, we’re going to choose Netsuite as the app, then New Standard Object as the trigger.


Once you authenticate your Netsuite account, you’ll need to pick the standard object that you want to pull data from, so go ahead and pick the Opportunity object.


Next, we’re going to setup the action of our recipe.  Go ahead and choose WebMerge as the app then Merge Document as the action.


After you authenticate your Formstack Documents account, Workato is going to load a list of the documents in your account.  Go ahead and pick the template that you setup in Formstack Documents and Workato will load a list of the merge fields in your document.

For each merge field, you need to pick the corresponding field from Netsuite.  This tells Workato how to send 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 finish the recipe and then we’re ready for a test!  Login to Netsuite and add a new opportunity.  Workato will detect this new opportunity, send the data over to Formstack Documents , then your quote will be emailed out!

Here's what our test quote looked like:


Congrats, you’re all finished!  You can now automatically generate all kinds of document from Formstack Documents using Workato. Check out the video below to learn more about leveling up your document generation process with Formstack Documents.

With an ERP tool like Netsuite you can keep track of many aspects of your business and make sure your team is performing their best and focused on doing work faster.

Another way you can improve your business processes is by using Formstack Documents to automatically populate document templates (contracts, quotes, letters, etc) with data from Netsuite.  You’ll never have to search for a template or copy & paste again.

In this example we’re going to show you how to automatically populate a quote when we add a new opportunity to Netsuite.  To help with the integration between Formstack Documents and Netsuite, we’re going to use our friends over at Workato.

To get started, we’re going to setup the template for our quote using a Word document.  Inside Word, we’re going to setup the repeating information in our quote like our logo, contact info, etc.  Then for the spots that we want to insert our customer/opportunity info, we’re going to use merge fields that look like {$OpportunityName}, {$Amount}, etc.

You can name these merge fields anything you’d like and we’ll connect them to the correct Netsuite fields using Workato.

Here’s what our quote template looks like:


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


After you’ve uploaded 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.  In this example, we’re going to produce a PDF document and include the name of the opportunity in the file name.


Next, we’re going to setup the delivery of our document so that is emailed directly to our customer for their review.  Under the Deliver tab, we’re going to edit the default email delivery.  For the “To” address, we’re going to use a merge field for our customer’s email address.

Feel free to edit any of the other email settings – you can use merge fields in any of those settings.


Once you have updated the email delivery, we are done with the setup process inside Formstack Documents, and we’re ready to setup the integration with Netsuite using Workato.

Inside Workato, we’re going to create a New Recipe.  For the trigger, we’re going to choose Netsuite as the app, then New Standard Object as the trigger.


Once you authenticate your Netsuite account, you’ll need to pick the standard object that you want to pull data from, so go ahead and pick the Opportunity object.


Next, we’re going to setup the action of our recipe.  Go ahead and choose WebMerge as the app then Merge Document as the action.


After you authenticate your Formstack Documents account, Workato is going to load a list of the documents in your account.  Go ahead and pick the template that you setup in Formstack Documents and Workato will load a list of the merge fields in your document.

For each merge field, you need to pick the corresponding field from Netsuite.  This tells Workato how to send 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 finish the recipe and then we’re ready for a test!  Login to Netsuite and add a new opportunity.  Workato will detect this new opportunity, send the data over to Formstack Documents , then your quote will be emailed out!

Here's what our test quote looked like:


Congrats, you’re all finished!  You can now automatically generate all kinds of document from Formstack Documents using Workato. Check out the video below to learn more about leveling up your document generation process with Formstack Documents.

With an ERP tool like Netsuite you can keep track of many aspects of your business and make sure your team is performing their best and focused on doing work faster.

Another way you can improve your business processes is by using Formstack Documents to automatically populate document templates (contracts, quotes, letters, etc) with data from Netsuite.  You’ll never have to search for a template or copy & paste again.

In this example we’re going to show you how to automatically populate a quote when we add a new opportunity to Netsuite.  To help with the integration between Formstack Documents and Netsuite, we’re going to use our friends over at Workato.

To get started, we’re going to setup the template for our quote using a Word document.  Inside Word, we’re going to setup the repeating information in our quote like our logo, contact info, etc.  Then for the spots that we want to insert our customer/opportunity info, we’re going to use merge fields that look like {$OpportunityName}, {$Amount}, etc.

You can name these merge fields anything you’d like and we’ll connect them to the correct Netsuite fields using Workato.

Here’s what our quote template looks like:


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


After you’ve uploaded 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.  In this example, we’re going to produce a PDF document and include the name of the opportunity in the file name.


Next, we’re going to setup the delivery of our document so that is emailed directly to our customer for their review.  Under the Deliver tab, we’re going to edit the default email delivery.  For the “To” address, we’re going to use a merge field for our customer’s email address.

Feel free to edit any of the other email settings – you can use merge fields in any of those settings.


Once you have updated the email delivery, we are done with the setup process inside Formstack Documents, and we’re ready to setup the integration with Netsuite using Workato.

Inside Workato, we’re going to create a New Recipe.  For the trigger, we’re going to choose Netsuite as the app, then New Standard Object as the trigger.


Once you authenticate your Netsuite account, you’ll need to pick the standard object that you want to pull data from, so go ahead and pick the Opportunity object.


Next, we’re going to setup the action of our recipe.  Go ahead and choose WebMerge as the app then Merge Document as the action.


After you authenticate your Formstack Documents account, Workato is going to load a list of the documents in your account.  Go ahead and pick the template that you setup in Formstack Documents and Workato will load a list of the merge fields in your document.

For each merge field, you need to pick the corresponding field from Netsuite.  This tells Workato how to send 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 finish the recipe and then we’re ready for a test!  Login to Netsuite and add a new opportunity.  Workato will detect this new opportunity, send the data over to Formstack Documents , then your quote will be emailed out!

Here's what our test quote looked like:


Congrats, you’re all finished!  You can now automatically generate all kinds of document from Formstack Documents using Workato. Check out the video below to learn more about leveling up your document generation process with Formstack Documents.

Lacey Jackson
As a Product Marketing Manager at Formstack, Lacey is dedicated to creating content that showcases the power of the Formstack platform. When she’s not creating Formstack Builders tutorials, she can be found reading, playing board games, or strolling with her dog. Lacey is a graduate of Franklin College.
More Articles
Meet The Host
CEO of
Connect
Chris is on a mission to turn people into great leaders. He's passionate about helping problem solvers see more value in the work they do every day.