Methods for adding rows, columns, and individual cells to a GPAL grid.
GPALInput and GPALTextArea can feed GPAL.Ai as live input sources; GPALTextArea and GPALRichTextBox receive AI output; GPALStatusStrip shows AI status - wiring all three turns a form into a live AI interface.
Executes the conversion and appends the result to an existing file rather than overwriting it. Use when accumulating records across multiple converter calls.
REST API methods for navigating the browser, managing tabs and windows, and controlling window size.
Methods for configuring the browser type, driver location, download behavior, network settings, and automation engine mode.
Methods for attaching custom logic that runs after data entry, when selectors match elements, or when selectors find no elements.
Methods for attaching custom logic that runs after data entry, when selectors match elements, or when selectors fail to find elements.
Methods for adjusting where clicks land relative to an element, configuring drag offsets, and locating elements by image template matching.
Methods for defining the data type and properties of database columns when using GPAL to create tables or define schema.
Methods for comparing the content of a range against another file, grid, or range - useful for data validation and reconciliation.
Methods for setting the email envelope - from, to, CC, BCC, subject, body, and attachments.
Methods for authenticating with Google Drive and targeting specific files or local files for upload.
Methods for authenticating with Google Sheets, selecting a spreadsheet and sheet, and obtaining the Sheets object.
Methods for configuring the database connection - either via a full connection string or by setting server name, database name, username, and password individually.
Methods that filter found elements by checking if a property contains a substring - a looser match than the exact Match methods.
CredentialsConfig holds the OAuth endpoints, redirect URIs, vault API base URLs, and field-name keys used by every credential service. Load() reads ./credentialsConfig.json by default (or returns built-in defaults) and Save() writes it back. Both accept an optional GPALFile to redirect to a custom path and set it as the in-session default.
GPAL.Credentials and GPAL.CredentialsFor(serviceType) both start a credentials request; WithService selects the provider, and WithUsername/WithPassword set the account used to authenticate.
Methods for reading, creating, updating, and deleting database records, and for executing arbitrary SQL commands.
Three settings control how CSV, TAB, and PIPE-delimited input is parsed: whether the first row is column headers, whether fields are enclosed in quotes, and whether to skip the first row entirely.
Methods for extracting data from the current page - as a grid, raw HTML, sitemap URLs, Next.js hydration data, or an LLM-friendly page digest.
Log directly to a database table by attaching a GPALDatabase object to the logger.
Methods for removing rows and clearing all data from a grid.
CredentialServiceType.None supplies a username and password directly in code, with no password manager involved. SaveTo writes them straight into a grid for FillInFrom.
REST API methods for querying the DOM by XPath or CSS, retrieving element properties, and switching context to iframes and shadow DOM.
Methods for uploading, downloading, moving, renaming, deleting files, and listing files in Google Drive.
Read and write DOM attributes directly on matched elements.
REST API methods for clicking, typing, hovering, and filling inputs on elements identified by XPath, CSS, or element ID.
Methods for encoding plain text to Base64 and decoding Base64 strings back to text.
Methods that filter found elements by requiring an exact match on a specific property - text content, value, attribute, href, src, or placeholder.
Methods for configuring the executable to launch - path, arguments, name, working directory, and environment variables.
PuppeteerClient mirrors RESTClient's Execute family - Execute(), Execute<T>(), ExecuteAsync(), AndThen() - plus navigation, element interaction, and DOM query methods backed directly by CDP. All of it runs on GPAL's own custom CDP implementation, not a Puppeteer-library wrapper.
Methods for executing REST API calls - synchronously or asynchronously, with single or chained results, and for checking HTTP status.
Methods for configuring how GPAL reads a file - including the file path, delimiter, column names, header handling, quote behavior, and whether to overwrite on save.
Methods for downloading files by clicking links, uploading files through file inputs, printing pages to PDF, and exporting scraped data to CSV, Excel, or text files.
Methods for copying, moving, and deleting files.
Methods for populating form controls from data sources and for reacting after each row of data is applied.
Methods for finding a template image within the current screen and loading images from file or Base64 strings.
Methods for filling desktop application inputs from data sources - overwriting, appending, or inserting from strings, files, databases, or grids.
Methods for filling in form inputs from data sources - overwriting, appending, or inserting content from strings, files, databases, or grids.
Methods for configuring the GPALForm window - title, size, position, and which controls it contains.
Methods for applying formatting to a range of cells - alignment, color, number format, and text rotation.
Methods for initializing the Gherkin runner with either a browser or desktop application target.
Given, When, And, and Then - the four fluent methods that map to standard Gherkin BDD syntax for structuring automation workflows as human-readable specifications.
Methods for uploading, deploying, and triggering Google Apps Script within a spreadsheet.
A clickable button control for GPALForm. Triggers actions when clicked by the user or by automation.
A chart control for GPALForm. Renders data as a visual chart (bar, line, pie, etc.) within the form.
A checkbox control for GPALForm. Represents a boolean true/false value in an interactive GPAL form.
A dropdown combo box control for GPALForm. Lets the user select one value from a predefined list.
An editable data grid control for GPALForm. Allows users to view and edit tabular data directly within the form.
A date and time picker control for GPALForm. Lets the user select a date, time, or date-time combination.
A file browse control for GPALForm. Opens a file dialog when activated, letting the user choose a file path.
A single-line text input control for GPALForm. Used for free-text data entry.
A static text label control for GPALForm. Displays instructional or descriptive text that the user cannot edit.
A list view control for GPALForm. Displays a multi-row, multi-column data grid the user can select items from.
A numeric spinner control for GPALForm. Lets the user enter or increment/decrement a numeric value.
A progress bar control for GPALForm. Visually represents the completion percentage of a long-running operation.
A radio button control for GPALForm. Used in groups to allow the user to select one option from several.
A status strip control for GPALForm. Displays status messages at the bottom of the form window.
A tab container control for GPALForm. Organizes other controls into named tabbed panels.
A multi-line text input control for GPALForm. Used for longer text entry such as notes, descriptions, or multi-line data.
A tree view control for GPALForm. Displays hierarchical data as an expandable tree structure.
Methods for providing input to the AI model, specifying where results go, executing the task, and reacting to the AI response - including live form-wired input and output.
Methods for executing custom JavaScript on the page and for reading, writing, or deleting browser storage (cookies, localStorage, sessionStorage, IndexedDB).
Methods for launching the executable, waiting for it to complete, killing it, redirecting its output, and checking if it is running.
Methods for opening a Windows desktop application, passing launch parameters, assigning a name for identification, and closing it when done.
Methods for logging a value and configuring the log entry format - type, date format, delimiter, and date-as-attribute behavior.
WithCredentials(ICredentials) copies authentication fields - username, password, service key, OAuth tokens - from a previously-built credentials object, so a password manager's master login can be built once and reused across many lookups.
Methods for simulating clicks, keyboard input, drag-and-drop, and modifier key combinations.
Methods for clicking elements, typing text, pressing special keys, and switching focus between controls in a desktop application.
Methods for navigating the browser to URLs, moving through history, and closing the browser instance.
For Google, Azure, and AWS, FetchAccessToken exchanges a Google service account key or an OAuth client ID/secret (with WithScope) for an access token - opening a browser for one-time consent if no service account key or refresh token is supplied.
Methods for specifying which Excel file and sheet to operate on, and for closing the workbook when done.
Methods for specifying where log output goes - root directory, filename, filename pattern, and directory structure.
Methods for passing parameter values to SQL commands and stored procedures, and for using a grid as the parameter source.
WithService(LastPass / OnePassword / Dashlane / Bitwarden / Keeper) retrieves a saved login from that password manager. GetCredentialsFor sets the search target, WithDomain filters by URL, and SaveTo appends matching [Username, Password] rows to a grid.
Methods for attaching browser storage operations (cookies, localStorage, sessionStorage, IndexedDB) that execute automatically before the browser navigates to the URL.
Formats JSON, YAML, XML, or HTML with human-readable indentation and line breaks. All other formats (CSV, TAB, PIPE, etc.) are returned as-is.
PuppeteerClient is the in-process equivalent of RESTClient - the same fluent endpoint-based API, but commands are sent directly over a Chrome DevTools Protocol (CDP) connection instead of through the OttoMagic REST API.
PuppeteerCommunicator is the lowest-level layer in GPAL's browser stack - a managed websocket connection that speaks the Chrome DevTools Protocol directly, used internally by PuppeteerClient and the Puppeteer-based automation engines.
Methods for specifying the SQL query, stored procedure, or table name that a database operation runs against.
Methods for exporting Excel data to a file, grid, or string variable, and for calculating summary values from a range.
Methods for reading ranges, writing data, and appending or inserting values into Google Sheets.
Methods for reading individual cells, iterating rows, counting elements, and checking for value presence in a grid.
Methods that filter found elements using regular expressions on text, value, attribute, href, src, or placeholder - for when exact matching is too strict.
Registers a custom struct or complex nested type so the automapper can correctly deserialize it when using SaveTo<T>. Call before WithInput for each type that the mapper cannot resolve automatically.
Executes the conversion and returns the result in memory - as a string, database insert, file, or dynamic object. Use RenderTo when you need the converted output immediately in code rather than persisted to disk.
Methods for capturing query results as a DataTable, an IGPALGrid, or via the Tokens property for debugging.
Executes the conversion and writes the result to a file, database, grid, string, or strongly-typed class. SaveTo<T> is the flagship overload - it automaps converted data directly into a typed C# class with zero mapping code.
Methods for saving Base64-decoded bytes to a file and guessing the correct file extension from binary content.
Methods for capturing screenshots of the screen or browser, and for converting screenshots to Base64, Bitmap, or saving to file.
Register a script that runs automatically on every new document load (before page scripts run), and remove it later.
Methods for scrolling UI Automation elements within a desktop application, both vertically and horizontally.
Methods for scrolling the page, waiting for elements or conditions, and handling paginated or infinite-scroll data sources.
Methods for configuring how a selector behaves - stopping the workflow on failure, enabling scroll-based search, using OCR, naming the selector for logs, and selecting the interaction engine.
Attach conditional logic directly to a selector - run a delegate when elements are found or when no elements are found.
Methods for defining how GPAL locates an element - by CSS, XPath, AutomationID, name, text, value, href, or a custom attribute.
Methods for defining which UI automation elements the next action targets, including repeating element groups and persistent selectors.
Methods for defining which elements the browser's next action targets, including iframe context, shadow DOM, and repeating element groups.
Methods for sending the composed message, receiving incoming messages, clearing the current message configuration, and parsing email address strings.
Methods for configuring SMTP, IMAP, and POP3 server settings used when sending or receiving email.
Methods for initializing the RESTClient with an API base URL, endpoint, name, and optional OpenAPI map.
Methods for configuring the AI provider, task type, classification, and credentials before executing an AI operation.
Methods for creating, deleting, and renaming sheets, setting the spreadsheet title, and performing calculations.
Methods for displaying the form to the user, showing it as a modal dialog, and hiding it.
Methods for reducing automation detection - CDP protection, toString overrides, dark mode, Google referrer spoofing, chromedriver patching, and stealth clicking.
REST API methods for reading, writing, and deleting browser storage (cookies, localStorage, sessionStorage, IndexedDB) and for setting custom HTTP headers.
Methods for managing multiple browser tabs and windows, and for controlling the browser window state.
Methods for specifying which cells, ranges, rows, or columns an Excel operation applies to.
Methods for wrapping multiple database operations in a single transaction with commit and rollback support.
Methods for creating and updating a GPALUrl object that carries a URL string and optional pre-navigation storage actions.
Pass the access token returned by FetchAccessToken to RESTClient as a Bearer token to call the provider's API directly.
Methods for pausing execution until a specific time has passed, a UI element appears, or a named Windows window becomes visible.
WaitFor has three overloads on Browser - a fixed time, a Selector, or an ElementState - and behaves differently depending on whether it is called before or after an action in the current unit of work.
Sets the data source for the conversion. Accepts a file, database, grid, string, object, or dictionary list - GPAL infers the format or you can specify it explicitly with WithInputType.
Explicitly sets the format of the input data. Use when format cannot be auto-detected from a file extension or string content, or to override GPAL's detection.
Sets the target format for the conversion. Determines how SaveTo, RenderTo, and AppendTo serialize the data.
Methods for defining reusable REST workflows, looping over conditions, naming results for chained use, and retrieving accumulated execution results.
Methods for setting, replacing, inserting, prepending, and appending values within targeted cells or ranges.