Welcome to LexiSheet "Early Access"

You're in. Because you're an early access member, you get to bypass the Google Marketplace review and install LexiSheet right now.

This is a simple 2-minute setup.

Section 1: Your Access Keys

You'll need these two keys for the final step. Keep this page open.

Your API URL:
https://script.google.com/macros/s/AKfycbxuKUNoqMO9PhSPtR-WcDn08lDanQTupt7rA8eLJaF9nWjx8Ru9lky6xPkQL6JhunnmFA/exec

Your API Key:
EfIVb3RjWQwYS7EUQqXENPK1GFNzru7U

Section 2: 2-Minute Setup Instructions

1. Open any Google Sheet (or create a new one at sheets.new).

2. At the top, click Extensions > Apps Script. A new tab will open.

3. In the Code.gs file, delete all the text inside.

4. Copy the code from Code Block A (below) and paste it into the empty Code.gs file.

   • [Click here to get the Code.gs code]

5. In the Files list on the left, click the + icon and select HTML.

6. Name the new file Sidebar (it must be exact, case-sensitive) and press Enter.

7. Delete all the text in your new Sidebar.html file.

8. Copy the code from Code Block B (below) and paste it into the empty Sidebar.html file.

   • [Click here to get the Sidebar.html code]

9. Click the "Save project" icon (looks like a floppy disk).

10. Go back to your Google Sheet tab and reload the entire browser page.

11. You will see a new LexiSheet menu at the top. Click it.

12. Select Setup / Add API Key.

Section 3: One-Time Authorization

Google will now ask you to authorize the script you just pasted. This is a standard, one-time security step because you are the one adding the code to your sheet, not us. Google is just asking you to trust yourself.

1. A pop-up will appear. Click Authorize Access or Continue.

2. Choose your Google account.

3. You will likely see a "Google hasn't verified this app" screen. This is normal and expected.

4. Click Advanced (on the left).

5. Click Go to [Project Name] (unsafe).

6. Click Allow.

Section 4: Final Step (Your Keys)

After authorizing, the setup prompt will appear.

1. The first pop-up will ask for the "API URL". Copy and paste it from below:

   • https://script.google.com/macros/s/AKfycbxuKUNoqMO9PhSPtR-WcDn08lDanQTupt7rA8eLJaF9nWjx8Ru9lky6xPkQL6JhunnmFA/exec
     

2. The second pop-up will ask for the "API Key". Copy and paste it from below:

   • EfIVb3RjWQwYS7EUQqXENPK1GFNzru7U

You're done! The LexiSheet assistant is now active and ready to use.