Template

Template is a Google Document. Add-on creates for each row in a sheet a copy of the template you selected and fills in data from the sheet. Add-on searches for special combination of characters in the template so-called tags or placeholders and replaces them with values form the sheet. Each tag must be enclosed in double curly brackets in order to be recognized by the add-on. Like {{Name}}.

Tags

A tag will be recognized only if you enclose it in double curly brackets like {{this is a tag}} otherwise will be ignored and treated as normal text. You can use white spaces as well as accented characters.

Sample Template

Take a look at the sample template which is used in the tutorial when you first time open the add-on. Notice there are three tags defined in the header {{day}}, {{month}} and {{year}}. Then the document itself contains multiple times the tags {{name}} and {{surname}}. Notice the rich formatting like color and font size. For tags which are mapped as text rich formatting will be preserved in the output document.

Along the text tags there are tags {{qr}} and {{image}} which are mapped as QR code and image. Finally the footer contains again same tags as are in the header but the date pattern is different.

Prohibited Characters

If a tag contains one of these characters the tag will be ignored:
()]+*?|.$^\

Examples

Valid tags which will be recognized by the add-on:
  • {{First Name}}, {{First_Name}}
  • {{day}}, {{día}}, {{день}}, {{วัน}}, {{يوم}}
Invalid tags which will be ignored:
  • only single bracket or no brackets - {Name, {Name}, {{Name}, {Name}}, Name}, Name}}
  • use of prohibited character in tag - {{First^Name}}, {{Name(1)}}