Downloads

← Back Google Sheets plugin
Version:
1.9
Format:
Unity package
Dependencies:
BGDatabase (v. >= 1.8.13)
Download links are below ⬇

Description

This plugin adds support for export/import to Google Sheets in Unity Editor.

Downloads

Package description Version BGDatabase version Unity version Link
The plugin package WITHOUT Newtonsoft.Json.dll 1.9 >= 1.8.13 >=2020 LTS download
Alternative plugin package WITH Newtonsoft.Json.dll DLL included. 1.9 >= 1.8.13 2019 LTS download

Setup

  1. Download and import this plugin
  2. Check the Unity console: if you see some error, related to Newtonsoft.Json.dll, read the section below
  3. Step-by-step guides for setting up GoogleSheet data source is available here

Resolving Newtonsoft DLL conflict

Unity version >= 2020 LTS seems to have Newtonsoft.Json.dll (JSON.NET) installed by default, and it conflicts with Newtonsoft.Json.dll, bundled with GoogleSheets API DLLs. We provide 2 different packages of the plugin, with and without Newtonsoft.Json.dll.

  1. If you encounter the error "Newtonsoft.Json.dll can not be found"- use the package with Newtonsoft.Json.dll included.
  2. If you encounter the error "Multiple precompiled assemblies with the same name Newtonsoft.Json.dll included for the current platform"- delete installed plugin(Assets\BansheeGz\BGDatabaseGoogleSheetsEditor folder) and import the package without Newtonsoft.Json.dll included.

Using source code

We provide source code for our plugins, so you can use source code instead of built DLL file or build your own DLL using source code.

Guide for using source code:

  1. While importing plugin package, check the packages with source code only
  2. Download required library - Google APIs (min version 1.41.1) here and add library DLLs to your project to the Editor assembly (under Editor folder) (the following DLLs are required- Google.Apis.dll, Google.Apis.Auth.dll, Google.Apis.Auth.PlatformServices.dll, Google.Apis.Core.dll, Google.Apis.Sheets.v4.dll, Newtonsoft.Json.dll )
  3. Import source code packages

Releases

Click to see all releases
Version Release date Download Dependencies Log
1.9 Nov 1, 2024 link BGDatabase (v. >= 1.8.13)
  1. ADDED: support for full path for nested relations
  2. ADDED: support for exporting calculated/programmable field values
1.8 Nov 11, 2023 link BGDatabase (v. >= 1.8.7)
  1. ADDED Localization support. Configurable locale settings under DataSource->Misc. By default, all new data sources will use spreadsheet locale
  2. CHANGED minor performance improvements for data importing
1.7 Nov 12, 2022 link BGDatabase (v. >= 1.7.11)
  1. ADDED support for relations configuration (option to serialize relational values as strings/ints instead of ID or Name_ID)
  2. CHANGED when rows mapping config with int/string field as ID is used, rows with empty/duplicate ID values are not exported anymore
  3. Export job keeps the rows with empty field ID values intact (instead of removing them), when rows mapping config is on and int/string field is used instead of entity ID
1.6 Jun 20, 2022 link BGDatabase (v. >= 1.7.7) ADDED support for objectListMultiValueReference field
1.5 May 10, 2022 link BGDatabase (v. >= 1.7.6) CHANGED: GoogleSheets OAuth 2.0 OOB (out-of-band) flow is deprecated. Read this blog post for more information. Loopback IP address is now used instead to receive authorization code. You can find more information here (search for redirect_uri parameter usage)
1.4 Dec 22, 2021 link BGDatabase (v. >= 1.7.1) ADDED: many tables relational fields support ADDED: additional check to avoid data collision during exporting CHANGED: C# language 4.0 -> 7.1 CHANGED: min NET 4.5 -> 4.7.1
1.3 May 26, 2021 link BGDatabase (v. >= 1.6.8) ADDED: rows mapping configuration
1.2 Apr 29, 2021 link BGDatabase (v. >= 1.6.2) CHANGED: float numbers format is changed to g7
1.1 Oct 28, 2020 link BGDatabase (v. >= 1.6.2) ADDED: names mapping config
1.0 Sep 16, 2020 link BGDatabase (v. >= 1.6) Initial release
← Back to Downloads