Narrative Spreadsheet Importer

Unity Editor tool to sync Google Sheets directly into ScriptableObjects. No coding required. Your spreadsheet data maps straight to your assets via project settings.

Features

• Zero-code configuration via Project Settings
• Type-agnostic mapping using Reflection
• Enum and automatic asset linking support
• Creates and updates local .asset files automatically

Install

1. Open Unity and go to Window > Package Manager.
2. Click the + button in the top left.
3. Select "Add package from git URL..."
4. Paste https://github.com/bitemdev/com.bitemdev.narrative-importer.git.
   • Pro tip: Lock to a specific version by adding the tag to the end of the URL, e.g., https://github.com/bitemdev/com.bitemdev.narrative-importer.git#1.0.0

Usage

1. Make your Google Sheet accessible to "Anyone with the link can view".
2. Ensure the first column is your unique ID/Name, and the top row matches your ScriptableObject variable names.
3. In Unity, go to Edit > Project Settings > Narrative Importer.
4. Add your IDs, target folder, and class name, then click Sync All Sheets.

Spreadsheet IDs

The tool requires specific IDs from your Google Sheet URL. Do not paste the whole URL into the tool.

If your URL is https://docs.google.com/spreadsheets/d/1z0-exA80FOk8wvVUqx8wnfcJV8PgbX0PnFsrP0I-STg/edit#gid=123456789:

• Spreadsheet ID: 1z0-exA80FOk8wvVUqx8wnfcJV8PgbX0PnFsrP0I-STg (The string between /d/ and /edit)
• GID: 123456789 (The number at the end after gid=)