Automation & E-commerce
Articles about automation & e-commerce, practical decisions, tools and systems.

Google Sheets two-column sort: verify complete records
Google Sheets two-column sort uses two ordered keys. Sort six practice records, check every ID and its fields, then reopen the sheet and the saved check card.
Read article
Google Forms paragraph character limit: set and check it
Set a Google Forms paragraph character limit and record a clear boundary check. Use fictional 20- and 21-character inputs with a saved, reusable test worksheet.
Read article
Copy an earlier Google Docs version without restoring
Copy an earlier Google Docs version into a separate file. Keep the working document current and use a worksheet to check both links and the text you observe.
Read article
Google Sheets filter views: save a personal work queue
Use Google Sheets filter views to save a focused work queue. Follow a five-row exercise, reopen the named view, and separate view links from file access rights.
Read article
Gmail filters: label supplier emails without hiding them
Build Gmail filters that label incoming supplier messages. Check matching and nonmatching examples, keep mail visible, and record what remains untested today.
Read article
Protect formula cells in Google Sheets: an edit test
Protect formula cells in Google Sheets while keeping inputs editable. Compare warnings with restricted editors and record an honest separate-account test.
Read article
Repeat Excel print headers: a worksheet checking guide
Repeat Excel print headers with a fixed title-row setting. Prepare a fictional list, inspect available preview pages, and save a workbook plus checking note.
Read article
Excel drop-down list: build an order-status entry check
Build an Excel drop-down list for ten fictional orders. Configure the source and Stop alert, then record entry checks separately from untested paste behaviour.
Read article
Gmail Bcc recipient visibility: check who sees each address
Check Gmail Bcc recipient visibility with a three-address matrix. Review To, Cc, hidden copies and reply audiences before sharing a real business message.
Read article
Gmail Undo Send: set the cancellation window and check it
Set the Gmail Undo Send cancellation window, verify the saved setting and prepare a harmless rehearsal. Use a clear correction template when time has passed.
Read article
PDF redaction: save a copy and check what remains
PDF redaction needs more than a black box. Use invented markers to check a saved copy, inspect hidden content and record what remains before sharing the file.
Read article
OCR PDF check: compare scanned fields with copied text
Run an OCR PDF check before using scanned data. Compare three fields, save a clear correction record and flag unreadable values without guessing their meaning.
Read article