I have multiple Shopify stores and I want to transfer order data (every time a new order is being placed) to a third party system like Google Sheets or AIR TABLE using INTEGROMAT
Main goal: Centralize all orders in one aggregating (order management/accounting) system
Second goal: I have a manufacturer who should get to see/edit only certain data of each order. Right now, I do this with a second file on Google Sheets. This then synchronizes back with my primary file on Google Sheets. But I don’t feel that Google Sheets is powerful for the entire process. This is why I am now turning over to AIRTABLE
Important as well: After the manufacturer pushes something like an “production done” button (right now i realize this using check-marks in cells in Google Sheets), my main table should update itself. The customer should also get a notification that his order is about to be shipped.
I guess this use-case should already have occurred here on Airtable. Nevertheless, I couldnt really find exactly what I am looking for. Do you know any good all-round solution for this?