- The addon uses two dlls:
- Newtonsoft.Json
- System.Net.Http
- To get them working in the project:
- search for {project-name}.csproj
- inside the tag where there are some dlls reference insert:
<Reference Include="Newtonsoft.Json">
<HintPath>$(ProjectDir)/addons/sheet_db/DLL/Newtonsoft.Json.dll</HintPath>
<Private>False</Private>
</Reference>
<Reference Include="System.Net.Http">
<HintPath>$(ProjectDir)/addons/sheet_db/DLL/System.Net.Http.dll</HintPath>
<Private>False</Private>
</Reference>
- And in the compile section
<Compile Include="addons\sheet_db\SheetDB.cs" />
<Compile Include="addons\sheet_db\Compressor.cs" />
<Compile Include="addons\sheet_db\Custom_Model.cs" />
<Compile Include="addons\sheet_db\Init.cs" />
- Go to https://sheet.best/dashboard/sheets - if u dont have an account, create one using your google account where the sheet is located
- Click New Sheet API
- Type the Name and then place the GOOGLE SHEET URL
- Maybe you have to make the sheet public or share link
- If you take a look at the addons/sheet_db/SheetDB.cs folder you will see a variable called api_url
- go to Sheetbest dashboard and click view api and past this url there
- Go to Godot > Project > Project Settings > Plugin > Set SheetDB to Active
- if everything goes well the output will be this:
Starting Sheets Db...
https://sheet.best/api/sheets/744ccc66/
if you see the api_url above database is configured successfully
To use the database just call Sheets.SheetDB from anywhere