Google Sheets Based Automation for online Pharmacy

Google suite automations required with; # Delegation sheet with whatsapp Linking and attached with Dashboard. # Checklist for order processing # Inventory Management System with Automated P.O. Generation # Master Dashboard # delivery /dispatch trackers embedded with Google maps and shortest routes(mapquest etc) # Payment Collection Engine Embed with whatsapp,SMS and mail. # Birthday / Anniversary wishes and reminders Embed with whatsapp and mail. # CRM Linked with whatsapp and BOT. # Order Management System. # MIS Dashboard. # website with form to take orders etc. # whatsapp via selenium IDE or any other free integrations The brief flow 1) the customer places the order through whatsapp via an automated form that collects data like their name, address and location ( Geo Location)other contact details and Prescription .we shall have order collection points and have to set each point a unique id with their commissions 2) the order is generated ( with unique order id) and forwarded to agent for verification of prescription and the drugs ordered. 3) The verified order is forwarded to operations agent for checking inventory. 4) All orders should be able to tabulate for inventory check 5) Agent checks inventory and sources the products. Via generated purchase order 6) The goods are received and updated in inventory 7) Individual orders are processed and packed 8) Individual invoices are generated and sent via whatsapp along with payment link etc ( COD option also) 9) Payment is verified and processed for dispatch 10) Dispatch team to get the delivery data 11) Dispatch closure and collection of cash(if cod) 12) EOD day dashboard 13) Capture of buying [login to view URL] sales price and gross profit/ [login to view URL] day/week and month. 14) Various sales dashboards 15) Creation of products with supplier name/details etc.