Help & Support
Send Feedback
Smartsheet for Google Docs
Easily create custom invoices, letters or other documents from Smartsheet data using a Google Doc as a template
Smartsheet, Inc.
957,193 users
Works with
Install
Overview
Creating invoices, form letters, envelopes, or other documents from your Smartsheet data is now a breeze with Smartsheet for Google Docs.  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 for Google Docs 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 (NYSE:SMAR) is a leading cloud-based platform for work execution, enabling teams and organizations to plan, capture, manage, automate, and report on work at scale, resulting in more efficient processes and better business outcomes. Smartsheet empowers better collaboration, accountability, innovation, and real-time visibility into what matters most, to make better decisions faster.

Start a FREE 30-day Smartsheet trial today. Paid plans start as low as $14/month.
Reviews
Pam Leland
May 25, 2018
Smartsheet Merge worked for us before, but now it's not loading - it says it hasn't been verified for Google login (but it was!!!!!!!). What's up with this????
Submit reply
Cancel
Scott McAllister
June 6, 2018
Google changed their requirements for accessing their services inside our Add-on. So, we needed to apply for verification. We have now done this. Please give Smartsheet Merge another try and let us know if you have any troubles.
A User of Smartsheet for Google Docs
November 14, 2016
great great
Submit reply
Cancel
Richard MacLeish
December 5, 2015
I didnt realize that this only works with THEIR spreadsheets... not existing google sheet documents...
Submit reply
Cancel
A User of Smartsheet for Google Docs
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
Cancel
Pawel Michalski
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.
A User of Smartsheet for Google Docs
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
Cancel
A User of Smartsheet for Google Docs
March 22, 2015
Can't use with Google sheets and has a free trial of only 30 days.
Submit reply
Cancel
A User of Smartsheet for Google Docs
March 5, 2015
Requires a paid subscription to use You can't use data from a Google spreadsheet.
Submit reply
Cancel
Richard Rymill
February 17, 2015
Brilliant use of Smartsheet to create individual documents from Rows.
Submit reply
Cancel
A User of Smartsheet for Google Docs
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
Cancel
A User of Smartsheet for Google Docs
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
Cancel
1-10 of 11
Additional information
Search
Clear search
Close search
Google apps
Main menu