Google Sheets Link Auto Opener automatically opens a popup window when the value of the currently selected cell in a Google…

Latest Version

Version
1.0.1
Update
October 4, 2024
Size
183KiB
Developer
findgrep.app
Category
Users
659
Rating
1 ★
Manifest Version
3
Web Store Status
Languages Support
English (United States)
See more
Permissions
Storage
ActiveTab
See more

Google Sheets Link Auto Opener Extension

Google Sheets Link Auto Opener automatically opens a popup window when the value of the currently selected cell in a Google Spreadsheet is a URL. It enables users to view the spreadsheet and the content of the URL in a side-by-side arrangement, facilitating seamless and rapid review of both the spreadsheet data and the linked web content.

This feature is particularly useful for efficiently comparing details of digitized invoices and receipts (processed through OCR or AI) against their original files.

Key Features:

Regular Expression-Based Filtering: This extension allows for the automatic opening of links only if the URL in a given cell, or the cell range/name, matches a specified regular expression pattern. This capability effectively prevents the opening of irrelevant links.

Privacy:

This extension does not send or store any information to external services.



Sample data for screenshots was sourced from https://expressexpense.com/blog/free-receipt-images-ocr-machine-learning-dataset/
Read more

Source Manifest.json

{"update_url": "https://clients2.google.com/service/update2/crx", "manifest_version": 3, "name": "Google Sheets Link Auto Opener", "version": "1.0.1", "action": { "default_popup": "src/popup/index.html" }, "permissions": [ "storage", "activeTab" ], "background": { "service_worker": "service-worker-loader.js", "type": "module" }, "content_scripts": [ { "js": [ "assets/content.ts-loader-55_LaoQr.js" ], "matches": [ "https://docs.google.com/spreadsheets/d/*" ] } ], "icons": { "16": "icon_16x16.png", "32": "icon_32x32.png", "48": "icon_48x48.png", "128": "icon_128x128.png" }, "web_accessible_resources": [ { "matches": [ "https://docs.google.com/*" ], "resources": [ "assets/storage-hxP3bRwt.js", "assets/content.ts-wE-U5s_Z.js" ], "use_dynamic_url": false } ]}
Read more

How to download and manually install Google Sheets Link Auto Opener extension for Chrome

Looking for a way to install Google Sheets Link Auto Opener extensions for Chrome, you can search for them in the Chrome Web Store, clicking the "Add to Chrome" button, and following the straightforward process.

However, you may need to install Google Sheets Link Auto Opener extensions manually, this article outlines two simple methods to effortlessly install Google Sheets Link Auto Opener extensions, whether they come as unpacked folders in compressed formats like .zip or as .crx files.

Method 1: Download Google Sheets Link Auto Opener extension and manually install through Drag &Drop

If you ever need to manually install a Google Sheets Link Auto Opener extension for Chrome, don't worry, it's a simple process. Just follow these easy steps, and you will have your extension ready to use in no time.

Step 1: Download the Google Sheets Link Auto Opener Extension by clicking the "Download CRX" button on the website.

Look for the Google Sheets Link Auto Opener extension you wish to install. Go to the website and download the Google Sheets Link Auto Opener extension package, which is usually a .CRX file and comes in a zipped file. Here ".crx" file is the format for Google Sheets Link Auto Opener extension that contains all the data.

Step 2: Extract &Arrange Files

Once the file is downloaded, extract that file into its own folder. Similarly, give that extension files a permanent home. In other words, keep it in a folder that you don't accidentally delete it because these files will be needed to make that extension work.

Step 3: Go to the Chrome Extensions Page

Open Google Chrome and in the address bar, type chrome://extensions; it will open the Google Chrome extensions page. Make sure that "My extensions" is selected in the sidebar.

Step 4: Drag and Drop the Extension

Now, go to the folder where you extracted the Google Sheets Link Auto Opener extension and drag &drop the extension file from there anywhere onto the extension page within Google Chrome.

Step 5: Complete the Installation

Once you drag and drop the extension file, follow the steps that Google Chrome takes you through. Similarly, if the extension file is of .crx file format, you will be required to review the permissions and then add the extension.

Now, you can manage that added extension as you would like to with any other Chrome extension that you added through Chrome Webstore. Its icon will also appear in the Google Chrome Menu on the right side of the address bar once you activate it.

Method 2: Download Google Sheets Link Auto Opener extension for Chrome and install in Developer Mode

This is another method to install Google Sheets Link Auto Opener extension manually, but the twist is that here, you install by enabling the developer mode option provided in Google Chrome. This mode is commonly used for testing extensions or running unpublished tools.

Step 1: Download the Google Sheets Link Auto Opener extension file

Select and download the Google Sheets Link Auto Opener extension by clicking the 'Download CRX' button on the website.

Step 2: Extract the downloaded contents

Convert the file to a ZIP file if it is in CRX format then extract the Google Sheets Link Auto Opener extension zip file or folder that you downloaded. Make sure you extract it using the same folder name and keep it safely in another folder, so you don't delete it by mistake. The extracted folder will be needed to keep your Google Sheets Link Auto Opener extension running.

Step 3: Open Chrome Extension Setting Page

In the address bar of Google Chrome, type chrome://extensions and open the Chrome Extension Page.

Step 4: Enable Developer Mode

After opening the Chrome Extension page, look at the top right side, and you will find the toggle option of "Developer mode."Simply enable that developer mode option.

Step 5: Load the Unpacked Extension

Once you enable the developer mode option, you will see the menu of Load Unpacked, Pack Extensions and Update. From that, select the option "Load unpacked."

Step 6: Select the Extension Folder

Once the pop-up opens upon clicking Load unpacked, select the Google Sheets Link Auto Opener extension directory and click on the "Select Folder "button.

Step 7: Confirm and Install

After you select an extension folder of a Google Chrome extension you're installing manually, confirm its installation for the final time and let the installation complete.

Conclusion

Here we've made a step-by-step guide on How to manually install Google Sheets Link Auto Opener extension in 2 ways. We hope this guide proves helpful.

Similar Extensions

icon

Sheets Job Clipper Extension · Productivity 659 1 ★ 50.52KiB

icon

Drive Direct Download Extension · Productivity 659 17 ★ 11.36KiB

icon

Add to Sheets - Save to Google Sheets in 1 click Extension · Productivity 659 15 ★ 598KiB

icon

Hide Link Preview in Google Sheets Extension · Productivity 659 4 ★ 76.96KiB

icon

Easy Extensions Manager Extension · Productivity 659 3 ★ 151KiB

icon

matrixNote - notes in side panel Extension · Productivity 659 3 ★ 218KiB

icon

Document Preview Exporter for Google Drive Extension · Accessibility 659 51 ★ 283KiB

icon

Google Drive Downloader Extension · Productivity 659 2 ★ 211KiB

icon

Easy Grouping for Google Calendar Extension · Productivity 659 4 ★ 109KiB

icon

Sheets Helper Extension · Productivity 659 3 ★ 19.76KiB

icon

Download All PDFs Extension · Productivity 659 31 ★ 197KiB

icon

Stopwatch for Google Sheets Extension · Productivity 659 5 ★ 5.81KiB

icon

Sheets Genie Extension · Productivity 659 8 ★ 77.44KiB

icon

Udemy Business Linker Extension · Accessibility 659 0 ★ 84.34KiB

icon

Google sheet search Extension · Productivity 659 3 ★ 21.19KiB

icon

SheetKeys Extension · Productivity 659 13 ★ 47.39KiB

icon

Page Info Extension · Productivity 659 1 ★ 1.08MiB

icon

Copy & Download for Drive Extension · Productivity 659 0 ★ 22.6KiB

icon

Google Sheets ALT Keys and Trace Formulas Extension · Productivity 659 5 ★ 852KiB

icon

Meeting Dolphin Google Calendar Tags Extension · Productivity 659 5 ★ 179KiB

icon

Sheetgo | Connect, Filter, Merge, Excel, CSV Extension · Productivity 659 20 ★ 11.07KiB

icon

Drively Extension · Productivity 659 5 ★ 31.98KiB

icon

myReach Web Clipper Extension · Productivity 659 7 ★ 889KiB

icon

ChatGPT Sheets – Use ChatGPT for Sheets Extension · Productivity 659 23 ★ 2.09MiB