INDUSTRIAL PC CATALOG

Updated: November 2025 | For pricing and availability, contact: 1-800-555-0100

🔑 Google Sheets API Setup (One-Time)

  1. Get your Sheet ID: From your URL
    https://docs.google.com/spreadsheets/d/SHEET_ID_HERE/edit
    Your Sheet ID: 1vR5htR8Okbhvz-I00Z5TTTNKXahc4a0AbGffHSWaI6UqAq4KO5QRZQCK_fByZTMLg
  2. Make sheet public: Click "Share" → "Anyone with the link" → Viewer
  3. 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
  4. Configure below: Replace SHEET_ID and API_KEY in the script (lines ~280-281)
  5. 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.