I had been using Google Sheets as a data source in one of my Nextjs projects a wrote down the steps of how to achieve it 

https://andredevries.dev/posts/google-sheets-database-nextjs