Skip to main content
100%

Gist f43601b1f490d87ec6f8

✓ Published0🌍 Public
Aandybak
Last edited Jan 25, 2012
Created on Sep 15, 2014

This example shows a Python script that downloads a Google Spreadsheet as a CSV file and prints its rows. The code defines a `Spreadsheet` class and a `Client` class that handles authentication via Google’s ClientLogin API, using `urllib` and `urllib2` for HTTP requests and `re` for parsing the authentication token. It then fetches the spreadsheet’s contents through the Google Sheets export feed, specifying the format as CSV and a worksheet ID, and parses the result with the standard `csv` module. The script demonstrates a straightforward command-line workflow for accessing spreadsheet data programmatically.

AI-generated description

Similar vizzes

Loading thumbnail…

Google Spreadsheet-generated CSV -> Reddit Flair Python script

This example automates Reddit flair updates by reading a Google Spreadsheet-generated CSV and applying the results to a subreddit. The Python script uses `csv.DictReader` to parse the CSV data, `urllib2.urlopen` to fetch the file, and a custom `RedditClient` class to log in and call the `flaircsv` API endpoint. It transforms raw rows into flair descriptions and belt colors, batching assignments in groups of 100 to avoid API limits. The script runs continuously in a loop until login succeeds, then prints a final count of modified users.

SSimonS
62% match
Loading thumbnail…

google spreadsheet cheat sheet

This example shows a reference cheat sheet for common Google Sheets tasks, focusing on formulas that fetch external data. It demonstrates how to retrieve exchange rates using `GoogleFinance` and how to import cell ranges from another document using `importRange`. The code lists both full-range and single-cell import variations, with the data source specified by a spreadsheet ID and sheet range. The gist provides ready-to-copy formulas rather than a rendered visualization, emphasizing practical spreadsheet automation over graphical output.

Aabernier
62% match
Loading thumbnail…

Gist ea8710410afc9bb88a65f846e46d04da

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.

HHerbCaudill
61% match
Loading thumbnail…

Retrieve Google Spreadsheets content

This example shows a web page that pulls content from a published Google Spreadsheet and renders it as a numbered list of image cards with text and credit lines. The spreadsheet’s first two rows provide the headline and deck, while each subsequent row supplies an image URL, title, and credit. The code uses jQuery’s `$.getJSON` to fetch data from the Google Spreadsheets feed API, parses the returned JSON, and dynamically appends HTML elements to a container. It relies on a single function, `buildList`, which takes the spreadsheet ID as an argument, and uses basic array storage and string interpolation to build the layout.

LLayne Smith
60% match
Loading thumbnail…

Gist 6fe95d260d540a3c985ea8e637b33a80

This example shows a Google Apps Script workflow that automatically invites people to a Slack workspace when they submit a Google Form. It uses the SpreadsheetApp trigger API to listen for form submissions, the UrlFetchApp service to call Slack’s `users.admin.invite` endpoint with an admin token, and the GmailApp service to send email notifications about new sign-ups. The script also includes an initialization function that sets up the form-submit trigger, and it maps form response columns to email, inviter name, and timestamp fields.

Aallilevine
59% 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
59% match
Loading thumbnail…

Gist c700120232ca68a90adc791f75c8a16c

This example demonstrates a Python client for controlling a 3D drawing environment through a local HTTP API. It shows how to remotely manipulate a brush, spectator camera, and user position using simple method calls that construct URLs with query parameters. The code uses `urllib.request.urlopen` to send commands to a server at `localhost:40074`, enabling actions like drawing strokes, moving the brush, turning the camera, and toggling spectator mode. It also provides shortcuts for showing folders, exporting sketches, and listening for stroke data, making it a toolkit for interactive visualization scripting.

Aandybak
57% match
Loading thumbnail…

Gist 40be33d9a867660bd732

This example shows how to export every user table from an Access database to a single Excel workbook. The VBA macro iterates through all table definitions, skipping system tables whose names start with “MSys.” For each remaining table, it calls `DoCmd.TransferSpreadsheet` to export the table’s data into the file `excel_out.xls`, using the `acSpreadsheetTypeExcel9` format. It replaces the `dbo_` prefix in table names when creating the destination worksheet names. The output file path is derived from the current project’s directory.

Aandybak
57% match