“It is awesome.”
Sara, Executive Director
Project
Greater Harrison Chamber of Commerce
Sara, the Chamber's Executive Director, wanted a central community calendar on the Chamber website and a weekly email that updated from those events without creating more manual work.
I built an automation that creates a branded Mailchimp draft for review, using the Chamber calendar as the source of truth.
Talk Through a Similar ProjectWhat the system does
Central community calendar connected to the Chamber's event source
Weekly Mailchimp draft generated automatically every Tuesday at 7am
Thursday-to-Wednesday event window for weekend planning
Branded email layout with Shop Local Harrison header, green buttons, clickable images, and clickable event titles
Sponsor image pulled into the weekly email
Manual draft generator with last-run and next-run status
Description cleanup that removes repeated non-Chamber disclaimer text
Audience targeting for the Shop Local Promos group while keeping final scheduling in Mailchimp
The result: the Chamber keeps editorial control, while the recurring event email is prepared automatically each week.
Back to Selected Projects