ChatGPT 5 API to Google Sheets Using Apps Script ( In 15 minutes ) No add-ons скачать в хорошем качестве

ChatGPT 5 API to Google Sheets Using Apps Script ( In 15 minutes ) No add-ons

Thanks for watching! Here's the FREE code: https://automationforgrowth.com/?dl=10 Related links. https://platform.openai.com/docs/guid... Build a lightweight GPT-5 assistant inside Google Sheets—no add-ons needed. Set up a Config tab with dropdowns for model (GPT-5, mini, nano), reasoning effort, and verbosity, then write Apps Script to read settings, optionally pull context from cell ranges, and call OpenAI’s Responses API. You’ll see how to handle errors, swap models, and test both no-context and context-aware prompts with a simple custom function (GPT5(prompt, [contextRange])) that returns answers directly to cells. Perfect for quick analyses, templated prompts, and spreadsheet-native AI workflows. Timestamps 0:00 Test run and what the tool does 0:37 What we are building in Google Sheets 1:14 Verbosity and reasoning effort explained 2:16 Choosing models: GPT-5, mini, and nano 2:33 No-context vs context prompts in a sheet 3:21 Setting up the Config sheet 3:39 Add dropdowns for model, reasoning, verbosity 5:37 Open Apps Script and project layout 6:12 Config code: API key, sheet name, default system prompt 7:55 Load settings from the sheet 8:34 Build the API call with optional context range 9:32 Use the Responses API instead of Chat Completions 10:43 Send request with UrlFetchApp and handle errors 11:45 Test the custom function without context 12:57 Test with context pulled from cells 13:42 Tune verbosity and model for different outputs 14:15 Wrap up and next steps