Workato Data Tables

Alejandro Posted by: Alejandro Hernandez Date Posted: July 22, 2026
Back to Case Studies

Issue

The client has >30k records in their CRM getting automatically updated every day. I don’t want the workflow to import a full backfill every day.

Solution

The Data Tables feature!
It’s similar to Lookup Tables but with higher limits: 50 columns and 1M rows vs 10 columns and 100k rows in Lookup Tables.
It’s also similar to the Event Stream (Pub/Sub) feature in that there are Data Table triggers, so a decoupled recipe can run based on new/updated records saved in the Data Table.
Like Lookup Tables, there is a lookup formula (guide). In the solution, I used this formula in a JS filter to determine if records are new or have a changed revenue value, in which case they get upserted to the Data Table. Then, another recipe with a Data Table trigger outputs the new/updated records and proceeds to the rest of the workflow, which involves fetching contacts and sending the data to RCFX.

Achievement

Used Workato’s Data Tables feature to optimize a deal-importing workflow, saving task usage and backend processing time.

Snippet/Screenshot/Link

Data Table upsert recipe