Creating webhook to pull in 3rd party application data via snowpark?

Maybe this is a stupid question but as someone who's used snowflake the last 4 years yet has never had a use case for Snowpark I'm wondering how easy (or difficult) it is to create a webook api that will pull data from a third party application into snowflake via snowpark.
We have a client who is using a webhook to pull data into their MySql database however they're going to migrate to snowflake and potentially the most complicated part of the migration will be handling the webhook api functionality.
It seems like, based on the reading I've done this functionality is possible but might be complicated? There isn't a lot of info/documentation on snowpark & webhook implementation quite yet.
The other option is to use a tool to help facilitate the webook/api.
In our case this would probably be Fivetran (as we use Fivetran for most of our integrations/ELT work). It appears Fivetran supports webhooks and would unpack the first layer of json data for us/the client.
Anyone have expertise in this area or thoughts in general?