How would you approach this? The scenario I am looking at is:
- a user creates/makes some changes to a Google Docs Spreadsheet (in a format quite similar to the one needed by Magento)
- a script takes this Spreadsheet and performs a validation (columns are valid, attribute values are valid, sku exist and so on)
- if the Spreadsheet is valid for import, additional processing takes place to make it compatible with Magento's Import format (not DataFlow); Magento's import format for attributes with multiple values is not that friendly from a user perspective
- then this Spreadsheet can be imported in Magento.
Are there some extensions that already do this? Other people that have done this, share your experience. Additional things to consider?