I need to calculate the average order value for any online e-com store by just entering the URL.. does anyone know if there are easy ways to do this, or if there is an app that will do it, preferably connected to Google Sheets as a script?
Unless an e-commerce company is transparent in sharing their sales details (this is probably very rare or unusual), you won't know the metrics needed in order to calculate it.
I would think that the 2nd best thing is to hire a scraper or data entry person to collect the average item prices to try to build an idea for it.
Sorry, that is the best idea or help that I can offer. Perhaps this is an opportunity for an entrepreneur to build this. :)
It's not possible unfortunately because you need to know all the orders made on this store to know it as the calculation is: total revenue/number or orders.
The closest you could get to is 'Average Product Price' through a crawler of some sort.