We need a way for regular app users to upload an Excel/CSV file through a File field and have a Noloco workflow automatically process the full file.
Our use case is daily operational and compliance reporting. A user uploads a report containing 1,000+ rows, and we need the workflow to:
- Read all rows from the uploaded file
- Map selected columns to fields in a Noloco table
- Create/update records from those rows
- Allow additional workflow steps to run on the imported records
- Mark the original upload as Processed or Failed
Currently, Data Import requires admin involvement, which makes it difficult to use as part of a daily operational process. We also don’t want regular users to need access to the Data section or manually import the same file after uploading it.
Ideally, there would be a workflow action such as “Import/Process File”, where we select the File field, destination table, column mappings, and whether records should be created or updated.
This would allow the entire experience to remain inside the Noloco app:
User uploads report → Save → Workflow processes file → Records are created/updated automatically.
This would be especially useful for recurring financial, compliance, inventory, transaction, and operational reports.