Google Sheets Add-On

Set-up

Set-up
  • On your Google sheet, go to the menu bar, choose Extensions and then select Apps Script.

Excel search

  • A new tab will open with the script editor.

  • Make sure you are on Code.gs file editor. Delete any content that may have on editor, then copy the content of our Code.gs , paste in the editor and save it.

Excel search

  • Click the + icon and choose the option HTML.

Excel search

  • A small input will appear bellow Code.gs to you name a new file. Name it index.

Excel search

  • Delete any content that may have on index editor, then copy the content of our index.html , paste in the editor and save it.

Excel search

Activate

Activate
  • Refresh your spreadsheet.
  • Look for a new menu called TE next to Help, it can take some seconds to appear on the Google Sheet
  • Click on TE then select Get Data to start using the Add-On

Excel search

Note

Note

1 - The first time you use the Add-On, a warning might appear stating “This app isn’t verified.”

  • Click on “Advanced”
  • Click on “Go to … (unsafe)” to continue using our Add-On.

2 - Ensure your spreadsheet has enough rows (10,000+) before making a request.

  • If you need more rows, scroll to the bottom and click “Add” to add more rows.