Form Fill


This add-on can create shortened prefilled links to Google Forms in bulk based on data inputted into a Google Sheet. Each row represents a potential response, and the links generated will have the information already filled into the form. The add-on also creates QR codes that are easily printable for distribution.


  1. Pick a Google Form and select which questions in the form you would like to prefill.
  2. Add your prefilled response data to Google Sheets. Form Fill automatically created shortened links for the responses.
  3. Create printable QR codes to share


Links and attribution for code from external sources used in this app:

Additional References

Programmatically prefilling Google Forms

Google Drive File Picker

Making jQuery UI Sortable Accessible