RaptorSheets.Gig 1.1.6

.NET 8.0 This package targets .NET 8.0. The package is compatible with this framework or higher. 
dotnet add package RaptorSheets.Gig --version 1.1.6
                    


                    

                
NuGet\Install-Package RaptorSheets.Gig -Version 1.1.6
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="RaptorSheets.Gig" Version="1.1.6" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="RaptorSheets.Gig" Version="1.1.6" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="RaptorSheets.Gig" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add RaptorSheets.Gig --version 1.1.6
                    


                    

                
#r "nuget: RaptorSheets.Gig, 1.1.6"
#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. 
#:package RaptorSheets.Gig@1.1.6
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package. 
#addin nuget:?package=RaptorSheets.Gig&version=1.1.6
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=RaptorSheets.Gig&version=1.1.6
                    


                            Install as a Cake Tool

RaptorSheets.Gig

Badge Name Status Site
Latest Build Status build status GitHub Repo
RaptorSheets.Gig Nuget Pkg Nuget Raptor Sheets - Gig

Note: RaptorSheets.Gig is built on top of RaptorSheets.Core. For advanced customization or to build your own integrations, see the Core documentation and API reference.

Quick Install

dotnet add package RaptorSheets.Gig

Project Description

This project is a library designed to manage interactions between a custom API service and the Google Sheets API. It offers the following features:

  • Appending data to specified sheets
  • Creating, formatting, and styling sheets
  • Retrieving data from all sheets (individually, in groups, or in batches)
  • Retrieving spreadsheet properties, such as the title and sheet tab names

Sheets

Below is a list of sheets that are automatically generated with CreateSheets() function.

# Sheet Name Description Reference Sheets
1 Trips This is a list of the trips you have accepted None
2 Shifts List of shifts you have worked Trips
3 Addresses List of addresses compiled from pickup and delivery locations Shifts
4 Names Names compiled from the trips you have accepted Trips
5 Places Locations compiled from the trips you have accepted Trips
6 Regions Regions compiled from your trips and shifts Trips, Shifts
7 Services Services compiled from your trips and shifts Trips, Shifts
8 Types Types compiled from the trips you have accepted Trips
9 Daily Daily statistics compiled from your shifts Shifts
10 Weekdays Weekday statistics compiled from daily data Daily
11 Weekly Weekly statistics compiled from daily data Daily
12 Monthly Monthly statistics compiled from daily data Daily
13 Yearly Yearly statistics compiled from monthly data Monthly

Using Library

Auth Modes

To authenticate, you can use one of the following methods:

Simple

Using the GoogleSheetManager allows you to skip referencing Google.Apis.Sheets.v4 package and just call the functions and receive data with common objects.

Create a new instance of the GoogleSheetManager with auth mode and spreadsheet id

var googleSheetManager = new GoogleSheetManager(authMode, spreadsheetId);

You can create all sheets, formats, and layouts in a new worksheet by calling CreateSheets()

await googleSheetManager.CreateSheets();

You can get all sheets and information by calling GetSheets()

var data = await googleSheetManager.GetSheets();

You can retrieve specific sheets and information by calling GetSheets() and passing in the sheet enums you want.

var sheets = [SheetEnum.Trips, SheetEnum.Shifts]
var data = await googleSheetManager.GetSheets(sheets);

Advanced

Using the GoogleSheetService allows you to change format, colors, and other options by referencing the Google.Apis.Sheets.v4 package.

API Reference

Testing

Global Testing Setup

Product Compatible and additional computed target framework versions.
.NET net8.0 is compatible.  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.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.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.1.6 67 9/22/2025
1.1.5 67 9/21/2025
1.1.4 264 9/19/2025
1.1.3 146 9/10/2025
1.1.2 120 8/24/2025
1.1.1 167 6/4/2025
1.1.0 163 6/1/2025
1.0.29 161 6/1/2025
1.0.28 158 6/1/2025
1.0.27 114 6/1/2025
1.0.26 118 4/26/2025
1.0.25 103 4/26/2025
1.0.24 199 4/8/2025
1.0.23 176 4/7/2025
1.0.22 186 4/6/2025
1.0.21 171 4/6/2025
1.0.20 171 4/6/2025
1.0.19 157 4/6/2025
1.0.18 186 4/3/2025
1.0.17 180 4/2/2025
1.0.16 193 4/2/2025
1.0.15 176 4/1/2025
1.0.14 172 4/1/2025
1.0.13 176 4/1/2025
1.0.12 177 4/1/2025
1.0.11 176 4/1/2025
1.0.10 157 3/21/2025
1.0.9 191 3/11/2025
1.0.8 214 3/3/2025
1.0.7 130 2/27/2025
1.0.6 127 2/26/2025
1.0.5 134 2/15/2025
1.0.4 130 2/15/2025
1.0.3 139 2/14/2025
1.0.2 146 2/11/2025
1.0.1 128 2/11/2025