Google Sheets [Definitive Infinity Media]

A package for Unity that syncs data between a local CSV and a Google Sheet
Explore the docs »

View Demo · Report Bug · Request Feature

Table of Contents

1. About The Project
2. Getting Started
   • Prerequisites
   • Installation
3. Usage
4. Dependencies
5. Contributing
6. Contact
7. Acknowledgments

About The Project

A package for Unity that syncs data between a local CSV and a Google Sheet. Use it to keep editor-side data (such as localisation, game data, and balance tables) in sync with a shared spreadsheet.

• Upload/Download — push local CSV changes to a sheet or pull updates from a sheet
• CSV → ScriptableObject — generate ScriptableObject assets from spreadsheet rows
• Multiple Sheet support — target individual sheets within a workbook

(back to top)

Getting Started

Follow one of the installation methods below to add this package to your Unity project.

Prerequisites

Unity 2021.1 or later is required to use this package.

Before syncing, you will need:

1. A Google Cloud project with the Google Drive API and Google Sheets API enabled.
2. A service account with a JSON key.
3. The Google Sheet shared with the service account's email address (Editor role).
4. The spreadsheet ID and individual sheet IDs from the Google Sheets URL:

   https://docs.google.com/spreadsheets/d/[SPREADSHEET_ID]/edit?gid=[SHEET_ID]#gid=[SHEET_ID]
   

Installation

Method 1: Package Manager (Git URL)

1. Open the Package Manager window in Unity (Window > Package Manager).

2. Click the [+] button in the top-left corner and select Add package from git URL.

3. Enter the following URL and click Add:

   https://github.com/Definitive-Infinity-Media/com.definitiveinfinitymedia.googlesheets.git
   

Method 2: Scoped Registry

1. Open Edit > Project Settings > Package Manager.

2. Add a scoped registry with the following details:

   • Name: Definitive Infinity Media
   • URL: https://npm.pkg.github.com/@Definitive-Infinity-Media
   • Scope(s): com.definitiveinfinitymedia

3. Create a .upmconfig.toml file in your user root directory:

   • Windows: %USERPROFILE%\.upmconfig.toml
   • macOS/Linux: ~/.upmconfig.toml

4. Add your GitHub personal access token:

   [npmAuth."https://npm.pkg.github.com/@Definitive-Infinity-Media"]
   token = "YOUR_GITHUB_PAT"
   email = "your-email@example.com"
   alwaysAuth = true
   

5. Add the package to your Packages/manifest.json:

   "com.definitiveinfinitymedia.googlesheets": "1.3.3"
   

Learn more: Creating private packages for your Unity project.

Method 3: Direct Clone (for development)

Clone this repository directly into your project's Packages folder:

git clone https://github.com/Definitive-Infinity-Media/com.definitiveinfinitymedia.googlesheets.git

(back to top)

Usage

1. Configure the Google Cloud project, service account, and sheet IDs in the package preferences.
2. Use the editor window or API to upload/download CSV data between Unity and Google Sheets.
3. Generate ScriptableObjects from downloaded CSV data when needed.

For API documentation and examples, please refer to the Documentation.

(back to top)

Dependencies

This package has no external dependencies.

Package	Version
None	-

(back to top)

Contributing

Contributions are what make the open source community such an amazing place to learn, inspire, and create. Any contributions you make are greatly appreciated.

If you have a suggestion that would make this package better, please fork the repo and create a pull request. You can also simply open an issue with the tag "enhancement".

1. Fork the Project
2. Create your Feature Branch (git checkout -b feature/AmazingFeature)
3. Commit your Changes (git commit -m 'Add some AmazingFeature')
4. Push to the Branch (git push origin feature/AmazingFeature)
5. Open a Pull Request

(back to top)

Contact

Definitive Infinity Media - contact@definitiveinfinitymedia.com

Project Link: https://github.com/Definitive-Infinity-Media/com.definitiveinfinitymedia.googlesheets

(back to top)

Acknowledgments

• Package CI Setup

(back to top)