Hello, I am curious if this idea is possible:
- Customer places order with “delivery” tag on Shopify
- Custom app that runs every minute will add new orders with the “delivery” tag to a google spreadsheet with E-mail, Address, Name, Phone Number, Order ID, Item List, Payment Type and Payment Total.
- [In Question] AppSheet recognizes that there is a new row entry in the orders table and e-mails the customer to schedule a delivery time using a Google Form that submits the data to a Google Sheet.
- [In Question] AppSheet recognizes that there is a new row entry in the scheduled table and offers the order up for delivery drivers to grab it.