Google Sheets
Google Sheets as a real operations tool: formulas, Apps Script and the automations that replace a spreadsheet someone updates by hand.
- Turn a Google Sheet Into a Website: 3 Routes and Their Limits Three ways to publish a Google Sheet as a website: a published sheet, an Apps Script web app, or a static generator. Limits for each, and…
- Track YouTube Views Daily in Google Sheets With Apps Script An Apps Script that logs YouTube view counts to a sheet every day with videos.list, what it costs in quota units, and why the Data API…
- YouTube Playlist to Google Sheets: Titles and Links in One Run Read any YouTube playlist into Google Sheets with Apps Script: 50 videos per call, 1 quota unit each, so 1,000 videos cost 20 units. Script and…
- IMPORTHTML vs IMPORTXML vs Apps Script: Which to Use in Sheets Pick IMPORTHTML for tables, IMPORTXML for any element, and Apps Script when you need control. Includes the published fetch quotas and one working script.
- YouTube Analytics API vs Data API: Which to Use for Sheets The Data API reads public video stats with a key. The Analytics API reads your channel reports with OAuth. Quotas, scopes, and a tested Sheets script.
- Export YouTube Comments to Google Sheets With Apps Script Each commentThreads.list call returns up to 100 comment threads for 1 quota unit. Here is the Apps Script loop, the disabled-comments error and the cost.
- IMPORTXML Not Working in Google Sheets: Find the Cause in 5 Steps IMPORTXML fails when Sheets cannot reach the data you see in the browser. Test the fetch, check the raw HTML with curl, then fix the XPath…
- Send the Same Email to Multiple Recipients Separately in Gmail Bcc sends one message. To send the same email to each person separately you need mail merge or a script. Daily limits for each route, and…
- YouTube Data API Quota: 10,000 Units and 100 Searches a Day The default is 10,000 units a day, and search.list has its own bucket of 100 calls. Here is what each call costs and how a Sheets…
- Get Data From a Website Into Google Sheets: Which Method Fits IMPORTHTML, IMPORTXML, IMPORTDATA, IMPORTFEED or Apps Script: a table that matches each to a page type, plus the quota limits that decide when to use a…