But I would like to automate the process so that I can obtain the spreadsheet using R. I did this previously from Yahoo with the code: read.csv("http://finance.yahoo.com/quotes/DRRX,AAPL,AMZN") However, I can't figure out the comparable code to download from Google. Any help would be appreciated.

R is very useful for downloading data from Yahoo/Google . Here is an example for downloading from Google Finance :

library(quantmod)


Just adjust the from and to dates as needed. This will download the OHLCV data from google finance to your R global environment.