Hello! We sell on Amazon (primarily Fulfilled By Merchant or FBM) and we are looking to create an SOP to handle returns.
We would like to create a new google sheets row when a return notification arrives.
We get a notification via email that a return authorization has been initiated, and it is also created under the order in Seller Central.
Most of the information is contained in the email (Customer order number, name, item, etc). Would it be best to
- Parse the information from the email (Gmail) to the Google Sheet Row, or
- Connect in to Seller Central Returns Report, and transfer the info from there to the Google Sheet (not seeing an easy way to do this), or
- Create a seperate API to retrieve the information from the report using a webhook or (?)
- A combination of the above
Thanks in advance!
