Hi Max, The first part, getting the user data, is straightforward. The spreadsheet api is designed to allow you to retrieve data several different ways, but your program could just periodically read the 2nd row (the 1st row is column names), if it's not empty extract the data and delete the row, then repeat until you get an empty row. Data is always returned in a feed (a string of text made of up of XML tags like '<cell>') which you extract your data from.
The second part, sending the data to the user acct website, is not part of the Google api. You would have to write that part to read the user acct page(s) and return the user data. For the first part there is a good example that comes with the client library (you can get it in Java, Python, PHP, and .NET). The python example is explained here: http://code.google.com/apis/spreadsheets/docs/1.0/developers_guide_python.html You can read the ss key at the end of the URL when you're on the spreadsheet page. You'll need to get the worksheet id (something like 'od6') with the spreadsheet feed before you can read a row from the worksheet. I hope that helps. Regards, Bill Hayes On Sep 23, 12:07 pm, Max Lightner <newventures....@gmail.com> wrote: > Hi, > > We are using a Google form on a website with the form data going into > a Google docs spreadsheet. We have another web based application that > will use the form data to generate user accounts. We want to automate > the process of transferring the data from Google spreadsheet into our > system without having to download and import a csv file. > > Can you suggest a way to do this, I know there is a spreadsheet api, > can that be used and if so (in general terms) how? Our system can use > a form post to a url. > > Thanks. > > Max --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Docs Data APIs" group. To post to this group, send email to Google-Docs-Data-APIs@googlegroups.com To unsubscribe from this group, send email to google-docs-data-apis+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Google-Docs-Data-APIs?hl=en -~----------~----~----~----~------~----~------~--~---
