A Google App Script to manage Animal Crossing New Horizon's Stalk Market predictions.
-
Open Google Sheets with one of the links below and create a copy.
- Full Animal Crossing Google Sheet including: Turnip Tracker, Recipe Tracker, Item Registry, Flower Registry, and Island List.
- Animal Crossing Google Sheet with only the Turnip Tracker.
-
There are two types of sheets:
- The first Turnips can be duplicated as many times as needed to track as many islands as needed; in this fashion you can invite all your friends as editors and have them add in their data on their own sheet.
- The second Turnips (from External Sheet) can also be duplicated; data for this can be auto-filled from external Google Sheets using
importrange
.
-
To create a new sheet, you need to duplicate the existing sheet type you want, and rename it
Turnips {your name here}
. All sheets that don't start with the wordTurnips
(case sensitive) are ignored by this script.- You can change this behaviour in the
Constants.gs
script file of your spreadsheet copy. - See Editing the Script for how to edit that
- You can change this behaviour in the
- Open
Tools
/Script Editor
- Select
Run
/Run Function
/priceTest
- An in-window popup will ask you for permissions. Select
Review Permissions
- Another popup will ask which Google Account you want to link this script to.
Continue
. - A very menacing page will explain that this script isn't verified through Google. To continue, click the tiny text
Advanced
near the bottom, then clickGo to Stalks (unsafe)
- Finally, select
Allow
- If you edit the sheets or want to change the layout, much of the defaults can be found in
Constants.gs