David, there is actually a way to do this fairly easily if you are using a Google Spreadsheet Survey/Form, though it may require repetitively importing your survey spread sheet.

The first step in MailChimp is to add a merge var to your list that is a “date” type. When your list has one of these, you can use it with an autoresponder – instead of “after signup”, you’ll pick “after date” and then select your date field from your list. Note: save yourself some headaches and *don’t* name your field “date” – maybe “survey time”.

Have you noticed that the survey/form-enabled spreadsheet automatically adds the “Timestamp” to the first column? When you import that spreadsheet, we will also pull in the Timestamp column. Now just map that to your new date fields (and the any other necessary fields), and you’ll be good to go.

One caveat – if you plan on setting up auto-responders that go out quickly, I’d suggest using no less than “2 days after” your date field just to make sure you don’t miss anyone.

@Craig
Not sure if you question was answered, but for those who read this, have you tried using “Smart/Conditional Merge Tags”? Then you only need One email template. Just place the merge tag in the email footer which would display a different store address based on each contact group. I use it to show a different graphic and message for each group in my list. You would have One list, separated into Groups (store address) and use One email Template.

One way (good for a few groups, not sure about 100):
With our sign-up form (http://eepurl.com/b0N6T) I created an “Email Group” that can be selected as they sign-up. Then when I send my email newsletters each group receives a different message based on their group.

Sample I use (my default sign-up group is “Resident” in case they forget to select one):
*|INTERESTED:HOA Email Group:Resident|* *|FNAME|*, did you know volunteers are the heart of a successful community and association. *|END:INTERESTED|*
*|INTERESTED:HOA Email Group:Board Member|* *|FNAME|*, thank you for supporting our HOA as a Board Member. *|END:INTERESTED|*

I have this for set for six (6) different groups and each group displays its own graphic and message for each receiver.

Another way for large lists is to place the address for each store as a field for each contact. Then just place the merge tag for that address in the footer (like you would use the *|FNAME|* tag).

Editing/adding the address for each store (export/edit/import)or using Groups in your list may be easier than having several email templates.

Here are some great articles;

MC Article: Use Smart Merge Tags with Groups
http://kb.mailchimp.com/article/how-do-i-use-smart-merge-tags-with-groups/

MC Article: Conditional or Smart Merge Tags
http://kb.mailchimp.com/article/how-do-conditional-smart-merge-tags-work/

And if you want to brand your emails with each store logo see:
MC Article: Dynamic Images in Your Email Campaigns
http://kb.mailchimp.com/article/dynamic-images-in-your-email-campaigns/

Any response to BlinX’s question? I have the same question, though really needing two-way integration between google docs and mailchimp. Using Google Docs to maintain a member database for our non-profit, which we use to manage numerous activities (phone calls, snail mailings, activity planning, etc) and managing the spreadsheet through MailChimp is awkward. To keep the two databases up to date with one another would involve repeated imports of the origin spreadsheet to catch updates for phone calls and snail mailings, and then re-export of updates from MailChimp to catch email blast updates in our origin database. Seems like an integration between the two sources would be of benefit to many. Are there any solutions that allow this?