This project generates annotated google response forms based on the questions and translations available at TranslateForSG. A sample template is available.
The complete step-by-step guide:
- Visit Google APIs & Services. Click "Create Credentials" and select "OAuth client ID". Select Desktop App for Application Type.
- After creating the OAuth client ID, download the json file to the local project and rename it credentials.json
- Run
node main.js
. You will be asked to enable Google Sheet API and Google App Scripts API as well as authorize Quickstart. Follow the instructions on the console. - Visit the link to the project. Run
main
to generate the desired templates.