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.
- Clean a Contact Spreadsheet for a HubSpot CSV ImportPrepare a HubSpot contact CSV in Google Sheets by cleaning emails, checking duplicates, and mapping four contact fields before import.HubSpot, formula, added
- Normalize CRM Email Addresses Before a CSV ImportWhat normalizing email addresses means, why it stops duplicate contacts in your CRM, and a Google Sheets formula that does it, step by step.Google Sheets, formula, updated
- Export CRM Notes to CSV Without Breaking Commas or Line BreaksExport displayed Google Sheets values as UTF-8 CSV, preserving commas, quotes, and note line breaks for importers that support quoted multiline fields.Google Sheets, script, added
- Find Duplicate Companies by Domain Before a HubSpot ImportExtract a clean domain from a website column in Google Sheets and flag repeated domains with COUNTIF before importing companies into HubSpot.HubSpot, formula, added
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.
- Find Open CRM Contacts with No Recent Follow-UpFlag Google Sheets CRM contacts with no last-contact date or more than 14 days of silence, while excluding Closed contacts.Google Sheets, formula, added
- Flag CRM Contacts Missing an Owner or Next StepFlag CRM contacts missing an owner or next step with a Google Sheets formula, then filter the status column to find records needing follow-up.Google Sheets, formula, added
- Create a Follow-Up Task When a HubSpot Deal Sits in One Stage Too LongA deal-based HubSpot workflow template that creates a follow-up task for the deal owner once a deal has stayed in its current stage for a set number of days.HubSpot, template, added
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.
- List Every File in a Google Drive Folder to a Sheet with Apps ScriptUse Apps Script to walk a Drive folder and its subfolders, then write each file's name, path, type, owner, date, size and URL to a new Sheets tab.Google Drive, script, added
- Find Files Shared with Anyone with the Link in Google DriveRun a report-only Apps Script that lists files in a Drive folder tree whose link sharing is set to Anyone, so you can review them in a sheet.Google Drive, script, added
- Find Same-Name Files in a Google Drive Folder Without Deleting AnythingScan one Drive folder for exact repeated filenames and write each file's ID and URL to a new Sheets tab without altering source files.Google Drive, script, added
- Rename Invoice PDFs in Google Drive from a Tracking SheetUse a tracking sheet to check invoice PDF IDs and approved names, review a dry-run log, then enable the script to rename files.Google Sheets, script, added
Inbox and form replies
Free up mailbox space, file newsletters out of the way, and get form submissions to the person who answers them.
- Find Large Attachments and Old Mail with Gmail Search OperatorsUse Gmail search operators such as larger:, has:attachment, older_than: and filename: to find the mail that fills your storage, then review it before deleting.Gmail, query, added
- Label and Archive Old Newsletters in Gmail with Apps ScriptAn Apps Script that finds Gmail promotions older than 30 days, labels them and archives them in batches of 100, with a dry run that only counts and a daily trigger.Gmail, script, added
- Create Gmail Reply Drafts from Google Forms ResponsesCreate plain-text Gmail drafts from Google Forms with Apps Script, record draft IDs in Sheets, and check each message yourself before sending.Gmail, script, added
- Send New Google Form Responses to a Slack ChannelUse Apps Script and an installable form-submit trigger to post each new Google Form response to a Slack channel through an incoming webhook.Slack, script, added
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.