First Launch
When you first launch LightLead, it creates a workspace and links it to your Google Sheet. Here's what to expect.
Prerequisites
Make sure LightLead is installed and you're signed in. If you haven't done this yet, read Installing LightLead.
Step 1: Create a workspace
- Open Extensions → LightLead → Open
- On the welcome screen, click Create Workspace
- LightLead verifies that the current sheet isn't already linked to another workspace
Step 2: Configure settings
After creation, the settings screen opens:
- Timezone — select your timezone (important for daily-refreshing reports)
- Default currency — choose the currency for financial data (USD, EUR, RUB, and others)
Step 3: Verify the link
LightLead creates a special service sheet [LL] in your spreadsheet. Do not delete or edit this sheet — it's required for the add-on to work.
How to verify
- A
[LL]sheet should appear in your Google Sheet - Opening LightLead should show the main screen with the menu: Reports / Integrations / Attribution / Telegram / Team / Subscription / Settings
- Your email and workspace name appear in the top-right corner
Common Issues
Workspace won't create
- Make sure the sheet isn't already linked to another LightLead workspace
- Check that you have edit permissions on the spreadsheet
- Try creating a new spreadsheet and launching LightLead there
The [LL] sheet disappeared
If you accidentally deleted the [LL] service sheet:
- Don't close the spreadsheet
- Open LightLead — it should try to restore the sheet automatically
- If it doesn't restore, contact support