Turn Google Form submission into documents

Generate a new file when a Google Form is filled, and create outstanding Google Docs or Microsoft files

Create your document template

  • Create a document template in your Drive (Google Sheets, Google Slide, Google Docs), and add {{Merge fields}} to personalize the documents with data from your sheet.

In our example, we will add the tags {{Date}}, {{First Name}} and {{Last Name}} in a Google Docs template:

Template Google Docs

Note: You can skip this step and create directly your template from your sheet with Publigo! See the last section to learn how.

Create a Google Form

  • Create a form and add a question for each merge tags added in your template:

Google form example

Generate document on form submit with Publigo

  • From your form responses tab, open the responses Sheets:

Google Form responses
  • Open Publigo by clicking on the Publigo icon on the side panel of your responses sheet:

Open Publigo from your sheet
  • Select the template you want to use

If you want to use an existing template, click Yes to open the folder picker and select your document template:

Select your template

To create a new template, simply click No, and select the type of document you want to create:

Create a template from the sidebar

For example, if you click on create a Google Sheets, Publigo will create a new spreadsheet named Publigo - My Google Sheets Template and store it in a folder called Publigo - My Standard Template.

  • Click on the more options button and select Schedule merge > On form submit:

Schedule merge
  • You are all set! You can now click on the button Generate on form submit:

Generate on form submit

A document will be automatically generated every time a response is submitted!

Generate a file on form submission