Google Sheets are a great way to gather data online in a collaborative environment.
Once you have your data in a Google Sheet, you will simply need to make the data public by publishing it to the web: https://support.google.com/docs/answer/183965?hl=en&co=GENIE.Platform%3DDesktop
Once you have this data published, you will need the CVS link and then add “&ext=.csv” to the end.
You can then use this updated link in the File Import Connector.