Solutions · Capture
Import data into Salesforce safely, and know which documents are missing
Capture is where records and files first enter your org, and where much of the bad data starts. Two apps cover it: one checks a file before it saves, the other shows what a record is still missing.
The job, and why it hurts
A sales ops lead forwards a spreadsheet on Thursday and wants it in Salesforce by Monday. Nobody has opened it properly. It might be clean. It might have two date formats, free text where a picklist should be, and a few hundred rows that update records nobody meant to touch.
Documents have the same problem in a different coat. A contract, a certificate and an invoice arrive as attachments with names like final_v3. They’re in Salesforce, technically. Whether the right file sits on the right record, or has quietly expired, depends on someone opening them one at a time.
Both are problems at the front door. Things get in quickly, nothing says what they are, and the damage shows up weeks later in a report or an audit. A loader trusts the file. A Files list trusts whoever uploaded it. Neither tells you whether the content is right or what’s missing.
The apps for this job
Where things stand. Both apps are in early access with design partners. Neither is on AppExchange yet.
Portage: check every row before anything saves
Portage, by GTM Cloud, imports CSV and Excel files through a four-step wizard inside Salesforce. Every row is validated against your live field rules first, and for updates you see the old and new value side by side. An admin builds the template, the business runs the wizard, and approval is optional. See how Portage validates a file.
Stow: see which documents are in, missing or expiring
Stow, by GTM Cloud, adds an upload area to a record page. People pick a category as they drop a file, and admins mark categories required and set expiry reminders, so the record shows a checklist. Optional Document Reading can read an invoice or a form into fields for a person to check, and it needs Einstein generative AI (Prompt Builder) turned on. See Stow’s required documents checklist.
How they hand off to each other
Load the records first, then collect the paperwork that belongs on them.
- Portage loads the accounts, contacts or contracts, with every row checked.
- Stow puts the documents on those records, categorized, with a checklist of what’s still missing.
Each installs alone and works without the other. If your problem is documents, install Stow and leave the loader out of it. A big load can leave duplicates behind, and that belongs to the Clean stage.
See it first. Take it back. Keep the receipt.
Portage puts the check before the save, and keeps approvals and a job history after it. Stow shows values read from a document beside it before anyone commits them, and a committed reading can be undone from Reading History. The same promise runs through every app: see it first, take it back, keep the receipt.
When a person should help
Planning a migration, or a one-off load bigger than a wizard should carry? Our Salesforce services include data migration, and we’ll tell you if something you already own will do the job.
Questions people ask
How do I import data into Salesforce safely?
Check before you save. Validate each row against the field’s required setting, type, picklist values and length. For updates, compare the current value with the incoming one. For a big load, get a second person to sign off, and keep the source file and the approval so the load can be explained later.
Why do imports overwrite the wrong data?
Usually a column was mapped to the wrong field, or the file matched records on a key that wasn’t as unique as it looked. Both show up before the save if you compare current and incoming values for the changed fields. After the save, they become a cleanup project.
Can business users run their own imports?
They can, inside a template an admin builds from the object’s live fields. In Portage, users can write only the fields the template includes, every row must pass validation, and you can require approval and a minimum share of passing rows before an import is allowed to run.
How do I make a document required on a Salesforce record?
Mark its category as required for the records it applies to. In Stow, anyone who opens the record then sees a checklist of what’s provided and what’s missing. Each category can carry its own expiry reminder, so a certificate and an invoice can follow different schedules.
What do I do with the rows that fail?
Take out only the failed rows, fix them in the file, and load them again. Portage lets you export the failures, read each error in plain words, and load the corrected rows back into the same job, so you don’t start over.
Tell us what’s waiting in your inbox
Book a Data Health Check and find out what state your data is in before the next big file lands.