Unbans users on a specified date and time using a Google Sheet
Fetches every 30 minutes.
Done | Displayname | User ID* | Date* | Time (24h, UTC+2) | Moderator | Reason |
---|---|---|---|---|---|---|
☑ | Reina | 00000 | 2021-07-13 | 12:00 | Reina | Was too cool for school |
☐ | Something | 00000 | 2021-07-14 | 22:00 | Reina | Maybe also too cool for school |
*Required fields
Fill in at least the 'User ID' and 'date' fields. If either are missing, it will not parse it that round.
Once every 30 min, it will fetch rows from a Google Sheet until it reaches a row without a date. Then it will stop fetching more.
Make sure you're inputting the ID. The username/slug will not work. Get the ID from the profile picture's link.
https://media.kitsu.io/users/avatars/
171606
/large.jpeg?1622853524
Date formating is YYYY-MM-DD
, time formating is 24h, like 23:30
After 12am UTC+2 (or the timezone of the hoster's machine), it will unban the current day's bans if there are no time overrides
If the Done
checkmark is checked, it will not do anything to that specific entry anymore (unless you change the checkmark), whether it's before or after other incompleted entries.