Which tells AutoCrat whether or not to merge a particular row of data. Which will drop a merged document into certain folders and not others. Add a dynamic folder reference (optional) Choose a destination folder for each merged document to be dropped into.Ĩ.
#Google doc merge page pdf
Some hyperlinks may not work correctly if imported directly into a PDF, but you can import them to a Google document and then convert to PDF to solve this issue.ħ. Choose file type as either Google document or PDF. You can use or to give each document a timestamp. Set up the File Settings by naming the file that each merged document will be given. You can also include a “link label” if you want to hide the URL behind a word or sentence.Ħ. Hyperlink: Autocrat can identify text as a URL so that it is live (clickable) in the document. This can also be left blank and the image will by merged at 100% of it’s actual size. You can provide an image size in pixels or percentage. The image must be publicly hosted, not stored on a drive.
Image: AutoCrat can pull an image URL from a sheet and merge it into a document (as an image, not a URL). Standard: normal text field that will be merged into the document exactly as it appears in the spreadsheet If they do not match exactly, you will need to map them manually.ĪutoCrat allows you to indicate the type of data that is being merged: If the tags match the header exactly, they will be mapped for you automatically. The tags are case sensitive so make sure they match.įor this step you will need to map (or match) the tags in your document template to the columns in your document source. When making tags, match them to the column headers in your Google Sheet exactly, and AutoCrat will auto-map them for you. *Tags are a string of text wrapped in double less than (>) symbols. You can format the template any way that you like, putting in anywhere you want to dynamically pull in data from your spreadsheet (e.g. The template can be a Google Document or Google Spreadsheet and this is how Autocrat knows what your final document/documents will look like. We suggest installing the add-on AUTOCRAT. Below are instructions to help you set up a mail merge in Google Documents using Autocrat: 1. We’ve also used Autocrat for a nonprofit’s silent auction donation list to output the bid sheets and descriptions.
#Google doc merge page update
For example, YellowWebMonkey uses Autocrat to update the language in our annual maintenance agreements. Name, Address, etc.) Form letters/emails are the most common use for mail merges, but there are many other applications as well. It will import data from another source and uses the information from that data source to fill in placeholders throughout the message to make it customized to a specific user (e.g. Autocrat makes it easy to merge data from Google Sheets into Google Docs or into a PDF.Ī mail merge is an extremely useful tool for personalizing forms or emails for many individuals at once. YellowWebMonkey has the solution for you: you can set up a mail merge using Google Drive and an add-on called “Autocrat”. Do you need to create a mail merge but don’t want to use Microsoft Excel or Word?