Custom GPT and Google Sheets walkthrough (2024 video)

Before you watch

Important: This video was recorded in 2024 and shows an older, less restricted workflow. Do not follow its arbitrary cell-address setup or old deployment URL configuration. Use the updated written guide below as the source of truth.

Follow the current Custom GPT and Google Sheets guide.

What the updated guide changes

• The Apps Script accepts only fixed logical keys from a server-side allowlist.
• The GPT Action schema uses only the Apps Script deployment ID, so /exec appears once.
• The example exposes one non-sensitive, read-only display value rather than arbitrary cells.
• The public, unauthenticated setup is clearly limited to demo or genuinely public data.
• Private or user-specific data requires a separately hosted API with API-key or OAuth authentication.

Data timing and access

Custom GPT creation requires a paid ChatGPT account or permission in a managed workspace, and GPTs are built in ChatGPT on the web. Google notes that GOOGLEFINANCE quotes may be delayed, so the example returns the latest value displayed by the sheet rather than an instant market price.

Safer downloads

The current article includes the matching Apps Script and OpenAPI files, each with its own public/no-auth warning. Download them from the updated written guide.

The video is still useful as a visual overview of the editor and deployment flow. Use the written guide for every code, URL and security decision.