Sushi.Mediakiwi.Module.GoogleSheetsSync 1.0.0

There is a newer version of this package available.
See the version list below for details.
dotnet add package Sushi.Mediakiwi.Module.GoogleSheetsSync --version 1.0.0
NuGet\Install-Package Sushi.Mediakiwi.Module.GoogleSheetsSync -Version 1.0.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Sushi.Mediakiwi.Module.GoogleSheetsSync" Version="1.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Sushi.Mediakiwi.Module.GoogleSheetsSync --version 1.0.0
#r "nuget: Sushi.Mediakiwi.Module.GoogleSheetsSync, 1.0.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install Sushi.Mediakiwi.Module.GoogleSheetsSync as a Cake Addin
#addin nuget:?package=Sushi.Mediakiwi.Module.GoogleSheetsSync&version=1.0.0

// Install Sushi.Mediakiwi.Module.GoogleSheetsSync as a Cake Tool
#tool nuget:?package=Sushi.Mediakiwi.Module.GoogleSheetsSync&version=1.0.0

Sushi.Mediakiwi.Module.GoogleSheetsSync

A list module for use in Mediakiwi which allows for synchronizing data with GoogleSheets

Installation steps :

  • Download the ServiceAccount credentials file from the Google Cloud API explorer.
  • Download the OAuth client secrets file from the Google Cloud API explorer (optional).
  • Place these files in the Root of your project and set 'Copy to output directory' to always.
  • Add these lines to your startup code :
// Get credential Files for Google Sheets
var serviceAccountCredentials = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "sheetsCredentials.json");
var clientSecretCredentials = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "sheetsClientSecret.json");

// Install both Import and Export modules
services.AddGoogleSheetsModules(serviceAccountCredentials, clientSecretCredentials);

This will also create the database table if needed, so the database connectionstring must be known at this point. This can be done with :

MicroORM.DatabaseConfiguration.SetDefaultConnectionString(connString);

Things to note :

  • You can also enable only one Module, by setting enableExportModule or enableImportModule.
  • You can omit the ClientSecrets file parameter, the module will then use the shared ServiceAccount for creating and uploading the Sheets.
  • When using the ClientSecrets param, each user will see it's own personal version of the created Sheet.
  • When using only the ServiceAccount param, each user will see the same version of the created Sheet.
  • The Import module will only show up if the list has an implementation for the ListDataReceived event.
Product Compatible and additional computed target framework versions.
.NET net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
1.0.11 2,235 10/18/2022
1.0.10 402 9/2/2022
1.0.9 367 9/1/2022
1.0.7 2,106 5/20/2022
1.0.6 390 5/19/2022
1.0.5 464 4/29/2022
1.0.4 702 2/21/2022
1.0.3 396 2/21/2022
1.0.2 399 2/18/2022
1.0.0 403 2/16/2022