ref: fc4f0611ef5597a812639e66aa834be8dd7ca86e gsheets-to-gforms/README.md -rw-r--r-- 1.5 KiB
fc4f0611 — Dimakakos Dimos Docs: one README is enough, some fixes 2 years ago

#gsheets to gforms

This script is working through google's platform, allowing to transfer data from a form to another by exporting them first to a google sheet.

For now it handles the SECTION_HEADERS, TEXT, PARAGRAPH_TEXT, GRID, MULTIPLE_CHOICE and CHECKBOX items of google forms. Also it makes assumptions about the structure of the data in the spreadsheet based on how they are exported from a google form.


It's pretty simple, given that items you need are implemented.


  1. Go to script.google.com
  2. Start a new script and paste in the editor the contents of append-responses.gs
  3. Change the urls for the sheet and form you are targeting
  4. Click run and validate the necessary permissions
  5. PROFIT???

If you need form items that are not implemented, you will get an exception. Please contact me, and depending on my schedule I might be of assistance.


Developing and sharing this script is not intended as an endorsement of google or its products. If anything, please take some time to think about the implications of the loss of privacy and computing freedom that comes together with using such products.

If you are looking for a Forms web app that is more respectful to your privacy and freedom take a look at https://framaforms.org/.

As always this software is provided as is, without any warranty or liability from my side.