Editing Openai/688406d1-62a4-8012-949f-ac50d0247df3 (section)

===== 1  Where to locate & edit the constants =====
# Open the bound Apps Script project - In your Google Sheet choose Extensions → Apps Script (this opens the online code editor at script.google.com).
# Find the constant block - In the default Code.gs file you’ll see a comment header /** ========= CONFIG ========= */ Immediately below it are the five constants you must change: ``<code>javascript const PUBLISHED_URL  = '<PUBLISHED_SHEET_WIDGET_URL>'; const FOLDER_ID      = '<TARGET_DRIVE_FOLDER_ID>'; const PNG_NAME       = 'sheet_widget.png'; const PROP_KEY       = 'PNG_FILE_ID'; const SCREENSHOT_API = 'https://image.thum.io/get/'; const SCREENSHOT_API_KEY = '<YOUR_SCREENSHOT_SERVICE_KEY>'; </code>`<code>
# What to paste into each placeholder | Constant           | Where to get the value                                                                                                                                             | | ------------------ | ------------------------------------------------------------------------------------------------------------------------ | | PUBLISHED_URL      | In the Sheet: File → Share → Publish to web. Choose the specific tab and click Publish. Copy the URL that appears and paste it (keep the single quotes).           | | FOLDER_ID          | Create or pick a Drive folder → open it → copy the long ID from the URL (the string after folders/). Example: https://drive.google.com/drive/folders/'''1A2B3C...''' | | PNG_NAME           | Leave as‑is unless you want a different filename.                                                                                                                  | | PROP_KEY           | Leave as‑is (it’s just an internal reference).                                                                                                                     | | SCREENSHOT_API     | Leave default for Thum.io, or replace with ScreenshotAPI’s base endpoint if you use that service.                                                                  | | SCREENSHOT_API_KEY | Paste your Thum.io or ScreenshotAPI key (between quotes) or leave blank if the service doesn’t require authentication.                                             |