Skip to content Skip to sidebar Skip to footer

Duplicate Google Spreadsheet On Demand

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

Solution 1:

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).

Solution 2:

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

Post a Comment for "Duplicate Google Spreadsheet On Demand"