Smartsheet is a pretty cool tool that allows you to easily collect data from customers and team members, plus offering an easy platform to manage that information.  It’s like Excel, but on steroids.  In this example, we’re going to show you how to send an invoice created with Formstack Documents directly from Smartsheet as a new order is entered into our sheet.

The first thing we are going to do is setup our document (template) inside Formstack Documents.  We going to use the online document builder, so when creating a new document choose the “Build Your Own” option.  In our document we’re going to include our merge field tags like {$CustomerName}, {$CustomerAddress}, etc.  This is where the data from our Smartsheet is going to be placed.  Here’s what our invoice looks like:


After we’ve got our document built, let’s go ahead and setup the Delivery of the document so that it is emailed directly to our customer.  Go ahead and jump over to the Deliver tab and you should see an email delivery already setup.  This is there by default and we’re just going to edit those settings.

After clicking the Edit button next to the email delivery you should see all the settings in a popup.  Feel free to change any of the settings, but what we’re going to focus on is the “To” address.  We’re going to select the Merge Field option then pick our merge field that corresponds to the customer’s email address.  If you didn’t add an email address to the invoice, go ahead and select <<other>> then enter {$email_to} in the box.  This is going to setup a new merge field, even though it isn’t in your document.


Great news!  We’re ready to integrate our Smartsheet with your newly created invoice template.  To help with the integration, we’re going to use a service called Zapier, which is an API connector service that makes it super easy to send data between hundreds of web applications/services.

To setup the integration, go ahead and login to your Zapier account then create a New Zap.  For the “trigger” we’re going to select Smartsheet and then we’ll choose the “New Row” option.  For the action, go ahead and pick Formstack Documents and then “Create Document Merge”.


The next step is going to ask you to authenticate your Smartsheet and Formstack Documents accounts.  This will give Zapier access to be able to send the data between Smartsheet and Formstack Documents.  After you’ve setup the accounts, you’re going to have to pick which Smartsheet you want to integrate with.



Once you pick the sheet, go to the step where you pick your Formstack Documents document and select the Invoice you just created.

After you select your document, Zapier is going to load a list of the merge fields that you used in that template and it gives you an option to “map” your Smartsheet fields (columns) to the corresponding Formstack Documents fields.  This tells Zapier how to send your data to Formstack Documents so that the information is placed in the correct spot on your invoice.

Perfection, you’re ready to do a quick test!  In the last step Zapier gives you an option to run a test zap.  This will load sample data from Smartsheet and then allow you to automatically send that to Formstack Documents.  Go ahead and do that test and make any adjustments to your document or the integration that you see are needed.  Here’s what our invoice looks like:

Once you save the Zap, you’re all done!  Now every time a new row is added to that sheet, it’s going to automatically be sent over to Formstack Documents and we’ll generate the invoice.  As Ron Popeil says, “Set it and forget it!”

Can you think of other ways that you could use Formstack Documents and Smartsheet to simplify your paperwork processes?  You’ll be an office hero!

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


  • Is there anyway to insert images from "attachments" in Smartsheet to a document? PDF or otherwise?
    Thank you,

  • Hi Brandy,

    When setting up your Zap, do you see the attachments as an option in the Smartsheet fields? Unfortunately, we're limited to the data that Zapier sends over to our system, so if they can't send them over then we can't use them.

    That being said, if you can save a URL to the file(s) in Smartsheet, then you can use Data Routing to grab the files and include in the merge process.



Please sign in to leave a comment.