Real time Integration Google Sheet to Snowflake

Hello everyone,

I've been asking to update a Snowflake table in real time every time there's a modification made on a specific worksheet in a Google workbook.

I'm not sure how to proceed, I believe it's by using a Google Sheet Subscribe snap and Trigger task but it did not work out. The pipeline runs every 2 minutes approximatively but I'm getting an error :

This is how my pipeline looks like : 

I believe I'm not using the Google Sheet Subscribe well (though I have no errors on parameters)