Generate personalized documents from Google Sheets
Easily create personalized documents in Publigo with just a few clicks! Publigo doesn't require any coding skills and all you need are Google Sheets & a template.
In this article
Configure your spreadsheet
In Google Sheets, enter all your relevant header-labels
The first row is set aside for headers (your own and Publigo's reserved keywords like Merge Status and Merge Date). In our example, we will generate documents with First Names and Last Names.
- Add all the relevant information
Info: If you plan to create your template directly in Section Generate your documents with Publigo.
Create your document template
- Create a template in your Drive using Google Sheets, Slides, or Docs)
- Include {{Merge fields}} to personalize your documents. We added {{First Name}} and {{Last Name}} in our example (see our headers with the same header-labels in Step 2).
Note: Remember the title of your document (Publigo Certificate of Appreciation) - we will reference this later in the next section.
Generate your documents with Publigo
Configure Publigo
Go back to the Google Sheets you created in Step 1, then open Publigo from the side panel.
Select your template
If you want to use an existing template, as in this example, click Open under your document type. A file picker window will open > select your template.
Info: To create a new template, simply click New under the type of document you want to create.
You are now all set.
Click the GENERATE FILES button.
Info: The generated documents will be stored in the same folder as the template.
