How do you scrape data into Google Sheets?



  • I’m trying to compile large amounts of data across hundreds of games (# of Players, Age Rating, Genre, etc.) and I feel there must be a way to get it into Google Sheets (since a few frontloaders I know scrape from TheGamesDB)

    Any tips would be greatly appreciated!

    I have been able to display:

    Players:
    Co-op:
    Genres:
    Release Date:
    Developer:
    Publisher:

    By using the code: =importxml(A1,"//span[@class=‘grey’]")

    “A1” being a cell with the URL of the game I’m interested in. Still trying to figure out how to get the actual values for those categories to populate.


Log in to reply