Contact us Blog

Creating Google Doc templates

You can create a Google Doc or Google Sheet as a template and use it with Apsona's Document Generator for generating Word (docx), Excel (xlsx) or PDF documents. See this article for information about the Document Generator.

Using a Google Doc gives you the usual advantages over using Microsoft Word or Excel templates: To use a Google Doc or Google Sheet as your template, you would follow these steps:
  1. Create the Google Doc or Sheet as you normally would, in your Google Drive.
  2. Set the template's sharing so that it is viewable to anyone with a link to the template, as follows.
    1. Click the Share button at the top of the editor.
    2. In the resulting popup, click the Advanced button.
    3. In the next popup, click the Change button.
    4. In the next Link Sharing popup, select the "Anyone with the link" option. Then click Save.
  • You will need to paste the id of the Google Doc into the Apsona Document Generator's merge action. The id can be found in the URL for the Google doc, between the /d/ and the /edit bits - see the screen shot below. Don't include the slashes. For example,
    https://docs.google.com/document/d/106OxqgXdGdVWsjSv5vc3658jhj_QAhXcHii5xZIW1WU/edit

    When creating the merge action, you can copy this id and paste it into the Google Doc ID box, as below. See this article for more info about generating Word and PDF documents.
  • script>