Yet Another Google Sheets Package for Unity
A package for Unity that syncs data between a local csv and the Google Sheet
Explore the docs »
Report Bug
·
Request Feature
Table of Contents
About The Project
This package was inspired by a video from Dan Pos, where he implemented a similar system using the Python Scripting package. However, this package is being deprecated in Unity 6.1. I wanted to use this similar system, but rewrite it using native C# code in the editor. This package uses the .dll from the Localization package for the Google Sheets API.
Getting Started
This is an example of how you may give instructions on setting up your project locally. To get a local copy up and running follow these simple example steps.
Prerequisites
Create Project: https://console.cloud.google.com/projectcreate Once the project is created, open the project in the dashboard. Then select APIS and Services -> Google Drive API, and enable this permission.
While under the API & Services Page, select on the left Credentials->Manage Service Accounts and create a service account. Keep in mind to make this account the owner.
Once the account is created, in the dropdown select Manage Keys then Add Key. For the key type, select JSON as this will be used in the Editor to verify the account.
Share the spreadsheet to the email address created with the service account, with the editor role.
Enable API: https://console.cloud.google.com/apis/api/sheets.googleapis.com
Get Spreadsheet ID and the Sheet IDs from the URL:
https://docs.google.com/spreadsheets/d/[Your Spreadsheet ID Here]/edit?gid=[Your Sheet ID Here]]#gid=[Your Sheet ID Here]]
Installation
Use UPM to install the package via the following git URL: https://github.com/Bookfan97/YetAnotherGoogleSheetsPackageUnity.git or download and import the unity package manually.
Set the correct variables in either the project settings or Tools > Google Sheets > Open Preferences
Usage
Syncing Data between Unity Editor and a Google Spreadsheet
Roadmap
- [X] Upload/Download Support
- [X] CSV -> Scriptable Objects Support
- [X] Multiple Sheet Support
- [ ] Sheet Styling
- [ ] Logic For Updating Exisiting CSV and Scriptable Objects
- [ ] Editor Window
See the open issues for a full list of proposed features (and known issues).
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 better, please fork the repo and create a pull request. You can also simply open an issue with the tag "enhancement". Don't forget to give the project a star! Thanks again!
- Fork the Project
- Create your Feature Branch (
git checkout -b feature/AmazingFeature) - Commit your Changes (
git commit -m 'Add some AmazingFeature') - Push to the Branch (
git push origin feature/AmazingFeature) - Open a Pull Request
Top contributors:
License
Distributed under the MIT License. See LICENSE.txt for more information.
Contact
Project Link: https://github.com/Bookfan97/YetAnotherGoogleSheetsPackageUnity