Pets to Collect with Friends updated! A Google Sheets tracker for completing your pet collection

TL;DR: Our pet tracking spreadsheet has been updated to v2.2 to fix errors in the Blizzard and Google APIs and add some new pets, and to correct issues with non-US characters!

Ever wanted to see what pets you and your friends have spare, so you can trade? Well, have I got something for you!

Kaerei and I have been working on a solution that let us figure out what pets each of us owned, what we had spare, and what we could trade with each other and our friends. We’re both huge collectors and completionists, and we enjoy helping others to get closer to that elusive next achievement or goal. The first tracker we developed required a rather tedious process of checking each toon on SimpleArmory, then manually ticking off each pet we owned. Obviously, this didn’t work well for more than a couple of toons. So, we put our heads together and created an API-powered version that pulls all the owned pets directly from the Blizzard servers. No more manual entry and tracking!

This sheet lets you just plug in toon names, and it auto populates all the details - what pets each person needs, which toon has spares to trade, and so on.

You can find the template here:

http://tiny.cc/PetsToCollect

(Copy/paste that into a new browser window.)

Follow the instructions in the Getting Started section to make a copy for yourself, then update that copy with your toon names! If you have any questions, you can post here or in the Discord linked in the spreadsheet, and we’d be happy to help. We are actively looking for feedback on how we can improve and make this sheet better for you! :slight_smile:

Updates to version 2.2:

  • Fix for non-US characters
  • Fix for the “limits exceeded” error some users were getting.
  • Minor assorted visual fixes

Updates to version 2.1:

  • API Fix
  • Automatic update of pet counts every five minutes
  • Visual Updates
  • Added 10 pets from 8.3
6 Likes

Wow! This spreadsheet is amazing. Thank you so much for sharing!

1 Like