Quick Access To FAQs Stored In Google Sheets

View FAQ from a Google Sheet in sidebar

by @pixies

Activate

How to Use

Use the Quick Bar to search a list of FAQs you define in a Google Sheet. You can add, modify, and delete FAQs in the Google Sheet, and it will automatically update what you see in the PixieBrix sidebar.

Requirements

Google Sheet: You will need a Google Sheet with some FAQs to start. You must follow the format below, with the word "Question" in column A, the actual question in column B, and the answer in column C. Make sure the tab name is FAQs.

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.


PixieBrix mod configuration screen

  1. 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 FAQ.
    PixieBrix Quick Bar menu

  2. Voila 🎉 PixieBrix returns your FAQs in the sidebar
    Sidebar panel with questions and arrows that show answers


Use Case Ideas


👤 HR and Recruiting

You get asked more questions than most! This mod helps surface info that you need to provide frequently. Customize the text in your Google Sheet to quick access info, such as:

  • Benefit policies
  • Company holidays
  • Current job openings


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.


Related Tags