Data Storage
LightLead uses a hybrid storage model: report data lives in your Google Sheet, while metadata and tokens live in secure cloud storage.
What's stored in the Google Sheet
All report data is written directly to your Google Sheet:
- Each report occupies a separate sheet (or several sheets)
- Data is stored as rows and columns
- You can freely edit, copy, and delete this data
The [LL] service sheet contains:
- Workspace ID
- List of integrations (without tokens)
- List of reports and their statuses
- Workspace settings (time zone, currency)
What is NOT stored in the Google Sheet
- Access tokens (OAuth tokens for ad accounts and CRMs)
- Secrets (API keys, application secrets)
- Request history (technical logs)
Tokens and secrets are stored encrypted in LightLead's cloud storage (Google Cloud) and never end up in the Google Sheet.
Security
- Tokens are encrypted (AES-256)
- Access to tokens is only available through LightLead's backend
- No team member can see another member's tokens
- When an integration is deleted, its token is deleted immediately
Retention period
- Report data: until you delete the sheet in the Google Sheet
- Configuration metadata: for as long as the workspace exists
- Tokens: while the integration is active (plus 30 days after disconnection to allow for recovery)
Backups
LightLead does not back up your data in the Google Sheet. You can:
- Use Google Sheets' built-in versioning (File → Version history)
- Copy data to separate sheets or a different spreadsheet
- Use Google Apps Script to automate backups