Autofill Google Docs from Google Forms responses

How it Works

Using a Google Doc as a template, create individual Google Docs for each row of data in Google Forms for invoices, agreements, and reports.

Create a regular Google Doc to use a a template.

Include merge fields in the format {{field name}} where 'field name' is the name of your column in your Google Sheet.

‍

Connect your Google Form Responses to Lido. When a new form response is added, it will automatically be pulled into Lido

Generate a Google Doc by merging spreadsheet data into your Google Doc template and save it to Google Drive

CREATEGOOGLEDOC(<Google drive credential>,<path to template>,<file name>,<output cell>)

‍