Скачать или смотреть How to Extract ASINs from Amazon URLs in Google Sheets

In this video I demonstrate two ways to extract ASINs from urls. The first is using a formula that consists of one formula inside the other. This is a more complex way of completing the task. But there is another option which is a custom function I devised called "getasin".

Example usage : =getasin(A2) where A2 is the cell that contains the Amazon URL

Download instructions to install the "GET ASIN" function to any Google sheet:
https://mrmarkteach.gumroad.com/l/mar...

I've got a whole set of products, brands, suppliers and categories lists on this Google sheet:
https://docs.google.com/spreadsheets/...

I distribute tools such as spreadsheets and browser automations to help sellers automate certain aspects of the research and selling process. See links below to stay updated, download or view resources, or just contact me...

MY RESOURCES

*Amazon Matcher Google Sheet
https://sites.google.com/view/marktea...

*Stay updated and informed by email:
https://mrmarkteach.gumroad.com/l/too...

*View all my tools and resources on gumroad
https://mrmarkteach.gumroad.com/

*Access all my tools for sellers:
https://mrmarkteach.gumroad.com/l/acc...

*Download Amazon Matcher Sheet (automatically finds product matches)
https://sites.google.com/view/marktea...

RECOMMENDED SOFTWARE

*Chrome Extension to Scrape Webpages into CSV
https://bit.ly/instant-data-scraper-c...

*Automa Platform for Browser Automation
https://bit.ly/automa-browser-automat...

*My automations on Automa
https://www.automa.site/marketplace?a...

*Amazon Price History
https://bit.ly/keepa-price-history-fo...

*IP Alert Chrome Extension (discount code: mrmarkteach)
https://markteach--entreresource.thri...

*Seller Assistant App
https://bit.ly/seller-assistant-app-g...

*Skugrid
https://bit.ly/skugrid-dropshipping-s...

*Contact/Social Media:

Website: https://sites.google.com/view/marktea...
Email: [email protected]
Facebook: www.facebook.com/mark.teach.98434
Instagram: www.instagram.com/mr.mark.teach/
Twitter: www.twitter.com/teach_mark
Linkedin: / mr-mark-teach-057b1220b

*Join Facebook Group for Announcements, Discussion, and More:
  / spreadsheetsoftwaretoolsforsellers