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. 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?

Merge folders in google drive