The Tables gadget gives missions full access to your data, both as steps and as triggers.

Reading

  • Find Records - search a table for the rows you want
  • Get Record - fetch one by ID

Writing

  • Create Record(s) - add one or many
  • Update Record - change an existing row

Removing

  • Delete Record(s) - remove one or many rows
  • Clear Table - empty it while keeping the fields

Managing

  • Create Table, Delete Table, Download Table

Starting a mission when data changes

Tables can also trigger a mission, which is usually the more interesting half: That means you can react to data instead of polling for it. Something writes a lead into a table, and enrichment starts on its own.
Splitting work across a table like this keeps each mission small. One mission collects, one reacts. Either can fail and be retried without redoing the other.