File storage
Introduction
The File Storage feature in BeeXcel allows the platform to connect to external storage systems such as an SFTP server or Google Cloud Storage. It enables automated import and export of Excel files into predefined directories. These operations run in the background without manual intervention, ensuring a continuous data processing flow.
🎯 Objective
To automate the import and export of Excel files between BeeXcel and remote storage systems, eliminating manual handling, securing transfers, and streamlining product data enrichment workflows.
✅ Key benefits
- Fully automated file transfers (import/export).
- Time-saving for teams: no manual upload or download required.
- Reduced human error from file handling.
- Seamless integration with existing technical infrastructure (SFTP, Google Cloud Storage).
- Secure file transfers using encrypted protocols.
- Clear organization through structured directory management within the storage system.
🧩 Example use case
A data team receives a daily Excel file automatically generated by a supplier ERP and deposited on an SFTP. BeeXcel fetches this file at a scheduled time (e.g., every morning at 6 AM), places it into a specific folder (/raw/input/morning_catalog) in its internal storage, and then triggers a parsing and enrichment process. Once processed, the enriched file is automatically saved in an /output/daily_processed folder, ready to be reused or injected into a PIM system.
⚙️ Configuration
Configure where BeeXcel should retrieve the file to process and, optionally, where to re-upload the enriched result.
| Field | Description |
|---|---|
| Type | Select the type of storage used: • GCP (Google Cloud Storage)• SFTP (Secure FTP server) |
| File path | Enter the full path to the file: • For GCP: bucket-name/folder/file.xlsx• For SFTP: /remote/path/to/file.csv |
| Upload file after enrichment? | Toggle this option if you want BeeXcel to upload the enriched file back to the same location after processing. |
| Test Connection | Click to verify that BeeXcel can access the selected path with current credentials. |
🔐 Required authentication settings:
- For GCP (Google Cloud Storage):
Bucket nameProject IDCredentials: Upload your Service Account JSON key
- For SFTP:
HostPortAuthentication mode: Choose between:Username + PasswordUsername + Private Key
⏰ Scheduling
Use this section to schedule automatic execution of your pattern.
| Field | Description |
|---|---|
| Schedule execution | Choose a predefined frequency (e.g. hourly, daily) or define a custom CRON expression. |
ℹ️ The pattern will be executed automatically according to the selected schedule. Manual execution remains possible at any time via the Upload and Execute button.