Only run the job on the rows you selected
Your nightly job handles everything. Then someone asks: “Can I just re-send these three?” The honest answer is usually “change Status back…
7 posts tagged with “custom-menu”
One-click approve / reject for a row your ops team will actually use
Approvals in a spreadsheet usually look like this: someone types “ok” in column H, someone else types “approved!!” in column J, and nobody’s…
Build a tiny HtmlService sidebar your teammates will actually click
Non-technical teammates will not open Apps Script. They will click a menu item that opens a sidebar with one obvious button and a status…
Get Visible Row Objects
Ops filter the sheet to “Status = Ready, Region = East” and click your menu item. They expect it to act on what they can see. getValues…
Get Selected Row Objects
getActiveRowAsObject is perfect for one row. Ops rarely stop at one. getSelectedRowObjects(sheet, headerRow) returns a header-keyed object…
Create a Custom Menu Option
The onOpen trigger is mainly used to add in additional menu options that can help you execute scripts without having to open up your Script…
AUTOMATE Your Google Search Console Data Pulls
Automating your Google Search Console data imports into Google Sheets has NEVER been easier with this customized Sidebar UI that lets ANYONE…