/lcbo-fetcher

Hacky google sheet script for fetching some bourbon

Primary LanguageJavaScript

lcbo-fetcher

Hacky google sheet script for fetching some bourbon

Trigger

Script is attached to a google sheet with a time-based trigger of 30m

Cookies

Script needs to be loaded with the following cookies. This can be found by navigating to an lcbo page and setting your store location:

const COOKIES = {
  "WC_physicalCity": "TORONTO-CENTRAL",
  "WC_physicalStores": "715841646",
  "WC_stCity": "m4t2y4",
  "lang": "en",
  "languagepopupshown": "true",
  "storetype": "clickcollect",
};

Dependencies

Web scraping depends on the Cheerio Library

Google sheet format

Script pulls Proudct Url column and will populate the rest

Product Url Name Available for Delivery? Available in Store? Link Valid?
https://www.lcbo.com/webapp/wcs/stores/servlet/en/lcbo/blantons-single-barrel-special-reserve-kentucky-straight-bourbon-558320 Blanton's Single Barrel Special Reserve Kentucky Straight Bourbon (Limit 2 Bottles) unavailable unavailable FALSE
https://www.lcbo.com/webapp/wcs/stores/servlet/en/lcbo/w-l-weller-12-year-old-kentucky-straight-bourbon-288886 W. L. Weller 12-Year-Old Kentucky Straight Bourbon unavailable unavailable TRUE
https://www.lcbo.com/webapp/wcs/stores/servlet/en/lcbo/wl-weller-special-reserve-bourbon-405316#.X58N_S_b3Vo W.L. Weller Special Reserve Bourbon (Limit 2 Bottles) unavailable unavailable TRUE
https://www.lcbo.com/webapp/wcs/stores/servlet/en/lcbo/weller-antique-107-original-wheated-straight-bourbon-467969#.X58OFC_b3Vo Weller Antique 107 Original Wheated Straight Bourbon (Limit 2 Bottles) unavailable unavailable TRUE
https://www.lcbo.com/webapp/wcs/stores/servlet/en/lcbo/blantons-original-bourbon-255349#.X58OUi_b3Vo Blanton's Original Bourbon (Bottle Limit 2) unavailable unavailable TRUE
https://www.lcbo.com/webapp/wcs/stores/servlet/en/lcbo/colonel-eh-taylor-small-batch-kentucky-straight-bourbon-326942#.X58OYy_b3Vo Colonel E.H. Taylor Small Batch Kentucky Straight Bourbon (Limit 2 Bottles) unavailable unavailable TRUE
https://www.lcbo.com/webapp/wcs/stores/servlet/en/lcbo/eagle-rare-10-year-old-kentucky-straight-bourbon-604785#.X58Oei_b3Vo Eagle Rare 10 Year Old Kentucky Straight Bourbon (Limit 2 Bottles) unavailable unavailable TRUE
https://www.lcbo.com/webapp/wcs/stores/servlet/en/lcbo/bookers-kentucky-straight-bourbon-325993#.X58Oli_b3Vo Booker's Kentucky Straight Bourbon unavailable unavailable TRUE