Smart Bookmarks By URL Stored In Google Sheets

by @pixies

Activate

Displays links related to the page you're on, taken from a Google sheet


How to Use

Use the Quick Bar to pull up a list of links in the Sidebar, which you define in a Google Sheet. You can add as many links as you want and set each link to appear on a specific host page or every page.

Requirements

Google Sheet: To start, create a Google Sheet with three columns to define which links appear on which pages in the sidebar. Your sheet must have the following column headers:

  • Host (define a host page like "www.pixiebrix.com" or write "everywhere")
  • Type (the link or button caption)
  • URL (the link)

Here's an Example Google Sheet with the correct format

Google sheet

Quick Bar: You must set up the Quick Bar if you have not done so. To do this, follow the Quick Bar setup documentation.


Activate the Mod

  1. Activate this mod. If you're not logged into PixieBrix or have not previously created a PixieBrix account, you'll be prompted to do so before continuing the activation flow for this mod.

  2. Once you are logged in, use the PixieBrix Extension Console to configure the Google Sheets integration by selecting the Google Sheet you created in Requirements and adding the correct tab name

    PixieBrix mod configurationg

  3. Finish activating this mod by clicking "Activate" in the Extension Console.


Try it Out

  1. On any webpage, activate the Quick Bar using the keyboard shortcut you configured in the Quick Bar setup documentation. Choose "Related Links"

    PixieBrix quick bar shortcut with command options

  2. Voila! 🎉 PixieBrix returns your Related Links in the sidebar. Click one to go to the link.

    sidebar panel with links listed


Use Case Ideas


👤 HR and Recruiting

How many links do you have to access each day? (You're probably thinking, "Too many to count".) Make relevant links appear when needed instead of digging through your bookmarks. Great for:

  • Benefits wiki page
  • Company helpdesk
  • Current jobs page
  • Greenhouse links


Endless Possibilities

This is just the beginning! Once you activate your mod, the possibilities are endless. With PixieBrix, you can customize any mod to meet your needs or even build something entirely new. If you run into any trouble, need friendly support, or want to share your creations with the world, join our PixieBrix Slack Community.


@pixies/misc/related-links-google-sheet

Version

1.0.5

Created

Feb. 14, 2023

Updated

March 15, 2023