GoogleSheets

Google Apps Script Integration

UploadScript uploads a .gs script file or a raw script string to the spreadsheet's Apps Script project. GetOrCreateScriptProject creates a new Apps Script project linked to the spreadsheet, or retrieves the existing one. SetupCloudProject links an existing Google Cloud project by name. DeployScriptAsWebApp deploys the uploaded script as a web app and returns the URL. CreateTrigger adds a time-driven or event-driven trigger to the script. Configure deployment with WithDeploymentDescription, WithExecuteAs, WithScriptAccess, WithVersionNumber, and WithScriptName.

WARNING

UploadScript has both a GPALFile overload (reads the script from a .gs file on disk) and a separate string overload (uploads the string directly as the script source). As with Converter.WithInput, C# resolves a bare string argument to the string overload, so UploadScript("automation.gs") would upload the literal text 'automation.gs' as the script, not the file's contents. Use GPAL.FileFor("automation.gs") to upload from a file.

Examples

GPAL Fluent: High-level fluent C# API

//DeployScriptAsWebApp returns the deployment URL as an out string. Scripts must have a doGet or doPost function to be usable as a web app. Triggers can be TimeBased or event-based (Edit, Open, FormSubmit, Change and the rest).

// the Sheets object first, then the credentials that drive the API

GoogleSheets sheets = (GoogleSheets)GPAL.GoogleSheets.ToGPALObject();

sheets.WithCredentials(googleCreds);

// Upload and deploy a script

string webAppUrl;

sheets.WithSpreadsheet("spreadsheet-id");

sheets

.WithProjectId("gcp-project-id")

.WithScriptName("MyAutomation")

.WithExecuteAs(ExecuteAsType.USER_DEPLOYING)

.WithScriptAccess(ScriptAccessType.ANYONE)

.WithDeploymentDescription("v1.0 initial deploy")

.UploadScript((GPALFile)"automation.gs")

.DeployScriptAsWebApp(out webAppUrl);

// Add a time-driven trigger

sheets.WithSpreadsheet("spreadsheet-id");

sheets

.WithSheet("Report")

.WithTriggerFunction("runDailyReport")

.WithTriggerSchedule(TriggerScheduleType.Daily)

.CreateTrigger(GoogleTriggerType.TimeBased);

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();

GoogleSheets

GoogleSheets

Google Apps Script Integration

Examples

Documentation Example

Documentation

Category

Endpoint

Enpoint

Enpoint

Enpoint

Other formats

Adding Images to the content

Coding Blocks

On this page