DataNest 2025.9.3

DataNest

DataNest is a lightweight .NET wrapper for the Google Sheets and Google Drive APIs.
It simplifies authentication, data access, and file management in your applications while supporting Dependency Injection (DI) for clean integration.

✨ Features

• ✅ Easy Google Sheets read/write
• ✅ Google Drive file & folder management
• ✅ Strongly typed async APIs
• ✅ Supports Dependency Injection
• ✅ .NET 9 ready

📦 Installation

Install via NuGet:

dotnet add package CodeEvolveLabs.DataNest

🔧 Setup

1. Enable the Google Sheets API and Google Drive API in Google Cloud Console.
2. Download your credentials.json file.
3. Place it in your project (or a secure location).

🚀 Usage

1. Register DataNest with Dependency Injection

using DataNest;
using Microsoft.Extensions.DependencyInjection;

var services = new ServiceCollection();

// Register DataNest with DI
services.AddScoped<IDataNestService>(provider =>
    new DataNestService(new DataNestOptions
    {
        CredentialsPath = "credentials.json",  // path to your credentials file
        ApplicationName = "MyApp"
    })
);

// Build the service provider
var provider = services.BuildServiceProvider();

// Resolve the service
var dataNest = provider.GetRequiredService<IDataNestService>();

2. Working with Google Sheets

// Append a row
await dataNest.Sheets.AppendRowAsync(
    spreadsheetId: "your-spreadsheet-id",
    range: "Sheet1!A:D",
    values: new[] { "Name", "Email", "Date" }
);

// Read rows
var rows = await dataNest.Sheets.ReadRowsAsync(
    spreadsheetId: "your-spreadsheet-id",
    range: "Sheet1!A:D"
);

foreach (var row in rows)
{
    Console.WriteLine(string.Join(", ", row));
}

3. Working with Google Drive

// Create a folder
var folderId = await dataNest.Drive.CreateFolderAsync("Reports", parentFolderId: null);

// Upload a file
var fileId = await dataNest.Drive.UploadFileAsync(
    localFilePath: "report.pdf",
    folderId: folderId
);

// Move file to another folder
await dataNest.Drive.MoveFileAsync(fileId, newParentFolderId: "another-folder-id");

📖 Roadmap

• Batch update Google Sheets
• Drive file sharing permissions
• More DI-friendly typed clients (ISheetsService, IDriveService)

📜 License

This project is licensed under the MIT License.

📢 Feedback & Issues

We’d love to hear your thoughts! If you encounter any issues, have feature requests, or simply want to share feedback, please fill out our short form: https://forms.gle/ogPRAoCrAHRwWzqx5

👉 Submit Feedback & Issues

Your input helps us improve PolyAdo for everyone 🚀