Could do that now by turning a sheet into an API and then using fetch column. This helped me to achieve that: