Preview

googleform_1
## # A tibble: 26 × 3
##    response_id                               X59372a4d_answers X604b2597_answers
##    <chr>                                     <chr>             <chr>            
##  1 ACYDBNixG6UZOERJfKOPzW502SMR8-I9SzfCqWdT… When zombies arr… Option A         
##  2 ACYDBNhfppvVcVSiU0Aol3cHBEgYCuwTjx84M_P-… The quick brown … Option C         
##  3 ACYDBNgMkDxQKWJ_O1FNpemPuGJbS9NrjVfXZFM8… Five or six big … Option A         
##  4 ACYDBNg3Wemw7zkw1111xI1JeGeUG6qnXiUPFcyI… Amazingly few di… Option A         
##  5 ACYDBNgpwT3FKcpxzYUKCDlRTavrd9017WK0mAS7… Jack amazed a fe… Option A         
##  6 ACYDBNhuyUgnOmeky7oKUatiUA3dyEpX5Dm9edzB… The quick brown … Option C         
##  7 ACYDBNj-xIO9ekcWyQ0QiFEGC-f5j5SFHoPaxrXM… Brown jars preve… Option B         
##  8 ACYDBNhhhSYcnoXb6I1KZoAqATY8ELFn5QHm-4Vf… A mad boxer shot… Option B         
##  9 ACYDBNjH2x7GsV339CENel0sY6uy86gpJWCApKX0… Crazy Frederick … Option C         
## 10 ACYDBNj0hxiFrZZXUGApRyg10SNRwVK8anNtko_a… The job requires… Option A         
## # ℹ 16 more rows
googleform_2
## # A tibble: 4 × 3
##   response_id                                X103e69c2_answers X7a10555e_answers
##   <chr>                                      <chr>             <chr>            
## 1 ACYDBNgHfXMXKJ7Z8VQe87e-IrBdrBad0mBWjO1UH… Here's a really … Option A         
## 2 ACYDBNgdPc1CkWX1dDycG2cYILE9SLdABPfcRox8W… Here's a really … Option B         
## 3 ACYDBNgHfXMXKJ7Z8VQe87e-IrBdrBad0mBWjO1UH… Here's a really … Option A         
## 4 ACYDBNgdPc1CkWX1dDycG2cYILE9SLdABPfcRox8W… Here's a really … Option B

Setting up Google Forms

Follow the steps from the Google authentication section and make sure that the account you have authenticated has access to the Google Forms you wish to collect.

Go to a form you’d like to collect data from. The URL should look something like this:

https://docs.google.com/forms/u/1/d/<GOOGLE_FORM_ID_HERE>/edit?usp=drive_web

Extract the Google Form ID from the URL and put it in the google_forms section of the _config_automation.yml file. Do this for each form you’d like to collect data from and separate the form IDs with commas. Delete the example IDs we have put there as placeholders.

###### Google Forms ######
refresh-googleforms: yes
google_forms: [
  1pbFfgUPYH2w9zEoCDjCa4HFOxzEhGOseufw28Xxmd-o,
  1JjmsiuVoGSxvl-1M_oWittcftO955tijzeNc-cgJlo8 ]
googleforms_googlesheet:

  • In the _config_automation.yml file, make sure that refresh-googleforms is set to “yes”.

  • In google_forms, specify the Google Form IDs for the forms you’d like to collect data from. Separate form IDs with commas. Delete the example IDs we’ve put there.

  • Optionally, if you are saving data to Google, specify a googlesheet ID in googleforms_googlesheet where you’d like the Google Forms data to be saved. This will only be relevant if you’ve set data_dest to google.

Customizing the Google Forms Data

In order to customize the data you are downloading from your Google Forms you can modify the refresh-scripts/refresh-googleforms.R script in your repository.

You can take a look at the metricminer R package documentation for more details about the functions and what is possible.

If you have a metric need that is not currently fulfilled by metricminer or metricminer-dashboard we encourage you to file a GitHub issue with us and let us know about your new feature idea (or bug report).