Hopefully this isn't an inappropriate place to ask this question..
Our business is a bike shop. When someone buys a bike they fill out a little form on a computer in the shop with their contact info, and the form is served by a Google Docs spreadsheet. So we have a constantly-growing Google spreadsheet with new customer information.
I'd like a good way to get these into Constant Contact on a regular basis without using the regular import features. I'd like them to be added to a specific lists (bike purchasers) and have that trigger an autoresponders sequence for a couple of follow-up emails.
Google Docs has a scripting feature (documented here: http://code.google.com/googleapps/appsscript/ ). It seems like I should be able to use this to work with the CC API and add the contacts on a regular basis.
Can anyone point me in the right direction? I feel like someone must have done almost this exact thing already and I don't want to stumble around and try to re-invent the wheel. I am only somewhat comfortable with the API documentation itself.
