One Pace Spreadsheet Better -

The public sheet is sometimes slow to update. Create your private augmented sheet:

  • Use IMPORTXML to scrape Nyaa seed counts for each torrent link.
  • Use IFERROR(VLOOKUP(...)) to merge with a local “watched” status from Trakt.

    • Example formula to pull seeders from Nyaa: One Pace Spreadsheet BETTER

    =IMPORTXML("https://nyaa.si/view/" & TorrentID, "//div[@class='torrent-info']//span[@class='badge-success']")

    Now Sonarr will auto-download new arcs as they appear. The public sheet is sometimes slow to update

    Fans and researchers use these spreadsheets for various purposes: Use IMPORTXML to scrape Nyaa seed counts for

    These spreadsheets are often created by dedicated fans and shared within the "One Piece" community through platforms like Google Sheets, GitHub, or fan forums. They can be a collaborative effort, with many fans contributing information and insights.