Blog

Automatically Populate Quotes from Google Forms

Blog

Automatically Populate Quotes from Google Forms

Blog

Automatically Populate Quotes from Google Forms

Blog

Automatically Populate Quotes from Google Forms

Blog

Automatically Populate Quotes from Google Forms

Download PDFDownload PDF
Blog

Automatically Populate Quotes from Google Forms

Formstack
/
June 22, 2017
Blog

Automatically Populate Quotes from Google Forms

MIN
/
June 22, 2017
About the Episode
Episode Highlights
Meet our Guest
Episode Transcript

With a tool like Google Forms, you can easily collect data from customers and new leads, right on your website.  You’ll never have to write down information over the phone again!

Add Formstack Documents to the process, and you can automatically take information from your Google Forms and populate various templates like contracts, invoices, quotes, and more.  Take the pain out of paperwork and spend more time on your business.

In this example, we’re going to show you how to automatically generate a quote from Google Forms.  We’ll then instantly send this quote document directly to our customer for review and approval.

To get started, we’re going to setup the template for our quote.  We’re going to build this template inside Formstack Documents using the Document Builder. Inside Formstack Documents, click the New Document button and give your document a title.  When you're prompted to "Choose Your Document Type," select "Build Your Own."



In the Document Builder, we’re going to add our logo, contact information, and any other repeating information that we want to have in our template.  For the spots that we want to insert our customer’s information, we’re going to use merge fields that look like {$Name}, {$Phone_Number}, etc.

You can name these fields anything you’d like (we’ll match them up to your form fields later).  We suggest something short and descriptive.

Here’s what our quote template looks like:



Once we have our template finished, we can save and move on to the Settings tab.  Here, we can modify various options like the type of file that we want to generate and the name of the file.  For this example, we’re going to produce a PDF document and include the name of our customer in the file name.


Next, we’re going to setup the delivery of our document so that it is automatically emailed directly to our customer.  From the Deliver tab, we’re going to Edit the default email delivery.  For the “To” address, we’re going to use a merge field that will match up to the person’s email address.

Feel free to edit any of the other email settings and you can use merge fields there too.



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

Inside Zapier, we’re going to setup a New Zap.  For the Trigger, we’re going to choose Google Forms as the app, then New Response in Spreadsheet as the trigger.



Once we authenticate our Google account, Zapier is going to load a list of the forms in our account.  Go ahead and pick the form you’d like to send data from over to Formstack Documents. Next, we’re going to setup the Action of our Zap.  For the app, 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 account.  Go ahead and pick the quote document that you just setup and Zapier will load a list of the merge fields in your template.

For each of the merge fields, you need to pick the corresponding fields from your Google Form.  This tells Zapier how to send the form response 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 and turn it on.  We’re ready for a test!  Open your form and submit a new response.  Zapier will detect the new response and send your data over to Formstack Documents and your quote will be populated.



Congrats, you’re finished! You can now automatically populate all kinds of documents from your Google Forms. Can you think of any other ways you can use Formstack Documents to simplify your paperwork process?

Blog

Automatically Populate Quotes from Google Forms

Blog

Automatically Populate Quotes from Google Forms

Get the Report

Not a valid e-mail address

Great, thank ya!

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

Automatically Populate Quotes from Google Forms

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 a tool like Google Forms, you can easily collect data from customers and new leads, right on your website.  You’ll never have to write down information over the phone again!

Add Formstack Documents to the process, and you can automatically take information from your Google Forms and populate various templates like contracts, invoices, quotes, and more.  Take the pain out of paperwork and spend more time on your business.

In this example, we’re going to show you how to automatically generate a quote from Google Forms.  We’ll then instantly send this quote document directly to our customer for review and approval.

To get started, we’re going to setup the template for our quote.  We’re going to build this template inside Formstack Documents using the Document Builder. Inside Formstack Documents, click the New Document button and give your document a title.  When you're prompted to "Choose Your Document Type," select "Build Your Own."



In the Document Builder, we’re going to add our logo, contact information, and any other repeating information that we want to have in our template.  For the spots that we want to insert our customer’s information, we’re going to use merge fields that look like {$Name}, {$Phone_Number}, etc.

You can name these fields anything you’d like (we’ll match them up to your form fields later).  We suggest something short and descriptive.

Here’s what our quote template looks like:



Once we have our template finished, we can save and move on to the Settings tab.  Here, we can modify various options like the type of file that we want to generate and the name of the file.  For this example, we’re going to produce a PDF document and include the name of our customer in the file name.


Next, we’re going to setup the delivery of our document so that it is automatically emailed directly to our customer.  From the Deliver tab, we’re going to Edit the default email delivery.  For the “To” address, we’re going to use a merge field that will match up to the person’s email address.

Feel free to edit any of the other email settings and you can use merge fields there too.



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

Inside Zapier, we’re going to setup a New Zap.  For the Trigger, we’re going to choose Google Forms as the app, then New Response in Spreadsheet as the trigger.



Once we authenticate our Google account, Zapier is going to load a list of the forms in our account.  Go ahead and pick the form you’d like to send data from over to Formstack Documents. Next, we’re going to setup the Action of our Zap.  For the app, 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 account.  Go ahead and pick the quote document that you just setup and Zapier will load a list of the merge fields in your template.

For each of the merge fields, you need to pick the corresponding fields from your Google Form.  This tells Zapier how to send the form response 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 and turn it on.  We’re ready for a test!  Open your form and submit a new response.  Zapier will detect the new response and send your data over to Formstack Documents and your quote will be populated.



Congrats, you’re finished! You can now automatically populate all kinds of documents from your Google Forms. Can you think of any other ways you can use Formstack Documents to simplify your paperwork process?

Panelists
No items found.
Infographic

Automatically Populate Quotes from Google Forms

Learn how to automatically populate quotes, contracts, reports, and more from Google Forms.
Download InfographicDownload Infographic

With a tool like Google Forms, you can easily collect data from customers and new leads, right on your website.  You’ll never have to write down information over the phone again!

Add Formstack Documents to the process, and you can automatically take information from your Google Forms and populate various templates like contracts, invoices, quotes, and more.  Take the pain out of paperwork and spend more time on your business.

In this example, we’re going to show you how to automatically generate a quote from Google Forms.  We’ll then instantly send this quote document directly to our customer for review and approval.

To get started, we’re going to setup the template for our quote.  We’re going to build this template inside Formstack Documents using the Document Builder. Inside Formstack Documents, click the New Document button and give your document a title.  When you're prompted to "Choose Your Document Type," select "Build Your Own."



In the Document Builder, we’re going to add our logo, contact information, and any other repeating information that we want to have in our template.  For the spots that we want to insert our customer’s information, we’re going to use merge fields that look like {$Name}, {$Phone_Number}, etc.

You can name these fields anything you’d like (we’ll match them up to your form fields later).  We suggest something short and descriptive.

Here’s what our quote template looks like:



Once we have our template finished, we can save and move on to the Settings tab.  Here, we can modify various options like the type of file that we want to generate and the name of the file.  For this example, we’re going to produce a PDF document and include the name of our customer in the file name.


Next, we’re going to setup the delivery of our document so that it is automatically emailed directly to our customer.  From the Deliver tab, we’re going to Edit the default email delivery.  For the “To” address, we’re going to use a merge field that will match up to the person’s email address.

Feel free to edit any of the other email settings and you can use merge fields there too.



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

Inside Zapier, we’re going to setup a New Zap.  For the Trigger, we’re going to choose Google Forms as the app, then New Response in Spreadsheet as the trigger.



Once we authenticate our Google account, Zapier is going to load a list of the forms in our account.  Go ahead and pick the form you’d like to send data from over to Formstack Documents. Next, we’re going to setup the Action of our Zap.  For the app, 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 account.  Go ahead and pick the quote document that you just setup and Zapier will load a list of the merge fields in your template.

For each of the merge fields, you need to pick the corresponding fields from your Google Form.  This tells Zapier how to send the form response 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 and turn it on.  We’re ready for a test!  Open your form and submit a new response.  Zapier will detect the new response and send your data over to Formstack Documents and your quote will be populated.



Congrats, you’re finished! You can now automatically populate all kinds of documents from your Google Forms. Can you think of any other ways you can use Formstack Documents to simplify your paperwork process?

With a tool like Google Forms, you can easily collect data from customers and new leads, right on your website.  You’ll never have to write down information over the phone again!

Add Formstack Documents to the process, and you can automatically take information from your Google Forms and populate various templates like contracts, invoices, quotes, and more.  Take the pain out of paperwork and spend more time on your business.

In this example, we’re going to show you how to automatically generate a quote from Google Forms.  We’ll then instantly send this quote document directly to our customer for review and approval.

To get started, we’re going to setup the template for our quote.  We’re going to build this template inside Formstack Documents using the Document Builder. Inside Formstack Documents, click the New Document button and give your document a title.  When you're prompted to "Choose Your Document Type," select "Build Your Own."



In the Document Builder, we’re going to add our logo, contact information, and any other repeating information that we want to have in our template.  For the spots that we want to insert our customer’s information, we’re going to use merge fields that look like {$Name}, {$Phone_Number}, etc.

You can name these fields anything you’d like (we’ll match them up to your form fields later).  We suggest something short and descriptive.

Here’s what our quote template looks like:



Once we have our template finished, we can save and move on to the Settings tab.  Here, we can modify various options like the type of file that we want to generate and the name of the file.  For this example, we’re going to produce a PDF document and include the name of our customer in the file name.


Next, we’re going to setup the delivery of our document so that it is automatically emailed directly to our customer.  From the Deliver tab, we’re going to Edit the default email delivery.  For the “To” address, we’re going to use a merge field that will match up to the person’s email address.

Feel free to edit any of the other email settings and you can use merge fields there too.



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

Inside Zapier, we’re going to setup a New Zap.  For the Trigger, we’re going to choose Google Forms as the app, then New Response in Spreadsheet as the trigger.



Once we authenticate our Google account, Zapier is going to load a list of the forms in our account.  Go ahead and pick the form you’d like to send data from over to Formstack Documents. Next, we’re going to setup the Action of our Zap.  For the app, 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 account.  Go ahead and pick the quote document that you just setup and Zapier will load a list of the merge fields in your template.

For each of the merge fields, you need to pick the corresponding fields from your Google Form.  This tells Zapier how to send the form response 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 and turn it on.  We’re ready for a test!  Open your form and submit a new response.  Zapier will detect the new response and send your data over to Formstack Documents and your quote will be populated.



Congrats, you’re finished! You can now automatically populate all kinds of documents from your Google Forms. Can you think of any other ways you can use Formstack Documents to simplify your paperwork process?

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
Monthly Fees
$25
$25
$149+
Contact First Data
$0
$25
$0-$25
$0
$0
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¢
Countries
5
8
Based on payment gateway
50+
203
3
4
25
USA
Currencies
11
2
23
140
25
23
25
135+
1
Card Types
6
13
Based on payment gateway
5
9
9
5
6
4
Limits
None
None
Based on payment gateway
None
$10,000
None
None
None
None
Form Payments
Recurring Billing
Mobile Payments
PSD2 Compliant

With a tool like Google Forms, you can easily collect data from customers and new leads, right on your website.  You’ll never have to write down information over the phone again!

Add Formstack Documents to the process, and you can automatically take information from your Google Forms and populate various templates like contracts, invoices, quotes, and more.  Take the pain out of paperwork and spend more time on your business.

In this example, we’re going to show you how to automatically generate a quote from Google Forms.  We’ll then instantly send this quote document directly to our customer for review and approval.

To get started, we’re going to setup the template for our quote.  We’re going to build this template inside Formstack Documents using the Document Builder. Inside Formstack Documents, click the New Document button and give your document a title.  When you're prompted to "Choose Your Document Type," select "Build Your Own."



In the Document Builder, we’re going to add our logo, contact information, and any other repeating information that we want to have in our template.  For the spots that we want to insert our customer’s information, we’re going to use merge fields that look like {$Name}, {$Phone_Number}, etc.

You can name these fields anything you’d like (we’ll match them up to your form fields later).  We suggest something short and descriptive.

Here’s what our quote template looks like:



Once we have our template finished, we can save and move on to the Settings tab.  Here, we can modify various options like the type of file that we want to generate and the name of the file.  For this example, we’re going to produce a PDF document and include the name of our customer in the file name.


Next, we’re going to setup the delivery of our document so that it is automatically emailed directly to our customer.  From the Deliver tab, we’re going to Edit the default email delivery.  For the “To” address, we’re going to use a merge field that will match up to the person’s email address.

Feel free to edit any of the other email settings and you can use merge fields there too.



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

Inside Zapier, we’re going to setup a New Zap.  For the Trigger, we’re going to choose Google Forms as the app, then New Response in Spreadsheet as the trigger.



Once we authenticate our Google account, Zapier is going to load a list of the forms in our account.  Go ahead and pick the form you’d like to send data from over to Formstack Documents. Next, we’re going to setup the Action of our Zap.  For the app, 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 account.  Go ahead and pick the quote document that you just setup and Zapier will load a list of the merge fields in your template.

For each of the merge fields, you need to pick the corresponding fields from your Google Form.  This tells Zapier how to send the form response 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 and turn it on.  We’re ready for a test!  Open your form and submit a new response.  Zapier will detect the new response and send your data over to Formstack Documents and your quote will be populated.



Congrats, you’re finished! You can now automatically populate all kinds of documents from your Google Forms. Can you think of any other ways you can use Formstack Documents to simplify your paperwork process?

With a tool like Google Forms, you can easily collect data from customers and new leads, right on your website.  You’ll never have to write down information over the phone again!

Add Formstack Documents to the process, and you can automatically take information from your Google Forms and populate various templates like contracts, invoices, quotes, and more.  Take the pain out of paperwork and spend more time on your business.

In this example, we’re going to show you how to automatically generate a quote from Google Forms.  We’ll then instantly send this quote document directly to our customer for review and approval.

To get started, we’re going to setup the template for our quote.  We’re going to build this template inside Formstack Documents using the Document Builder. Inside Formstack Documents, click the New Document button and give your document a title.  When you're prompted to "Choose Your Document Type," select "Build Your Own."



In the Document Builder, we’re going to add our logo, contact information, and any other repeating information that we want to have in our template.  For the spots that we want to insert our customer’s information, we’re going to use merge fields that look like {$Name}, {$Phone_Number}, etc.

You can name these fields anything you’d like (we’ll match them up to your form fields later).  We suggest something short and descriptive.

Here’s what our quote template looks like:



Once we have our template finished, we can save and move on to the Settings tab.  Here, we can modify various options like the type of file that we want to generate and the name of the file.  For this example, we’re going to produce a PDF document and include the name of our customer in the file name.


Next, we’re going to setup the delivery of our document so that it is automatically emailed directly to our customer.  From the Deliver tab, we’re going to Edit the default email delivery.  For the “To” address, we’re going to use a merge field that will match up to the person’s email address.

Feel free to edit any of the other email settings and you can use merge fields there too.



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

Inside Zapier, we’re going to setup a New Zap.  For the Trigger, we’re going to choose Google Forms as the app, then New Response in Spreadsheet as the trigger.



Once we authenticate our Google account, Zapier is going to load a list of the forms in our account.  Go ahead and pick the form you’d like to send data from over to Formstack Documents. Next, we’re going to setup the Action of our Zap.  For the app, 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 account.  Go ahead and pick the quote document that you just setup and Zapier will load a list of the merge fields in your template.

For each of the merge fields, you need to pick the corresponding fields from your Google Form.  This tells Zapier how to send the form response 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 and turn it on.  We’re ready for a test!  Open your form and submit a new response.  Zapier will detect the new response and send your data over to Formstack Documents and your quote will be populated.



Congrats, you’re finished! You can now automatically populate all kinds of documents from your Google Forms. Can you think of any other ways you can use Formstack Documents to simplify your paperwork process?

With a tool like Google Forms, you can easily collect data from customers and new leads, right on your website.  You’ll never have to write down information over the phone again!

Add Formstack Documents to the process, and you can automatically take information from your Google Forms and populate various templates like contracts, invoices, quotes, and more.  Take the pain out of paperwork and spend more time on your business.

In this example, we’re going to show you how to automatically generate a quote from Google Forms.  We’ll then instantly send this quote document directly to our customer for review and approval.

To get started, we’re going to setup the template for our quote.  We’re going to build this template inside Formstack Documents using the Document Builder. Inside Formstack Documents, click the New Document button and give your document a title.  When you're prompted to "Choose Your Document Type," select "Build Your Own."



In the Document Builder, we’re going to add our logo, contact information, and any other repeating information that we want to have in our template.  For the spots that we want to insert our customer’s information, we’re going to use merge fields that look like {$Name}, {$Phone_Number}, etc.

You can name these fields anything you’d like (we’ll match them up to your form fields later).  We suggest something short and descriptive.

Here’s what our quote template looks like:



Once we have our template finished, we can save and move on to the Settings tab.  Here, we can modify various options like the type of file that we want to generate and the name of the file.  For this example, we’re going to produce a PDF document and include the name of our customer in the file name.


Next, we’re going to setup the delivery of our document so that it is automatically emailed directly to our customer.  From the Deliver tab, we’re going to Edit the default email delivery.  For the “To” address, we’re going to use a merge field that will match up to the person’s email address.

Feel free to edit any of the other email settings and you can use merge fields there too.



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

Inside Zapier, we’re going to setup a New Zap.  For the Trigger, we’re going to choose Google Forms as the app, then New Response in Spreadsheet as the trigger.



Once we authenticate our Google account, Zapier is going to load a list of the forms in our account.  Go ahead and pick the form you’d like to send data from over to Formstack Documents. Next, we’re going to setup the Action of our Zap.  For the app, 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 account.  Go ahead and pick the quote document that you just setup and Zapier will load a list of the merge fields in your template.

For each of the merge fields, you need to pick the corresponding fields from your Google Form.  This tells Zapier how to send the form response 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 and turn it on.  We’re ready for a test!  Open your form and submit a new response.  Zapier will detect the new response and send your data over to Formstack Documents and your quote will be populated.



Congrats, you’re finished! You can now automatically populate all kinds of documents from your Google Forms. Can you think of any other ways you can use Formstack Documents to simplify your paperwork process?

With a tool like Google Forms, you can easily collect data from customers and new leads, right on your website.  You’ll never have to write down information over the phone again!

Add Formstack Documents to the process, and you can automatically take information from your Google Forms and populate various templates like contracts, invoices, quotes, and more.  Take the pain out of paperwork and spend more time on your business.

In this example, we’re going to show you how to automatically generate a quote from Google Forms.  We’ll then instantly send this quote document directly to our customer for review and approval.

To get started, we’re going to setup the template for our quote.  We’re going to build this template inside Formstack Documents using the Document Builder. Inside Formstack Documents, click the New Document button and give your document a title.  When you're prompted to "Choose Your Document Type," select "Build Your Own."



In the Document Builder, we’re going to add our logo, contact information, and any other repeating information that we want to have in our template.  For the spots that we want to insert our customer’s information, we’re going to use merge fields that look like {$Name}, {$Phone_Number}, etc.

You can name these fields anything you’d like (we’ll match them up to your form fields later).  We suggest something short and descriptive.

Here’s what our quote template looks like:



Once we have our template finished, we can save and move on to the Settings tab.  Here, we can modify various options like the type of file that we want to generate and the name of the file.  For this example, we’re going to produce a PDF document and include the name of our customer in the file name.


Next, we’re going to setup the delivery of our document so that it is automatically emailed directly to our customer.  From the Deliver tab, we’re going to Edit the default email delivery.  For the “To” address, we’re going to use a merge field that will match up to the person’s email address.

Feel free to edit any of the other email settings and you can use merge fields there too.



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

Inside Zapier, we’re going to setup a New Zap.  For the Trigger, we’re going to choose Google Forms as the app, then New Response in Spreadsheet as the trigger.



Once we authenticate our Google account, Zapier is going to load a list of the forms in our account.  Go ahead and pick the form you’d like to send data from over to Formstack Documents. Next, we’re going to setup the Action of our Zap.  For the app, 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 account.  Go ahead and pick the quote document that you just setup and Zapier will load a list of the merge fields in your template.

For each of the merge fields, you need to pick the corresponding fields from your Google Form.  This tells Zapier how to send the form response 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 and turn it on.  We’re ready for a test!  Open your form and submit a new response.  Zapier will detect the new response and send your data over to Formstack Documents and your quote will be populated.



Congrats, you’re finished! You can now automatically populate all kinds of documents from your Google Forms. Can you think of any other ways you can use Formstack Documents to simplify your paperwork process?

With a tool like Google Forms, you can easily collect data from customers and new leads, right on your website.  You’ll never have to write down information over the phone again!

Add Formstack Documents to the process, and you can automatically take information from your Google Forms and populate various templates like contracts, invoices, quotes, and more.  Take the pain out of paperwork and spend more time on your business.

In this example, we’re going to show you how to automatically generate a quote from Google Forms.  We’ll then instantly send this quote document directly to our customer for review and approval.

To get started, we’re going to setup the template for our quote.  We’re going to build this template inside Formstack Documents using the Document Builder. Inside Formstack Documents, click the New Document button and give your document a title.  When you're prompted to "Choose Your Document Type," select "Build Your Own."



In the Document Builder, we’re going to add our logo, contact information, and any other repeating information that we want to have in our template.  For the spots that we want to insert our customer’s information, we’re going to use merge fields that look like {$Name}, {$Phone_Number}, etc.

You can name these fields anything you’d like (we’ll match them up to your form fields later).  We suggest something short and descriptive.

Here’s what our quote template looks like:



Once we have our template finished, we can save and move on to the Settings tab.  Here, we can modify various options like the type of file that we want to generate and the name of the file.  For this example, we’re going to produce a PDF document and include the name of our customer in the file name.


Next, we’re going to setup the delivery of our document so that it is automatically emailed directly to our customer.  From the Deliver tab, we’re going to Edit the default email delivery.  For the “To” address, we’re going to use a merge field that will match up to the person’s email address.

Feel free to edit any of the other email settings and you can use merge fields there too.



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

Inside Zapier, we’re going to setup a New Zap.  For the Trigger, we’re going to choose Google Forms as the app, then New Response in Spreadsheet as the trigger.



Once we authenticate our Google account, Zapier is going to load a list of the forms in our account.  Go ahead and pick the form you’d like to send data from over to Formstack Documents. Next, we’re going to setup the Action of our Zap.  For the app, 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 account.  Go ahead and pick the quote document that you just setup and Zapier will load a list of the merge fields in your template.

For each of the merge fields, you need to pick the corresponding fields from your Google Form.  This tells Zapier how to send the form response 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 and turn it on.  We’re ready for a test!  Open your form and submit a new response.  Zapier will detect the new response and send your data over to Formstack Documents and your quote will be populated.



Congrats, you’re finished! You can now automatically populate all kinds of documents from your Google Forms. Can you think of any other ways you can use Formstack Documents to simplify your paperwork process?

Formstack
Formstack is a SaaS company with a mission to help organizations digitize what matters, automate workflows, and fix processes—all without code. A variety of team members come together to compile posts under Formstack's authorship.
More Articles
Meet The Host
Content Marketing Manager
Connect
Lindsay is a writer with a background in journalism and loves getting to flex her interview skills as host of Practically Genius. She manages Formstack's blog and long-form reports, like the 2022 State of Digital Maturity: Advancing Workflow Automation.