I have recently had to create a Google Drive Spreadsheet to report on Google Adwords data, to do this you actually report on Google Analytics Adwords Data as for reasons I won’t get into data between Analytics and Adwords does vary.
As it is all Google products it means that Google Spreadsheets and Google Analytics will work together. The result is that you can do some calculations to report if Adwords is actually bringing in the money that you think it might be. I have set my dashboard up with both ROI and CPA depending on which you prefer to report on as I know there are arguments for both.
I will supply the script on request, however the basics are you use the Script Editor and then set up triggers to automate the process. Once you have a spreadsheet with raw data you can then use formulas to manipulate the data.