Integrations

Google Sheets and Drive

Connecting

Both subsystems authenticate through GPAL.Credentials using a Google service account and the relevant OAuthScope (Google_Sheets or Google_Drive). See Credential Management in Core Concepts for how WithServiceAccountKey and WithScope fit together. GPAL.GoogleSheets.WithSpreadsheet(idOrTitle) selects the spreadsheet, then WithSheet(nameOrIndex) selects a worksheet within it. GPAL.GoogleDrive.WithCredentials(credentials) connects to Drive directly; WithLocalFile and WithFileId then target the local and remote sides of a file operation.

var credentials = GPAL.CredentialsFor(CredentialServiceType.Google)

.WithServiceAccountKey(GPAL.FileFor("service-account.json"))

.WithScope(OAuthScope.Google_Sheets)

.ToGPALObject();

var sheet = GPAL.GoogleSheets

.WithSpreadsheet("Quarterly Report")

.WithSheet("Summary");

Reading and Writing Data

On a selected sheet, WithReadRange sets an A1-notation range and SaveTo(out grid) or SaveTo(file) exports it. The same shapes GPAL.Excel uses for local workbooks. WithData supplies a grid to write, WithWriteRange sets the destination range, and WriteToSheet or AppendToSheet perform the write. On Drive, UploadTo and SaveTo move a file between local disk (WithLocalFile) and Drive (WithFileId), while MoveTo, RenameTo, DeleteFile, and ListFiles manage files already there.

// Read a range into a grid, then write a different range back

IGPALGrid<string> data;

sheet.WithReadRange("A1:D50").SaveTo(out data);

sheet.WithData(summaryGrid)

.WithWriteRange("F1")

.WriteToSheet();

// Upload a local export to Drive

GPAL.GoogleDrive

.WithCredentials(credentials)

.WithLocalFile("export.csv")

.UploadTo("export.csv");

Managing Sheets, Formatting, and Apps Script

Beyond reading and writing data, GPAL.GoogleSheets can create, rename, or delete worksheets and rename the spreadsheet itself. Cell formatting is available through a fluent range-then-format chain covering alignment, color, and number format. Apps Script support lets you push a script file to the spreadsheet's project and publish it as a callable web app -- the same things you can do from the Google Sheets toolbar, expressed as workflow steps.

Documentation Example

Documentation

Showing off some plain text in these paragraphs eligendi laboriosam illo nostrum corporis at libero vel voluptas? Expedita, facere dolores voluptatem ad ab rem assumenda soluta!

Other formats

Here you can find different accents and emphasis sit amet consectetur adipisicing elit. Obcaecati, iste distinctio veritatis eligendi laboriosam illo nostrum corporis at libero vel voluptas? Expedita, facere dolores voluptatem ad ab rem assumenda soluta!

This is a link and how it could look like bestlinkinthebeautifulworld. Obcaecati, iste distinctio veritatis eligendi laboriosam illo nostrum corporis at libero vel voluptas? Expedita, facere dolores voluptatem ad ab rem assumenda soluta!

Here's just some classic bold text adipisicing elit. Obcaecati, iste distinctio veritatis eligendi laboriosam notBoldSecondbestlinkinthebeautifulworld illo nostrum corporis at libero vel voluptas? Expedita, facere dolores voluptatem ad ab rem assumenda soluta!

Obcaecati, iste distinctio veritatis eligendi laboriosam adipisicing elit illo nostrum corporis at adipisicing elit libero vel voluptas? Expedita, adipisicing facere dolores voluptatem ad ab rem assumenda soluta!

Other cuple of colors in case we want to emphasize several ways adipisicing elit. Obcaecati, iste distinctio veritatis eligendi laboriosam adipisicing elit illo nostrum corporis at voluptatem libero vel voluptas? Expedita, facere dolores voluptatem ad ab rem assumenda soluta!

Adding Images to the content

Lorem ipsum dolor sit amet consectetur adipisicing elit. Obcaecati, iste distinctio veritatis eligendi laboriosam illo nostrum corporis at libero vel voluptas? Expedita, facere dolores voluptatem ad ab rem assumenda soluta! Lorem ipsum dolor, sit amet consectetur adipisicing elit. Quod veniam, quam ad expedita laborum sed at voluptates culpa ipsam ut vel. Ullam temporibus a mollitia quod aliquam ratione exercitationem nesciunt.

Coding Blocks

Lorem ipsum dolor sit amet consectetur adipisicing elit. Repudiandae quas consequuntur illo numquam assumenda autem exercitationem distinctio perspiciatis in natus. Eius dicta similique ipsam ipsa minima, nemo quae enim tempore.

GPAL

.CallIfNotFound(GenericCallIfNotFound)

.WithPublishToConsole();

//System.Drawing.Rectangle windowSize = new System.Drawing.Rectangle(10, 10, 1500, 1024);

// NOTE: we have to set browser = before we execute any steps

// this is due to the 'GenericCallIfNotFound' which might throw an exception, and BankScraper will not have the browser set when it calls scraper.Close()

// until the complete fluent line gets executed (meaning every step, meaning browser is not set until everything else succeeds)

browser = GPAL.Browser

.WithBrowserType(Enums.BrowserType.Chrome)

.WithProfileDataDirectory(ChromeProfileLocation)

.WithUseAutomationEngine(AutomationEngine.Selenium)

.WithWindowSize(new System.Drawing.Rectangle(0,0,1920,1080))

.ToGPALObject();

Integrations

Integrations

Google Sheets and Drive

Connecting

Reading and Writing Data

Managing Sheets, Formatting, and Apps Script

Documentation Example

Documentation

Category

Endpoint

Enpoint

Enpoint

Enpoint

Other formats

Adding Images to the content

Coding Blocks

On this page