There’s a free app called Monday CSV Link that would connect your google sheets with a monday board.
You can install it here
Then go to the portal and generate a link: Monday CSV Converter
Here’s an explanation on how to set an automatic refresh so it’ll keep fetching the data.