Online Questionnaire & Report Generation with Google Drive & R

September 17, 2012

(This article was first published on theBioBucket*, and kindly contributed to R-bloggers)

Here’s how I did it in 3 easy steps:

(1) Set up a form in Google Docs/Drive.

(2) Choose “Actions” and “Embed in Website” to get the URL for the iframe and put it in a post, like below. Then, go to the spreadsheet view of the form on Google Docs/Drive and set the share option to “everyone with the link” or “public” and copy the document key from this URL:

(3) Make a report with knitr in R using the responses that were put to a spreadsheet at Google Docs/Drive. Do (knit) something like THIS to produce a markdown-file, i.e. (I pushed the md-file to Github for publishing – see it rendered to HTML HERE)..

      To leave a comment for the author, please follow the link and comment on their blog: theBioBucket*. offers daily e-mail updates about R news and tutorials on topics such as: visualization (ggplot2, Boxplots, maps, animation), programming (RStudio, Sweave, LaTeX, SQL, Eclipse, git, hadoop, Web Scraping) statistics (regression, PCA, time series, trading) and more...

      If you got this far, why not subscribe for updates from the site? Choose your flavor: e-mail, twitter, RSS, or facebook...

      Comments are closed.