Hi there, I am new to programming. I have set up the spreadsheets api and successfully run the sample program. I've been attempting to learn java.
I have a spreadsheet that covers a 6 month period that contains the columns date of appointment. client name. amount paid. I have another spreadsheet that has client name. address. (I could easily add a client number as an identifier to both, if this was easier than using client name as the identifier). I want to create invoices once a month in a google docs where an invoice is created for each client once a month showing their appointments for the month (most clients have more than 1 appointment for the month). I have a google doc set up for each month with a header and footer that contains all the other information for the invoice. Would someone mind helping me with the best away to accomplish what I want to do using the api? At the most basic level, I'm not sure of the best way to get G spreadsheets to talk to G docs?
