You can use the above said process or simply can run gviz query to return the player names based in the team selection
https://docs.google.com/spreadsheets/d/<YOYR_SPREADSHEET_ID/gviz/tq?tqx=out:csv&tq=SELECT B where A = ListPickerVakue
This listpicker value only team name and the col B is the player name. Just try, meanwhile your apreadsheet should have the minimum permission anyone can view
For more details refer @TIMAI2 guide 🟩 Use gviz to get and query google sheet data given in this link