apps-script

Collection of App Scripts for Google Drive documents and sheets.

Scripts

ai_deepseek.js

Provides a custom function DEEPSEEK for Google Sheets to query the DeepSeek AI API. It includes a menu to set the API key.

ai_openai.js

Contains the OPENAI_CHAT custom function to interact with OpenAI's chat completions endpoint (gpt-3.5-turbo) from Google Sheets.

google_docs_count_words.js

Counts words in a Google Doc, and has a function to find and highlight specific words, updating a Google Sheet with the counts.

google_docs_create_toc_bookmarks.js

Automatically generates a clickable Table of Contents (TOC) in a Google Doc from existing bookmarks.

google_sheet_google_maps.js

Provides custom functions GOOGLEMAPSLAT and GOOGLEMAPSLONG to get latitude and longitude for a location using the Google Maps Geocoding API.

google_sheet_google_places.js

Includes custom functions (GMAPS_getWebsite, GMAPS_getPhone, GMAPS_getAddress, GMAPS_getImage) to fetch place details from the Google Maps Places API.

google_sheet_remove_line_breaks.js

Adds a menu item to remove line breaks from a user-specified column in a Google Sheet.

google_sheet_resetColumnWidths.js

Resets the width of all columns in the active Google Sheet to the default value (100 pixels).

google_sheet_rss.js

Fetches, aggregates, and sorts RSS feeds from multiple sources, populating a Google Sheet with the data.

google_sheet_to_email.js

Reads data from a Google Sheet, filters for open tasks, and sends an email summary.

google_sheet_to_html.js

Creates a web app that displays data from a Google Sheet in an HTML table.