google sheets

Google Sheets ImportXML – Automatically Scrape Web and Collect Product Price Info

I am always on the lookout for a unique angle to use freely available or potentially scrapable data sources. Also, It’s indeed frustrating that you have, admittedly, spent hours upon hours trying to learn Python for writing simple web scraper applications, and implementing web scraping automatically, however, at the end you can only discover the data isn’t accessible, interesting or differentiated enough from what’s already out there.

If you just want to automate updating the profit calculator of your eCommerce business, thankfully, there is an easier way to collect data from the web without spending that much hours: Google Sheets ImportXML Function.

google sheet formula

9 Google Sheet Formulas Plus 1 Add-on for the eCommerce Marketing

It is critical to make things in order and in place well, as this calculation is associated with the selling price, different variable costs that can cause business loss at the end. In this article, I’ll introduce 9 Google Sheet functions + 1 automation add-on for your eCommerce marketing operation. By the end of the article, you could learn about my practical experience on how to apply these functions and add-ons to set your hands free and calculate accurately.

Featured Video Play Icon

Selling Well But Be Losing Money? 7 Variable Costs Are Impacting Your Online Store Profit Margin

Most of the online sellers ignore what variable costs would take place per transaction, and underestimate the impact of variable cost change in the profit margin, particularly as the variable cost increases with the sales going up.

So for the purpose to avoid selling more but be losing more. I’m going to talk about 7 types of online store selling variable cost that can impact the profit margin per transaction.