Creating a Smartsheet pipe is certainly possible. What specifically are you looking to accomplish with this pipe? I’ll be able to tell you if its possible.
Just keep in mind the Piipes work on a 1-to-1 relationship. Meaning, you can’t display a table from Smartsheet inside your app. But assuming you want to update a single record or get a single record you can do so fairly easily.
I have a workmate who has built a large smartsheet to track staff and logistics.
We are looking at using tadabase to build forms that the staff can access from their phones. They will want to be able to add, update and read records from the smartsheet, so one row at a time.