🔑 Google Sheets API Setup (One-Time)
- Get your Sheet ID: From your URL
https://docs.google.com/spreadsheets/d/SHEET_ID_HERE/edit
Your Sheet ID: 1vR5htR8Okbhvz-I00Z5TTTNKXahc4a0AbGffHSWaI6UqAq4KO5QRZQCK_fByZTMLg
- Make sheet public: Click "Share" → "Anyone with the link" → Viewer
- Get API Key (Free):
- Go to Google Cloud Console
- Create a project (or use existing)
- Click "Create Credentials" → "API Key"
- Copy the key
- Enable "Google Sheets API" in the API Library
- Configure below: Replace
SHEET_ID and API_KEY in the script (lines ~280-281)
- Optional columns in your sheet:
ProductURL - Makes the product name clickable
DatasheetURL - Adds a datasheet link button
Note: The API key is free and allows you to make requests directly from the browser without CORS issues.
Loading catalog data...