Guides / Topic

Small Business Stack

The handful of products a small company runs on, and the admin chores between them: contact lists, CRM imports, shared files and the inbox.

15 guides. Last updated . What's new

What small business stack covers

Most small companies run on a short list of software: Google Workspace or Microsoft 365 for email and files, a CRM such as HubSpot, a form tool, and a lot of spreadsheets. Nobody's job title says "systems", so the work of keeping these tools clean and connected is done in between other jobs.

That work is mostly moving data from one place to another. A trade show list goes into the CRM. Form replies need an answer. Invoices pile up in Drive with names like "scan_0034.pdf". Each move is a chance to create duplicates, lose a field or break a file.

Where it usually goes wrong

Imports create duplicates
The same person arrives as "Ann@Example.com " and "ann@example.com", and the CRM treats them as two contacts. Cleaning the list before the import is far easier than merging afterwards.
Exports break on commas
Notes with commas, quotes or line breaks split across columns when exported carelessly, and the file no longer opens properly.
Contacts nobody owns
Leads with no owner or no next step quietly go cold. A formula that lists them is the cheapest sales process there is.
Files with the same name
Shared folders collect copies of the same file, and deleting the wrong one is worse than leaving both.

How these guides help

The guides here use formulas and short scripts inside Google Sheets, Drive and Gmail to do these jobs carefully: check the data first, change nothing you did not ask to change, and leave a record of what happened. Each one starts with sample data so you can see the result before running it on your real list.

Every guide ends with a note on how it was checked. The formulas were evaluated against their sample data in HyperFormula, an independent spreadsheet engine. The HubSpot workflow and the Gmail searches were checked against the vendor documentation rather than run. The scripts were reviewed against the published API documentation but have not been run in a live account, and the note says so, so try them on a copy first.

The 15 guides

Contact lists and CSV imports

Get a messy list into a shape your CRM will accept without creating duplicates, and get notes back out without breaking the file.

Keeping the CRM honest

Find the contacts that have fallen through the gaps, from an exported sheet, and make HubSpot raise a task when a deal stops moving.

Shared Drive folders

See what is in a folder, find files anyone with the link can open, spot copies, and file invoices under useful names.

Inbox and form replies

Free up mailbox space, file newsletters out of the way, and get form submissions to the person who answers them.

Questions

Do I need HubSpot?

No. The import guide uses HubSpot's column names as its example, but the cleanup steps (trimmed, lower-case emails, one row per person, required columns filled) apply to any CRM that imports a CSV file.

Will these change my CRM or my files?

The formula guides work on an exported copy in a spreadsheet, so nothing in the CRM changes until you import. The two Drive audit guides and the duplicate-file guide only list files and change nothing. The invoice guide does rename files, so it has a dry run that shows every planned change first. The newsletter guide labels and archives mail, never deletes it, and starts in a mode that only counts. The HubSpot workflow guide creates tasks in HubSpot once you turn the workflow on.

Is my data sent anywhere?

Formulas and Apps Script run inside your own Google account. The free tools on this site run in your browser and do not upload what you paste.

Esc