Google Apps Script Collection

This repository contains a collection of custom Google Apps Scripts designed to enhance functionality within Google Workspace, primarily for Google Sheets. Each script is located in its own directory with specific instructions.

Scripts in this Repository

Below is a list of the available scripts in this collection. For detailed information, setup, and usage examples, please refer to the README.md file within each script's directory.

• get-latlong: A set of custom functions (GetLatitude, GetLongitude) to retrieve geographic coordinates from a text-based address.
• get-news-rss: A custom function (GET_NEWS) that fetches and cleans news article URLs from the Google News RSS feed for a predefined period (August 2025).
• get-currency-rate: A custom function (GET_CURRENCY_RATE) to fetch real-time currency exchange rates from a public API.
• create-docs-from-sheet: A script that adds a custom menu to generate Google Docs from each row in a sheet, perfect for batch document creation.
• webhook-logger: A Web App that logs incoming HTTP POST request data (webhooks) into a Google Sheet.

General Installation

To use any of these scripts in your Google Sheets, follow these general steps:

1. Navigate into the directory of the script you wish to use.
2. Open the .gs file and copy its entire content.
3. Open the Google Sheet where you want to use the script.
4. Go to the menu and select Extensions > Apps Script.
5. Paste the copied code into the script editor, replacing any boilerplate code.
6. Click the "Save project" icon.
7. Return to your sheet. You can now use the custom function as described in its specific README.md file.

Note: Some scripts may require you to enable advanced Google services or grant specific permissions. Please check the README.md in the script's folder for any setup prerequisites.

License

This project is licensed under the MIT License. See the LICENSE file for details.