Streamline Your Google Workspace Tasks Effortlessly with OneScript

Your all-in-one Google Apps Script library for Google Workspace Apps

Introduction

OneScript is my first Google Workspace add-on for Gmail, Google Calendar, Google Drive, Google Sheets, Google Docs, Google Slides, and Google Blogger.

Explore the features currently available for each of our Apps. I'll continue to add new features over time, so be sure to check back regularly for updates.

Installation

Install from Google Workspace Marketplace

News 🎉

10/14/2024

Added new custom function OS_COLOR_NAME to find the closest color name for a hex value in Google Sheets.

YouTube

Check this introduction video to get started, more feature introduction videos can be found in my channel.

Custom Functions

OneScript is introducing custom functions for Google Sheets. These functions all begin with "OS_". Here's a list of the currently available functions, with more to come in the future:

OS_IMPORTHTML - Import HTML with Regex in Google Sheets.

OS_CALENDAR - Create a Calendar View in Google Sheets.

OS_GOOGLE_NEWS - Import Google News into Google Sheets.

OS_YAHOO_FINANCE - Import Yahoo Financial News into Google Sheets.

OS_DIRECTION - Calculate distance or duration between two locations in Google Sheets.

OS_COLOR_NAME - Find the Closest Color Name for a Hex Value in Google Sheets.

Gmail

Group Emails - create and insert group emails in Gmail.

Google Calendar

Easy Repeat - create repeat events in Google Calendar with sequential indexed titles.

Google Drive

Easy Export - Export Google Docs, Sheets, and Slides to PDF, MS Word, Excel, and PowerPoint on Google Drive.

Easy Send - Send Google Docs, Sheets, and Slides as attachments with formats PDF, MS Word, Excel, and PowerPoint.

Google Sheets

Easy Tabs - An easier way to delete, hide, color, and sort the tabs in Google Sheets.

Google Maps Image - Insert Google Maps as images in the Google Sheets.

Google Docs

Any Page Size - Bring custom paper size to Google Docs.

Bionic Reading - Apply a bionic reading style to Google Docs.

Google Maps Image - Insert Google Maps as images in Google Docs.

Easy Merge - Update the placeholders in Google Docs.

Easy Blog - Turn Google Docs into Google Blogger posts or pages.

Easy CSV - Import CSV data to Google Docs.

Easy Translate - Bring Google Translate to Google Docs for the selected text.

Google Slides

Custom Shapes & Groups - Use Google Slides as a library for your custom shapes & groups.

Grid Shapes - Insert shapes with a grid layout in Google Slides.

Google Maps Image - Insert Google Maps as images in Google Slides.

Easy Merge - Update the placeholders in Google Docs.

Easy CSV - Import CSV data to Google Slides.

Changes

10/14/2024

Add a new custom function OS_COLOR_NAME to find the nearest color name for a hex value.

10/11/2024

Add new custom function OS_DIRECTION for distance & duration calculation for two locations.

10/4/2024

Add new param 'include_headers' for OS_GOOGLE_NEWS and OS_YAHOO_FINANCE

10/2/2024

Bring OneScript Functions to Google Sheets with OS_IMPORTHTML, OS_CALENDAR, OS_GOOGLE_NEWS and OS_YAHOO_FINANCE.

Add option 'Permalink Path' to 'Easy Blog' for custom link.

9/20/2024

Add a new feature 'Easy Translate' for Docs.

8/22/2024

Add the "Update" feature to "Easy Blog".

8/16/2024

Fix empty rows issue in “Easy CSV” for Google Docs.

Fix URL encode issue on “%20” in “Easy Blog” for Google Docs.

8/15/2024

Add a new feature 'Easy CSV' for Docs and Slides.

8/14/2024

Update feature 'Easy Blog' with links open in new tabs.

8/6/2024

Update feature 'Easy Blog' with more customizable options.

8/1/2024

Add a new feature 'Easy Blog' for posting Google Docs to Google Blogger.

7/30/2024

Add new feature 'Easy Merge' to Docs, and Slides.

7/22/2024

Sheets - Easy Tabs with hide, delete, sort, color.

Sheets - Merge Easy Hide and Easy Delete into Easy Tabs.

Drive - Update UI.

07/18/2024

Initial release in Marketplace.

OneScript Playlist (follow this playlist for new features)

Links

Terms of Service Privacy Policy Support

Hire me on Upwork Donate YouTube Github Twitter / X Instagram

Comments