PLK_GoogleSheetsDatabaseWeapon

✅ 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_GoogleSheetsDatabase

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\Weapons This link will help you sort item values.

Column	Description
id	The ID number of the item, weapon, or armor.
animationId	The ID of the animation associated with the item, weapon, or armor.
description	A brief description of the item, weapon, or armor.
etypeId	The ID of the equipment type (e.g., sword, armor, etc.).
iconIndex	The index of the icon representing the item, weapon, or armor.
name	The name of the item, weapon, or armor.
note	Any additional notes or special properties for the item, weapon, or armor.
params	[MHP, MMP , ATK , DEF , MAT , MDF,AGI , LUK ]
price	The price of the item, weapon, or armor in the game.
traits	Special traits or effects that the item, weapon, or armor has.
wtypeId	The weapon type ID, used to specify the type of weapon (e.g., sword, dagger, etc.).

The data you've provided in JSON format represents Traits (special characteristics) assigned to an item, weapon, or armor. Here's a breakdown:

• code: This indicates the type of trait. In this case, 22 refers to a specific trait type.
• dataId: This is the ID of the associated data for the trait. For example, 1 could refer to a particular effect or attribute.
• value1: The first value for the trait, which in this case is 0.05. This could represent a percentage or multiplier depending on the trait type.
• value2: The second value for the trait, which is 0. This is often used for additional parameters or options that might be specific to certain traits.