PLK_TableGoogleSheet

With this plugin, you can help explain your game in a simple and easy-to-understand way with a table format and data headers. When you update the game and want to notify the players, just update the table, no need to edit the game anymore.

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

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

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

Step	Description	Notes
1. Publish Your Google Sheet	Publish your Google Sheet as a Web App or using "Publish to the web" so that it outputs JSON data.	Make sure the sheet is publicly accessible.
2. Configure Plugin Parameters	In the Plugin Manager, set the following parameters: • sheetUrl: Paste your published Google Sheet URL. • columns: Define each column with fields such as key, name, and optional header settings (headerBg, headerIcon, headerColor, headerFontSize). • fallbackColors: Provide a JSON array of 32 colors. • Global Header Color & Font Size: Set default header text color and font size for columns that don’t override these. • Background and WindowSkin: Choose the background image and window skin. • scrollSpeedX/Y: Set the background scroll speeds.	Each column can have its own header settings. If not provided, global values are used.
3. Install and Enable the Plugin	Place the plugin file into your project's js/plugins/ folder and enable it via the Plugin Manager.	Ensure the plugin is activated before testing.
4. Open the Table Scene	Use the Plugin Command ShowTable or call window.showGoogleSheetTable() via a script call in an event to open the table scene.	This command will fetch data from your Google Sheet and display it in a full-screen, scrollable table.
5. Interact with the Table Scene	The scene displays a fixed header at the top with extra 32px for icons. • The header icon (if defined) is drawn in the top 32px, and header text is centered in the area below. • Scroll the table data using the mouse wheel or drag the screen. • The scene exits when you click or press OK/Cancel.	Adjust the vertical offsets in the plugin if you need to fine-tune the icon/text positions.