#FREE DOC MERGE FOR GOOGLE DOCS INSTALL#
#FREE DOC MERGE FOR GOOGLE DOCS UPDATE#

By default, the name of each file will include the data from the primary column in your sheet, but you can click Change next to File Name Format to modify this as desired. NOTE: Google will only create PDFs of documents less than 10MB in size.Ĭustomize the File Name Format. When this last option is selected, all of the merged documents will be combined into a single Google Doc/PDF file for easy printing. Select whether you'd like to Create multiple Google Docs, Create multiple PDFs, and/or whether you'd like to Combine into one file. When finished setting up the document, click Run Merge in the Smartsheet Merge sidebar. Repeat this process for each column of data you'd like to merge into the document. This will insert a Merge Field tag that acts as a placeholder for data coming from Smartsheet. Place the cursor where you'd like the first tag to display in the document, then click on a column name in the sidebar. Merge Fields are what Smartsheet Merge uses to place your Smartsheet data within the Google Doc. NOTE: You can select a maximum of 150 rows per merge.Ĭlick Insert Merge Fields from the Smartsheet Merge sidebar.

If you select multiple rows, Smartsheet Merge will create multiple copies of the Google document, each one merged with data from a selected row. Click Select a Sheet to choose which sheet from your Smartsheet account to use for the merge. Use the Search box just above your sheet list to quickly filter sheets to find the sheet you're looking for.Ĭlick Select Rows from the Smartsheet Merge sidebar to choose rows to merge with the document. You'll see that the Smartsheet Merge sidebar has updated.

#FREE DOC MERGE FOR GOOGLE DOCS UPDATE#

Once successfully logged in, the page will update and instruct you to close the window and return to your Google Doc with the Smartsheet Merge sidebar. If this occurs, sign out of all Google accounts in all browser windows, close the browser, and sign back in to just one Google account. NOTE: You may see an error message during this process if you're signed into multiple Google accounts. The Smartsheet Merge sidebar will appear to the right of the document.Ĭlick the Connect to Smartsheet button and then follow the steps to authorize access between the app and your Smartsheet account. You can also choose to navigate to any other document you want to merge Smartsheet data into.Ĭlick Add-ons at the top and select Smartsheet Merge > Start. Once installed, you'll be re-directed to a document in Google Docs.

#FREE DOC MERGE FOR GOOGLE DOCS INSTALL#

To get started, install Smartsheet Merge from the Chrome Web Store and grant Smartsheet Merge permission to access your Google Drive documents. TIP: If your column names or locations have changed since starting up the add-on, click Refresh Columns to update the list in the side bar. You can create a Merge Field tag for any column manually by typing the column name surrounded by two sets of curly bracers - for example, - within the document. Only the first 100 columns in the sheet will be available to select from the sidebar. For example, you can use the names in your 'Client Name' column in Smartsheet to customize a form letter created in Google Docs for each of your clients.

Smartsheet Merge is a Google Docs add-on that enables you to create invoices, form letters, envelopes, or other documents from your Smartsheet data. In addition, there are several integration points with Google that don't require any installation. NOTE: You must use the Chrome browser to install any Smartsheet app or add-on initially but after the install, you’ll be able to access the Google Drive-Smartsheet features in any browser. Smartsheet Sync: Store responses to Google Forms in a new sheet in Smartsheet.Ĭreate new sheets from Google Drive: New sheets will be stored in Smartsheet, but a link will also be created in Drive so you can easily open them from there. Smartsheet Merge: Strategically import Smartsheet data into your Google Document. There are a few Smartsheet-Google Drive integration points available to install from the Chrome Web Store:

Free doc merge for google docs