Create CommCare lookup data from new subscriber cohorts
Keep a program reference table ready when a new subscriber cohort introduces approved categories or codes.
Trigger
Subscribe Trigger
Triggered when a subscriber subscribes to Mailchimp
Action
Create Lookup Table
Tool to create a new lookup table in a CommCare domain. Use when you need to set up reference data structures like product catalogs, price lists, or configuration tables. Requires 'Edit Apps' permission.
Why this helps
Reference data often arrives in marketing workflows but gets added to CommCare later by hand.
- Reduce setup lag for new cohorts
- Create structured reference data
- Make approved categories available to CommCare users
Setup
Build it in a few focused steps.
- 1Connect Mailchimp and CommCare in Notis once.
- 2Create an automation describing the lookup table to create from the subscriber event context.
- 3Tell Notis to create only the approved reference structure and report any missing values.
- 4Pick the Mailchimp Subscribe Trigger.
- 5Choose a report channel and test with one controlled subscriber event.
Questions about this workflow
Will this create a table for every subscriber?
The automation follows your instruction, so use it for events that represent an approved cohort or reference-data change.
What permission is required?
CommCare requires Edit Apps permission for this action.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Mailchimp to CommCare. A trigger fires from one place; an action lands in another.
Mailchimp triggers
CommCare actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create Lookup Table
Tool to create a new lookup table in a CommCare domain. Use when you need to set up reference data structures like product catalogs, price lists, or configuration tables. Requires 'Edit Apps' permission.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create Web User Invitation
Tool to create an invitation for a new web user in CommCare. Use when you need to invite a user with specific role and permissions. Requires 'Edit Web Users & Edit Access API' permissions.
Campaign Trigger
Triggered when a campaign is sent or experiences an event in Mailchimp
List Reports
Tool to retrieve available reports configured in a CommCare project. Use when you need to discover what reports exist before downloading report data via the Download Report Data API.
Profile Update Trigger
Triggered when a subscriber's profile is updated in Mailchimp
Single Sign On
Tool to validate login credentials and retrieve user profile for a mobile worker or web user. Use when you need to authenticate a user and obtain their profile information including roles, permissions, locations, and configuration details.
Subscribe Trigger
Triggered when a subscriber subscribes to Mailchimp
Submit Form to CommCare
Tool to submit an XForm to CommCare following the OpenRosa standard. Use when you need to submit form data with complete XML including required metadata fields (deviceID, timeStart, timeEnd, username, userID, instanceID).
Unsubscribe Trigger
Triggered when a subscriber unsubscribes from Mailchimp
Submit Form ODK Compatible
Tool to submit form data using ODK-compatible endpoint for Android client compatibility. Use when submitting XForm data to CommCare. Requires properly formatted XML with metadata including unique instanceID.
Connect any two apps with Notis in the middle.
Mailchimp and CommCare, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business CommCare.