PLK_GoogleSheetsDatabaseArmors

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

The available commands will be changed to
$gameParty.gainItem($dataArmors[1], 2);

Column Name	Description	Example Value
id	Unique identifier for each record.	1, 2, 3, …
animationId	Animation ID that cycles from 1 to 5 within each group.	1, 2, 3, 4, 5
description	A brief text describing the armor.	"Description for Armor 1"
etypeId	Equipment type ID, fixed as 2 for armors in RPG Maker.	2
iconIndex	Icon index number, which varies by category:	16 for Armor, 17 for Head, 18 for Helmet, 19 for Shield, 20 for Ring
name	The name of the armor item.	"Armor 1", "Head 1", "Helmet 1", etc.
note	Additional note information; typically indicates the base type.	"Basic Armor", "Basic Head", etc.
params	A JSON array representing parameter values (e.g., stats).	[0, 0, 0, 0, 0, 0, 0, 0]
price	The price of the item, increasing by 10 for each subsequent entry.	100, 110, 120, …
traits	A JSON array that stores any special traits or properties.	[]
atypeId	Armor type ID indicating the category: 1 = Armor, 2 = Head, 3 = Helmet, 4 = Shield, 5 = Ring.	1, 2, 3, 4, or 5