Integrate with Google Spreadsheet? What I would like to have happen is whenever a person completes a registration through aMember the information they entered is automatically placed in an existing Google Spreadsheet. Currently, I am exporting the information and then copying and pasting it into a spreadsheet - and I would love to be able to cut out this step. I use FormSite (not for anything related to aMember or eFront) and they implemented this feature so that whenever anyone completes one of my forms hosted on FormSite the information they entered is automatically put into one of my Google Spreadsheets. It works great and it would be such a big help if I could do the same thing with aMember and eFront. Here's a link that better explains how FormSite is integrated with Google Spreadsheets: http://www.formsite.com/documentation/integrations/google-spreadsheets.html Has anyone already done this? Or would anyone be interested in helping me accomplish this goal? Thanks!
If all you want to do is add a row to a spreadsheet everytime registration is completed, the Google API makes it pretty easy to do: http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#CreatingListRows You do not need to update the spreadsheet, etc should their information change in aMember? What fields specifically would you want to populate?
Hey Frank! Thanks for the reply. I just want the row added and would not need it to change because I just use this spreadsheet as a "gradebook" to record the test scores from eFront for each person and to keep track of whether or not the certificate has been created and mailed. Would the code you linked to just need to be added somewhere into the aMember script itself? The extent of my experience with the Google API is just setting up the key required by FormSite so that the Google Spreadsheet could be integrated there. (so basically zero!) The fields I would need are: Username Password Email Name (first and last) First Name Last Name Company* Property_Name* Street Address* City, ST Zip* ALL of the default fields under Subscription Fields ALL of the products under the Product List (The ones in the list above with * are custom fields that I added under the Member Fields) This would help me so much and save me so much time. I appreciate your help and look forward to hearing from you again!
I'll try to put something together over the next week or so if schedule allows. The only thing that jumps out as requiring a bit of thought is managing the Authentication side of things. Google allows for the use of a token, but requires that you submit google credentials in order to obtain it.. need to figure out an elegant way of doing that in the backend without storing any confidential data in the db.
@csf97: Following up on this as my schedule is still fairly booked for the next few weeks so I'm not sure I'm going to be able to get this. If you need it right away, I'd suggest reaching out to Ken Gary to see if he can assist you: http://kengary.com/
Thanks, Frank! I'm not in a huge hurry so when you get caught up if you're still interested in tackling it let me know. In the meantime I will check out Ken Gary's site and see if he can help.