Duplicate Google Spreadsheet on Demand

Question

I've created a pretty complex Google spreadsheet. I would like a user to be able to click a button or follow a link, and get a copy of this spreadsheet where they can fill in data. I would later check process this data manually.

Is there anyway I can do this via a complicated link, or some Javascript, or possibly even using a server side language (e.g. Python, Java).

Thank you,

Answer 1

Copying the document from the client side:

http://code.google.com/apis/documents/docs/3.0/developers_guide_protocol.html#CopyingDocs

Using the Java API, it would seem you'd have to export the document and then upload it:

http://code.google.com/apis/documents/docs/3.0/developers_guide_java.html

Answer 2

You have a few options:

• Rather than force a user to create a spreadsheet that you verify, you can email them a form to fill out with Google forms, and the answers get aggregated back on your spreadsheet.
• Use the docs API to copy documents.
• Use Google Apps Script to automate the process (it's essentially javascript).