Update VNTANA product attributes from scheduled Excel (.xlsx) attachments
Ready for 3.0What this workflow does
This workflow has 11 nodes and runs on a schedule (every 15 minutes). It uses only n8n's built-in nodes. It also calls api-platform.vntana.com over HTTP.
How it runs
Trigger: On a schedule (every 15 minutes).
- Merge Config and Trigger (Code): runs custom JavaScript code
- Post Auth to VNTANA (HTTP Request): calls api-platform.vntana.com (POST)
- Post Search Attachments (HTTP Request): calls api-platform.vntana.com (POST)
- Check Newest Attachment (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- Fetch Attachment File (HTTP Request): calls an HTTP API
- Parse Spreadsheet Data (Spreadsheet File): reads or writes a spreadsheet file (legacy node)
- Build Attribute Array (Code): runs custom JavaScript code
- Update Product Attributes (HTTP Request): calls api-platform.vntana.com (PUT)
- Configure Values (Code): runs custom JavaScript code
HTTP calls to: api-platform.vntana.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
- Still check Spreadsheet File (Parse Spreadsheet Data): Convert to File / Extract from File.
Nodes used (5)
- Code
n8n-nodes-base.code - Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Spreadsheet File
n8n-nodes-base.spreadsheetFile
From the author
Quick overview This workflow runs every 15 minutes, checks a VNTANA product for a new XLSX attachment with a defined filename prefix, reads attributekey and attributevalue rows from the spreadsheet, and replaces the product’s attributes in VNTANA with the…