Official scripts
Explore our curated collection of scripts
Sheets: export / download
Download a Google Spreadsheet to a local file in your chosen format. Returns path (or url on cloud browsers) and filename. xlsx/ods/pdf/zip export the whole doc; csv/tsv export a single tab (pass gid).
Sheets: list tabs
List the tabs of a Google Spreadsheet. Returns sheets (name, gid) and the spreadsheet title. gid feeds sheets_read_tab / sheets_write_cells / the edit?gid= URL.
Sheets: add tab
Add a tab to a Google Spreadsheet, optionally naming it in the same pass. Returns the new tab's gid and final name. Waits for the editor's save before resolving; needs edit rights.
Sheets: rename spreadsheet
Rename a Google Spreadsheet (the document title, not a tab). Returns the title as displayed after the rename. Waits for the rename to persist server-side before resolving; needs edit rights.
Sheets: new spreadsheet
Create a new Google Spreadsheet in My Drive, optionally with a title. Returns spreadsheetId, url, and firstGid (always 0). The file lands in Drive root (My Drive); moving it elsewhere is a Drive action, not a Sheets one.
Sheets: delete tab
Delete one tab of a Google Spreadsheet by gid. Returns deletedGid and remainingTabs (names left). The sheet's data goes with it (recover via Undo / Drive history); an unknown gid throws rather than risk deleting the wrong sheet; needs edit rights.
List Google Workspace invoices (CSV/PDF) over a date range
Lists Google Workspace billing invoices from the Admin Console over a date range and returns each invoice's document content in CSV or PDF format.
Search Google
Run a Google search and return the page's organic result cards (title, url, site, byline, meta, snippet), with redirect wrappers already cleaned from urls. Runs logged out by default; if the browser happens to carry Google cookies, results are personalized to that account/IP. Supports full Google query syntax: site:, quoted "exact phrases", OR, -exclude, intitle:. Quoted phrases return a smaller, more precise set; dropping quotes broadens recall with some near-miss results mixed in. Use site: to scope a domain/path, e.g. site:www.linkedin.com/in. Each call returns one results page (up to ~10 organic cards, no per-call count option). Use `page` (0-based) to move through further pages, mirroring the search results pager. Pages are reproducible on the same account/IP and are largely non-overlapping (occasional overlap of one result at page boundaries), so different pages can be fetched concurrently and unioned — always dedupe by canonical url. Narrow queries return the same results in the same order across replays on one account/IP; very broad, high-volume queries may reorder between runs. For broader coverage, fetch multiple pages concurrently and/or split the query itself — vary the site: path, phrases/OR-terms, or use `freshness` for disjoint date-bounded windows. Always dedupe by url.
Download a Google Drive file
Download one Drive file by id to the device. Binary files (PDFs, images, video, Office documents) download as stored; Google-native Docs, Sheets and Slides are converted on the way out, so pass format to choose pdf, docx, xlsx, csv and the rest. Returns the saved filename and location. For a whole folder, list it first and call this once per file.
Get Google Scholar author's papers
Fetch a Google Scholar author's profile (name, affiliation, verified-email domain, interest tags, citation metrics) plus their publication list, sorted by citation count as the profile itself shows. Google Scholar loads 20 papers at a time behind a "Show more" click; pass count to load further pages (capped at what the profile actually has).
Search Google Scholar authors
Search Google Scholar's author (Profiles) directory by name/keywords. Returns each matching author's id, name, affiliation, verified-email domain, interest tags, and total cited-by count, plus a cursor for the next page.
Explore keyword trends
Google Trends explore for 1-5 keywords in one compare query: interest over time (shared scale), interest by region, per-region share %, related topics and queries (top + rising), for a given geo/date range/category/property.
Search Google Drive
Search Google Drive by free text, or filter by name, file type, owner and modified-date range. Returns each match's file id, name, link and the folder it sits in. Drive's search results carry no sizes, types or dates, so filter by type rather than expecting those fields back, and use the folder listing script when you need full metadata.
Maps: Search Businesses
Search for businesses on Google Maps (anonymous, no login): name, category, address, phone, website, rating, reviews, GPS, place_id. Paginates via scrolling, controlled by the count argument.
List a Google Drive folder
List the files and sub-folders directly inside a Google Drive folder, without recursing or downloading anything. Returns each item's id, name, type, size, last-modified date, owner and link. Omit folderId to list My Drive's root.
Search Doctolib practitioners
Search Doctolib practitioners by specialty and location. Returns total, page, and providers with full_name, specialty, address, sector, payment_means, languages, telehealth, online_booking, matched_visit_motive, and profile_path. There are 20 providers per page and the order is server-ranked; profile_path (including ?pid=practice-N) is the join key for get_practitioner and list_slots.
Search Medium articles
Search Medium for articles by keyword: title, URL, author, publication, tags, claps, read time, and whether the article is locked (member-only). No login required.
Search Google Play apps
Search the Google Play Store for apps by keyword: package id, name, developer, rating, and icon for each result. No login required.
Sheets: rename tab
Rename one tab of a Google Spreadsheet by gid. Returns the gid and the name as displayed after the rename. If no tab in the spreadsheet has that gid it stops with a clear error instead of renaming a different tab. Waits for the editor's save before resolving; needs edit rights.
Get Medium article details
Fetch a Medium article's metadata: title, description, author, publication, published date, tags, read time, and whether it's free to read. No login required.
Sheets: clear range
Clear the values of an A1 range in one tab of a Google Spreadsheet (values only, formatting stays). Returns range and cleared. Clearing an already-empty range is a safe no-op; needs edit rights.
Sheets: read tab values
Read one tab of a Google Spreadsheet as a 2D array of display values. Returns values (row-major, '' for empty and non-top-left merged cells), nRows, nCols. Values are display strings after formatting (a date may read as "1.5").
Sheets: write cells
Write a 2D block of values into one tab of a Google Spreadsheet, top-left at startCell (clears the target rectangle first). Returns range, rows, cols, saved. Values are parsed per the spreadsheet locale ("1.5" in a FR sheet becomes 1 May; prefix ' to force text); leading = enters a formula; in-cell newlines are dropped; needs edit rights.
Lucidchart login (Google SSO)
Log into Lucid (Lucidchart) using your connected Google account. Lands on the Lucid documents home; returns early if already signed in.
Get Google Play app details
Fetch an Android app's store listing details: name, description, developer, category, rating, review count, price, and icon. No login required.