I've been able to add rows to different worksheets in a spreadsheet
using the API. Some of my formulas in my spreadsheet refer to other
worksheets by name e.g. using syntax like this (in the formula)
=hour('daily times'!D227)+(minute('daily times'!D227)/60)
When I update this spreadsheet manually, I first add a new row worth
of values manually in one worksheet 'daily times' (this part I can
automate using the API) but then I copy and paste a row from a
different worksheet. Manually it works great. Any suggestions for how
to automate it using the Google Docs Data API for Spreadsheets?
