Share 1 Cell to API

Turn a Single Google Sheets Cell into an API with Apps Script (Web App doGet) This episode shows how to expose one specific Google Sheets cell value as a URL-accessible API without sharing the full spreadsheet. You’ll create an Apps Script project, add a required doGet(e) function, read a single cell from a named sheet using SpreadsheetApp.getActiveSpreadsheet().getSheetByName("2027 sales").getRange("B1").getValue(), and return it via ContentService.createTextOutput(cellValue). It covers deploying the script as a Web App (execute as you, access: anyone), authorizing access, copying the Web App URL, and testing in an incognito window to confirm the URL returns only the number and updates automatically when the sheet changes. It also explains updating code using Managed deployments to keep the same URL versus creating a new deployment that generates a new URL. 00:00 Goal One Cell API 00:38 Open Apps Script 00:56 Write DoGet Function 01:26 Select Sheet Range 01:57 Programmatic Range Options 02:54 Return Cell Value 03:26 Deploy Web App 04:10 Authorize And Copy URL 04:39 Fix Text Output 04:52 Managed Deployments 05:46 Test Live Updates 06:08 Use Cases Wrap Up 06:35 Outro Subscribe