How to automate BambooHR pension-report CSVs after payroll
BambooHR pension report automation: generate compliant CSVs right after payroll, validate required fields, and deliver the files securely over SFTP.
Zoho Forms vendor uploads to OneDrive: avoid duplicate folders
Set up a Zoho Forms vendor document upload automation that sends every submission to the right OneDrive folder, with no duplicate vendor folders.
TABLE OF CONTENTS
A reliable Zoho Forms vendor document upload automation sends every submission to the same OneDrive vendor folder. Use a stable vendor key (like company name), look up the folder by that key, and only create the folder when it doesn’t already exist. Vendors can then submit as many times as they need without leaving you with duplicate folders.
Why “edit submission” breaks the automation
Zoho Forms lets vendors edit a prior submission, but Zapier’s Zoho Forms trigger is “New Form Entry,” which fires on new submissions, not edits (as of October 2026 — check current triggers). The result: when a vendor edits an entry to add files, your Zap never fires, so the new files never reach OneDrive.
Fix: don’t rely on “edit response” for follow-up uploads. Instead, have vendors submit the form again when they have additional documents.
The reliable upload automation pattern: vendor key → folder lookup → file upload
This workflow is designed for vendors who may upload 0–4+ documents now, then come back later.
Step 1: Choose a stable “vendor key”
Pick one field that the vendor will enter the same way every time. Common options:
- Company name (works if it’s enforced/validated)
- Vendor ID (best, if your vendor list already has IDs)
- Email domain (only works in some cases)
Tip: If you use company name, add a short helper line on the form that says: “Use the exact same company name every time you upload additional documents.”
Step 2: Build the workflow in Zapier
Build the automation in Zapier with this high-level flow:
- Trigger: New Zoho Forms submission
- Find the vendor folder in OneDrive by name or stored ID (Zapier’s OneDrive “Find Folder” action)
- If folder not found: create vendor folder under the parent event folder
- For each possible upload field:
- If a file exists: upload it into the vendor’s folder
- If no file exists: skip (avoid “missing file” errors)
Step 3: OneDrive folder strategy (avoid duplicates)
Inside your event’s parent folder (example: “2027 Vendors”), create one folder per vendor:
2027 Vendors/<Vendor Key>/
In Zapier, always target the same path:
- Use the folder found result when it exists
- Use the folder created result when it didn’t exist
This avoids the classic “new folder every time” failure mode.
Handling multiple upload boxes (and optional documents)
If your Zoho Form has 4 upload fields (route map, booth design, insurance certificate, health certificate), don’t assume all 4 will be present.
For each upload box:
- Add a conditional check (file exists?)
- Then download → upload to OneDrive
- Use a consistent destination filename pattern so it’s easy to spot replacements
Example filename pattern:
Certificate of Insurance - <Vendor Key> - <YYYY-MM-DD>.<ext>
Testing plan (run it before your upload deadline)
Run these tests in order so you don’t ship a fragile automation:
- New vendor, no files
- Submit the form with the vendor key, leave uploads empty
- Expected: folder is created, no upload steps error out
- Same vendor, new submission, 1 file
- Submit again with the exact same vendor key and one file
- Expected: no new folder; file lands in the existing folder
- Same vendor, new submission, multiple files
- Submit again with 2–4 files
- Expected: each file lands in the existing folder; missing fields are skipped
- Vendor key mismatch
- Submit with a slightly different company name (extra space, “Inc.” vs none)
- Expected: you get a duplicate folder (this proves why key discipline matters)
Triage tips when you’re under a deadline
When a document deadline is close and vendors are uploading late:
- Turn off “edit your response” links so vendors don’t edit (edits don’t fire Zapier’s New Form Entry trigger).
- Put a short note in the vendor email: “To upload missing documents, submit the form again using the exact same company name.”
- Keep a simple audit log (even a spreadsheet) of vendor key → folder link for quick support.
When Zoho Forms “edit response” is non-negotiable
If you must support edits and need automation to run on them, you’ll need something other than a Zap that triggers on new submissions. Common alternatives:
- A scheduled polling job that checks for updated submissions
- A middleware service that can read submission updates and emit a webhook
- A second “Upload missing documents” form that only collects the vendor key + file uploads
(Those options are more complex, but they remove the dependency on Zoho’s edit behavior.)
Get help building this
If you want vendors to upload documents in multiple rounds without duplicate folders, we can build and test this Zoho Forms to OneDrive workflow with you, including the vendor key rules and the edge cases above. Book a free call with a Connex automation expert.
Related Posts
Fix QuickBooks Duplicate Customers by Email Domain
Fix QuickBooks duplicate customer email domain issues with Zapier Formatter and API-based lookup. Reduce duplicate records, failed receipts, and manual cleanup.
Automate monthly Salesforce exports from S3 + Google Sheets
Automate monthly Salesforce exports from S3 + Google Sheets: pull daily files from S3, calculate member status in Sheets, and generate a weekly CSV in Drive.
