Help & Support
Send Feedback
Smartsheet Merge
Easily create custom invoices, letters or other documents from Smartsheet data using a Google Doc as a template
Smartsheet, Inc.
362,537 users
Works with
Creating invoices, form letters, envelopes, or other documents from your Smartsheet data is now a breeze with Smartsheet Merge.  Use Google Docs to design a custom template to fit your needs, point it at your data in Smartsheet, and quickly create any number of personalized documents.

Smartsheet allows you to collaboratively collect and track lists, names, addresses, and other information. Smartsheet Merge gives you the power to merge that data into a custom Google Doc that acts as a template and create multiple Google documents in a snap. It’s like a mail merge but with real-time collaboration and no version control issues. 

Smartsheet is a cloud-based collaboration and work management tool that’s easy to use as a spreadsheet, yet powerful enough to drive any process or project. Over 50,000 businesses of all sizes use Smartsheet to coordinate anything, from major sporting events and new store openings, to help desk ticketing and marketing campaigns.

Start a FREE 30-day Smartsheet trial today. Paid plans start as low as $14/month. 
November 14, 2016
great great
Submit reply
December 5, 2015
I didnt realize that this only works with THEIR spreadsheets... not existing google sheet documents...
Submit reply
November 4, 2015
I'd like to be able to save my Merge selections in a template: whenever I select this template, merge the lines with a flag in a flag column from Smartsheet X to doc Y. OR merge all rows from a report and only just from the columns that I have saved in my Merge Template. In other words, I don't want to have to pick from the huge list of rows in a Smartsheet each and every row to merge into my google doc every time I want to do the merge. I would also like to be able to do this from multiple sheets at the same time (which makes the merge from report option more attractive). An example of this would be: send out invoices that have a "not paid" status associated with it. A month later, please do the same task which will mean new invoices generated along with some that were also generated last month, because they weren't paid.
Submit reply
November 25, 2015
Try creating a new sheet in Smartsheet that links to the specific rows you want from your original sheet (as well as any others you want to link from). Save this new sheet as your template for use in your merges going forward. Then, each month, before running the merge, you can apply a filter on the 'not paid' column and save.
March 25, 2015
Would really like to be able to save my export choices so I don't have to reenter them every time. Otherwise works well. Don't get why others are knocking it for not being able to use with Google Sheets - from what I can tell it's designed to work with Smartsheet data, and says so.
Submit reply
March 22, 2015
Can't use with Google sheets and has a free trial of only 30 days.
Submit reply
March 5, 2015
Requires a paid subscription to use You can't use data from a Google spreadsheet.
Submit reply
February 17, 2015
Brilliant use of Smartsheet to create individual documents from Rows.
Submit reply
January 28, 2015
This saved me a lot of time. I was able to quickly create many documents from a Template with just a few clicks. I am impressed that it will automatically name my files if I put a merge field in the title.
Submit reply
December 31, 2014
Great add on! Still needs a little work and some more features, but gives a nice way to create files/reports with the smartsheet data.
Submit reply
October 12, 2014
I like the way in interacts with SmartSheet
Submit reply
1-10 of 10
Additional information
April 20, 2017
Clear search
Close search
Google apps
Main menu