Let's say we are inserting a new row in DB table. Is it possible to create a

Where are you inserting the record from? Is it from an external system?
There are two options.
(1) The ideal option is for the external system to send a WS call into Appian when a record is persisted. You can have it in the application level or in the DB level as a trigger that invokes a Stored procedure that makes a WS call. Most of today's db allow this to happen.
(2) To build a listener process in Appian that monitors change to DB and triggers the process when one happens.

Where are you inserting the record from? Is it from an external system?
There are two options.
(1) The ideal option is for the external system to send a WS call into Appian when a record is persisted. You can have it in the application level or in the DB level as a trigger that invokes a Stored procedure that makes a WS call. Most of today's db allow this to happen.
(2) To build a listener process in Appian that monitors change to DB and triggers the process when one happens.