Google Sheets importXml Coding

There are a few site where I need to scrape information off of for my mlb prospects database. I use a google sheet and have been using importxml where I compile rankings for each team that includes their ranking, name, position, age, and team (if all variables are available for each site). The goal is to develop the code necessary in conjunction with google sheets where the lists would be live (MLB Pipeline is updated regularly) Fantrax [login to view URL] Prospect361 [login to view URL] ProspectsLive [login to view URL] Baseball Prospectus [login to view URL] Baseball America [login to view URL] The most important site being: MLB Pipeline [login to view URL] Read Less