PLK_GoogleSheetsDatabaseActors

  * Terms of Use *  No duplication or distribution is permitted. Can be used in commercial games I ask you to specify "Palatkorn" in your game credits only

Version: 1.1

  Fixed compatibility with other google sheet load lists in the delayed item calculation error.

✅ How to Use in Google Sheets

1. Create a new Google Sheet and set up the columns as above.
2. Copy and paste the table data into the sheet.
3. Ensure the effects column contains JSON strings (use JSON.parse()).
4. Integrate the Google Sheets API with RPG Maker MZ using a plugin.
5. Test the item functionality in the game. 🎮

Copy Google Sheet to your own database

Open Extension Select app script Press Depoly button

New Deployment

Select type Select web app

Who has access Select Anyone

Press Depoly button Authorize access Select  You Select  Advanced Go to StorageSyncGoogle (unsafe) Allow

Web app

URL

https://script.google.com/macros/s/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Go to game plugin list

Select 

PLK_GoogleSheetEmailRegister

Put URL here https://script.google.com/macros/s/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Once done, you can edit and change items from the sheet.

Caution It will load items by ID, if no ID is entered it will be blank. You can go to your own item settings to see it from the Games\Project\data\Actors This link will help you sort item values. 

https://data.page/json/csv

Column	Description	Example Value
id	A unique identifier for each actor, used to differentiate each actor.	1, 2, 2003
battlerName	The filename for the battler graphic used in battle scenes.	"Eren", "Liona"
characterIndex	The index within the character sprite sheet, indicating the position of the graphic.	4, 5
characterName	The filename for the character graphic used in menus and other scenes.	"SF_Actor3", "Actor1"
classId	The ID of the class to which the actor belongs.	1, 2, 2008
equips	An array of equipment IDs that the actor starts with. Each position in the array corresponds to a specific equipment slot (e.g., weapon, armor, etc.).	[1, 0, 0, 2, 0]
faceIndex	The index for the face graphic used in UI windows (e.g., status or menu).	4, 5
faceName	The filename for the face graphic displayed in the UI.	"SF_Actor3", "Actor1"
traits	An array of special traits that affect the actor's stats or abilities (e.g., modifiers or resistances).	[] (or possibly something like [{"code":22,"dataId":0,"value":0.95}])
initialLevel	The starting level of the actor.	1
maxLevel	The maximum level the actor can reach.	99
name	The actor's name that is displayed in-game.	"Eren", "Liona", "Tyrus"
note	Additional notes or comments regarding the actor, which may include tags for customization (e.g., <CustomFace: SF_Actor3_5>).	<CustomFace: SF_Actor3_5>
profile	A profile or description of the actor, which may include formatting codes (e.g., \FS[16]) and details about the actor’s background or skills.	\FS[16]Expert marksman, age 35. Possesses a strong physique and high precision shooting skills.