Since some people asked for it, i decided to share it
You can contact me on telegram for any question other than those already answered in the FAQ
Shoutout to the cathook team :^)
- A Google account
- A Steam API key
- First of all, visit this link
- Login to your Google account if you haven't already
- Navigate to
File → Make a copy
- Your new spreadsheet should open automatically, it may also be accessed from your Google Sheets projects
- On your spreadsheet, navigate to
Tools → Script Editor
- You should already have 2 scripts called
ImportJSON.gs
andAccountTracker.gs
, if not then please read the FAQ - Visit this link, hover the correct spreadsheet and open up the triple dot menu
- Navigate to
Triggers → Add a trigger (bottom right)
- Select the function called
triggerAutoRefresh
, set the event source toTime driven
and set it toEvery 30 minutes
- Create a trigger that calls
errorHandler
every 5 minutes - Create a trigger that calls
todaysDate
every minutes (i explained why i do it that way in the FAQ) - Go back to your spreadsheet, and copy/paste your Steam API key to the
E3
cell - Right click on the
refresh bans
button (top right), open up the triple dot menu, clickAssign a script
and writetriggerAutoRefresh
before pressingOK
- Assign the script called
deleteAcc
to the button calleddelete an account
.
You should be done ! Keep reading the following parts to acknowledge known issues, basic rules, and useful informations.
Column | Feature | Meaning |
---|---|---|
B | Account IDs | Self explanatory |
C | Occupied Dropdown | Used when multiple users share the same spreadsheet, indicates which accounts are occupied (you can add users like this : Select C6:C30 and navigate to Data → Data Validation ) |
D | Friend Code | CS:GO Friend Code |
E | Login name | The account's Steam login name |
F | Password | The account's Steam password |
G | Wins | CS:GO Matchmaking wins |
H | Steam URL | Steam URL (supports both custom and id64 urls) |
I | Cooldown Type Dropdown | Select the length of the cooldown you wish to apply, default is 21 hours (usual matchmaking cooldown) |
J | Cooldown start | Here goes the date of when the cooldown started, please use this format : D/M H:m Example : 23/07 02:53 (you can copy/paste the date from the Current time cell) |
K (Hidden) | Cooldown Factor | Can be ignored, used to calculate the remaining times of the applied cooldowns |
L | CS:GO Status - ETA | Shows if the account can be played on, also tells you if you forgot to provide some required info |
- When moving accounts in the array, please be careful not to copy/paste the
CS:GO Status
row, as mentionned below, this will copy the cell's formula, and break your sheets with it (though i protected the whole row with a warning so it shouldn't happen) - When copy/pasting anything in the array, select what you want to copy, press
CTRL+C
, pressESCAPE
, then finally paste your values by pressingCTRL+V
- When an account gets banned, you may only clean the
Notes
,Friend code
,Login name
,Password
,Wins
,Cooldown start
, and theSteam URL
cells, do NOTRight click → Delete row
- For those who use the
Current time
cell to copy/paste dates, you may paste them by pressingCTRL+SHIFT+V
, so it doesn't copy the format and fuck up the occupied highlighting (try it to understand)
-
If you have hundreds of accounts, you can make the scrolling bar scroll only for array content.
To do so, drag the horizontal grey bar over the rows to the desired spot :
(suggested by @ColinTheShark)
This might be because your entered steam api key is incorrect
If not, this might be caused by the Steam Web API thinking we are spamming calls due to the way our ImportJSON function works (i made an error handler to get rid of those automatically so they shouldn't annoy you that often)
If this isn't the error you're getting, please contact me and i'll be happy to help
Yes, here are the links : ImportJSON.gs and AccountTracker.gs
It makes it easier to copy the current date when adding a cooldown.
Copy-pasting in Google Sheets can sometimes be pretty annoying because it selects the cell's formulas instead of values
If i used the now()
function instead, we would copy =NOW()
everytime which is clearly not optimal
You surely can, just unhide the hidden column, select the very last row, and drag it down till you are satisfied
You may need to reset the alternating colors but i'll let you handle the esthetics
You can do so, but don't forget to update the cells where those values are updated from the script editor
- To do it, navigate to
Tools → Script Editor
and open theAccountTracker.gs
script - Let's say you want the current date to appear in the
F3
cell, you simply need to setCurrentTimeCell
like so :
var CurrentTimeCell = "F3";
I don't recommend it, unless you have a good reason you should simply right click the column and click Hide column
Yes, contact me on telegram by visiting the link at the top