GoogleSheets export/import for Runtime

Version:

0.9Beta

Format:

Unity package

Dependencies:

BGDatabase (version >= 1.5.11)

Description

Export/import to GoogleSheets at runtime. Some restrictions apply (read below)

Restrictions:

1. This plugin is not meant to work on multiple devices simultaneously. Use it only if you have one, single device, reading/writing information from/to GoogleSheets spreadsheet
2. If all you need is to add new rows to Google Sheets, the better solution exists- read this post for more details

Setup:

1. Install BGDatabase (version >= 1.5.11)
2. Install GoogleSheets Editor plugin
3. Install this plug-in
4. Move (not copy!) all DLL files under folder Assets\BansheeGz\BGDatabaseGoogleSheetsEditor\Editor\Libs to runtime assembly (let's say to Assets/GDataV4 folder, we will use this folder as a reference, but this can be any folder not under Editor folder)
5. Move (not copy!) the following DLL fileAssets\BansheeGz\BGDatabaseGoogleSheetsEditor\Editor\Scripts\BGDatabaseEditorGoogleSheets.dll. to the same folder (Assets/GDataV4 folder)
6. Now we need to replace Newtonsoft.Json.dll with its AOT variant.
   1. Delete this DLL Assets\GDataV4\Newtonsoft.Json.dll
   2. Download and install Assets\JsonDotNet\Assemblies\AOT\Newtonsoft.Json.dll DLL file from this JSON package. You can also download it here
   3. Move Assets\JsonDotNet\Assemblies\AOT\Newtonsoft.Json.dll file to Assets/GDataV4 folder
7. Select any single DLL file under moved folder Assets/GDataV4. Mark it to target Any platform in Inspector. Make sure "Excluded platforms" are unchecked. Also uncheck "Validate references" (use the screenshot as a reference). Hit Apply button
   
8. Create GoogleSheets datasource in BGDatabase window (under DataSources tab) and fill in all required parameters
9. Add Assets\BGDatabaseGoogleSheetsRuntime\BGGoogleSheetsManagerGo.cs component to any GameObject inside your scene
10. Copy all settings from GoogleSheets datasource (you created at step 8 to BGGoogleSheetsManagerGo script settings
    
11. Toggle on Enable Setting parameter if you want to setup which tables/fields need to be updated. Settings are similar to Merge settings
    
12. Run the scene, expand "GoogleSheets>>" button and press "Export" or "Import" button
    
13. There is also an option to disable BGGoogleSheetsManagerGo's GUI and call BGGoogleSheetsManagerGo.Export and BGGoogleSheetsManagerGo.Import methods from your own scripts. Note, the task runs on separate thread and may take several frames to complete.

Releases