octopart-google-app | Octopart Google App

This add-on was officially available at the Google Docs Add-on Store here, but it is currently blocked due to lacking OAuth verification (see this and this issue). That being said, it still works (as of October 2021) and it isn't hard to install manually using the files available here and the following steps:.
From Google Sheets, select the Tools menu > Script Editor. It will open an untitled project. Rename it to "Octopart Google App" (or whatever you want).
When the script editor creates a new project, it also creates the file Code.gs by default. Rename it to functions to match the first *.gs file in this project (the .gs extension will be added automatically, so don't type it). From the code view of this project click on functions.gs then on the button to "Copy raw contents". Paste those contents into the script editor.
In the script editor add a new script file named octopart and copy the raw contents of octopart.gs from GitHub into it.
Repeat for ui.gs.
Add sidebar.html in a similar way, but tell the script editor it is an HTML file rather than a script file.
Press CTRL-S to tell the script editor to save the project.