Create a CommCare lookup table from a new task list
Start a new operational list in Google Tasks and prepare its CommCare reference structure automatically.
Trigger
New Task List Created
Triggers when a new Google Tasks task list is created. This trigger monitors Google Tasks and fires when new task lists are detected.
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
New programs often begin in task lists but lack the reference data needed by CommCare forms.
- Standardize new program setup
- Reduce configuration delays
- Create reference structures from plain language context
Setup
Build it in a few focused steps.
- 1Connect Google Tasks and CommCare in Notis once.
- 2Create an automation describing the lookup table to create from each new list.
- 3Choose New Task List Created as the trigger.
- 4Choose a report channel and test by creating one representative list.
Questions about this workflow
What information is needed to create the table?
Include the domain, table purpose, columns, and reference values in the task list context or your instruction.
Does this populate all rows automatically?
The action creates the lookup table structure; provide any row data explicitly if your workflow requires it.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Tasks to CommCare. A trigger fires from one place; an action lands in another.
Google Tasks 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.
New Task Created
Triggers when a new task is created in a Google Tasks list. Uses timestamp filtering (updatedMin) to efficiently detect new tasks.
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.
New Task List Created
Triggers when a new Google Tasks task list is created. This trigger monitors Google Tasks and fires when new task lists are detected.
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.
Task Details Changed
Triggers when a specific task's details change. This trigger monitors a single Google Task and fires when any of its details (title, notes, status, due date, completion, position) are modified.
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).
Task List Changed
Triggers when a task list changes (title or content updates). This trigger monitors a specific Google Tasks list and fires when changes are detected.
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.
Task Updated
Triggers when an existing task is updated in a Google Tasks list. This trigger monitors a specific task list and fires when tasks are modified.
Connect any two apps with Notis in the middle.
Google Tasks 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.