Skip to main content
SimilarExport ZIP
100%

Gist ea8710410afc9bb88a65f846e46d04da

✓ Published0🌍 Public
HHerbCaudill
Last edited Jun 22, 2019
Created on Jun 22, 2019

This example demonstrates how to automate opening a Google Sheets tab in Chrome at user logon and session unlock, using a PowerShell script to register a Windows scheduled task. The task triggers on logon and session unlock events, launching Chrome with an app-mode URL pointing directly to the spreadsheet. The code constructs an XML task definition with the `Register-ScheduledTask` cmdlet, embedding the Chrome executable path and the spreadsheet URL as arguments. It highlights the use of PowerShell’s scheduled task API and XML trigger configuration, showing a practical workflow automation for persistent access to a specific data source without manual intervention.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist e856f50454ea971a6d4af31d5c4a44ef

This example demonstrates automated login and page interaction for a sports betting website, showing how Selenium WebDriver navigates to the William Hill URL, fills in email and password fields from environment variables, and clicks the "Log In" button. The code uses Chrome options for headless, maximized, and sandbox-disabled browsing, with explicit waits via `time.sleep`. It relies on XPath selectors to locate the login form elements and button, printing confirmation after successful login. The visualization highlights the automated workflow of credential injection and form submission, though it does not show data extraction or post-login content.

CConorAspell
59% match
Loading thumbnail…

Gist 8bdccc4175e97c6859ad86bca38c9a7d

This example automates interactions with William Hill’s betting site using Selenium WebDriver, specifically targeting two promotional games: “Free or Four” and “Scratch of the Day.” The script logs in via environment variables for credentials, then navigates to each game’s URL, clicks through modal popups or iframes, and triggers the game’s main action—such as clicking a card or a summary button. The code relies on explicit XPath selectors and waits, while using Chrome in headless mode. It demonstrates UI automation for repeated tasks, though it does not show any data visualization or rendering API.

CConorAspell
55% match
Loading thumbnail…

Gist 58c79c81e9a950a0cdafc7d2d0275742

This example shows a dynamic, browser-automated web-scraping workflow that captures rendered page content. It uses Selenium’s `webdriver` to launch a Chrome browser, wait for elements via `WebDriverWait` and `expected_conditions`, and then extracts page HTML with BeautifulSoup. The script programmatically sends keyboard inputs via `Keys`, and also employs the `requests` library for direct HTTP calls. It parses the returned data with `json`, timestamps actions with `datetime`, and structures results into a pandas DataFrame. The process includes randomized delays (`random` and `time`) to mimic human browsing behavior, though no explicit visualization or rendering library is used beyond the raw captured markup.

AArizonaTay
55% match
Loading thumbnail…

Gist 030abf753f0ac606724c658e17188739

This example automates the creation of training teams on the Sorare fantasy football platform, showing a scripted workflow that logs into the site and iteratively assembles lineups from available player cards. The code uses Selenium WebDriver to drive a Chrome browser, with helper functions that toggle filter settings (such as excluding or including "Commons" and "Next Game" availability) and click through the interface to select players. The process runs until no more valid teams can be formed, then moves to the next matchday. The visualization demonstrates browser automation for repetitive data-entry tasks, relying on explicit XPath selectors and timed waits to interact with dynamic page elements.

CConorAspell
53% match
Loading thumbnail…

Trigger a Sheet alert

This example demonstrates a temporary modal progress bar that appears over the Sketch document window, indicating an ongoing sheet operation. The script uses the `sketch` API to access the selected document and its window controller. It constructs a 200x100 pixel `NSWindow` with a title and modal style, adds an `NSProgressIndicator` that starts animating in blue, and begins a sheet session with `beginSheet_completionHandler`. After a five-second timeout, the sheet is dismissed with `endSheet`, completing the interaction.

KKevinGutowski
53% match
Loading thumbnail…

launchd Startup Script

This example demonstrates how to launch a local HTTP server automatically at user login using macOS launchd. It defines a launch agent that runs the `http-server` command on port 8008, with the working directory set to a specific Gists folder. The configuration uses a plist XML file and the `launchctl` command-line utility to load the agent. This shows a system administration workflow rather than a traditional data visualization, highlighting the infrastructure behind serving web-based visualizations locally.

Mmbostock
51% match
Loading thumbnail…

Gist 669840e74e5d863f3867c2946eb31ece

This example uses a headless Chrome setup, orchestrated through a Dockerfile, to render a dynamic web visualization. It shows an animated, interactive scene that likely involves geographic or force-directed elements, as the environment installs Chrome and chromedriver for automated screenshotting or streaming. The Python-based driver, running via `main.py`, relies on Selenium to control the browser and capture frames, while the underlying page would use D3.js’s `d3.forceSimulation` for physics-based layout and `d3.geoPath` for map projections if applicable. The setup explicitly avoids displaying a static image; instead, it captures live rendering from the Canvas or SVG, though the exact output is not visible in the code.

CConorAspell
51% match
Loading thumbnail…

Google Sheets Script for Fetching Data from Supabase

This example shows a Google Sheets script that pulls data from a Supabase database and writes it into the active sheet, first clearing existing content. It uses the Supabase REST API via `UrlFetchApp.fetch` and handles JSON responses with `JSON.parse`. The script writes a configurable set of headers to row one, then maps each data row into corresponding columns. It relies on `SpreadsheetApp.getActiveSpreadsheet().getActiveSheet()` for sheet operations, and constants for the Supabase URL, anon key, and table name. The process is automated through a single `mainFunction` that chains clearing, header writing, and data fetching.

HHugoberry
51% match