🎄 2024 Advent Challenge 3: Smart Holiday Shopping Bot 🎁

News Challenges
10

Hey @lakshman , Hope you had a nice weekend !

For this challenge, I’ve chosen the approach of asking users to provide URLs of specific products they want to track. The challenge statement does not explicitly mandate an approach, allowing flexibility in implementation. This approach avoids the complexity and potential mess of tracking all products or searching based on generic product names.

That said here is my submission.

  1. Here is the Input Excel

    This image shows an Excel spreadsheet titled "InputFile.xlsx" where users can input product names, URLs from Amazon and Flipkart, and price thresholds for tracking price alerts, with a header section providing instructions on how to fill out the sheet. (Captioned by AI)
    This image shows an Excel spreadsheet titled "InputFile.xlsx" where users can input product names, URLs from Amazon and Flipkart, and price thresholds for tracking price alerts, with a header section providing instructions on how to fill out the sheet. (Captioned by AI)1076×594 41.7 KB

  2. Here is the “Sheet 1” for the Output Excel after the data is scraped. (Note : This sheet is cleared after each run)

    This image shows an Excel file named "OutputFile.xlsx," specifically the first sheet capturing product information from e-commerce sites, including product name, URL, product price, discount details, date, time, and threshold values, with annotations explaining its purpose for comparison and SMS body creation. (Captioned by AI)
    This image shows an Excel file named "OutputFile.xlsx," specifically the first sheet capturing product information from e-commerce sites, including product name, URL, product price, discount details, date, time, and threshold values, with annotations explaining its purpose for comparison and SMS body creation. (Captioned by AI)1078×591 65.5 KB

  3. Here is the 2nd Sheet for the Output Excel (Note : this one is leveraged to calculate & build SMS body)

    This is an Excel spreadsheet (Sheet 2) displaying product data and using formulas to check if the product prices are below certain thresholds for various sources (Flipkart and Amazon), highlighting the comparison results with "Yes" or "No". (Captioned by AI)
    This is an Excel spreadsheet (Sheet 2) displaying product data and using formulas to check if the product prices are below certain thresholds for various sources (Flipkart and Amazon), highlighting the comparison results with "Yes" or "No". (Captioned by AI)1073×591 42.5 KB

  4. Here is the SMS part of it, Utilizing Twilio’s services.

    The image shows a sequence of steps in an automation workflow where a phone number is retrieved from an asset and a message is sent to that phone number using Twilio. (Captioned by AI)
    The image shows a sequence of steps in an automation workflow where a phone number is retrieved from an asset and a message is sent to that phone number using Twilio. (Captioned by AI)369×534 12.3 KB

  5. Here’s some sample SMS’s (PS : I liked playing with the message body ;D)

    The image shows a series of text messages from a Twilio trial account, including a verification code, a greeting, and a list of products with their prices and sources. (Captioned by AI)
    The image shows a series of text messages from a Twilio trial account, including a verification code, a greeting, and a list of products with their prices and sources. (Captioned by AI)1080×2340 236 KB

    The image shows text messages from a Twilio trial account, where the first message says "Hello World," and the second provides a list of products including LEGO and a light bulb, with their prices and sources. (Captioned by AI)
    The image shows text messages from a Twilio trial account, where the first message says "Hello World," and the second provides a list of products including LEGO and a light bulb, with their prices and sources. (Captioned by AI)1080×2340 224 KB

    5.1) Bare Text SMSs
    The image shows a phone screen with two messages from a Twilio trial account, listing products including "Lego" and "Light Bulb" with their prices, thresholds, and sources. (Captioned by AI)
    The image shows a phone screen with two messages from a Twilio trial account, listing products including "Lego" and "Light Bulb" with their prices, thresholds, and sources. (Captioned by AI)1080×2340 244 KB

  6. Here are the products I monitor across Flipkart & Amazon.

    The image shows three Flipkart product pages featuring a Sony PS5 DualSense Wireless Controller priced at ₹5,749, a HALONIX 10 W Round B22 LED Bulb priced at ₹300, and a LEGO Classic Medium Creative Brick Box priced at ₹1,994. (Captioned by AI)
    The image shows three Flipkart product pages featuring a Sony PS5 DualSense Wireless Controller priced at ₹5,749, a HALONIX 10 W Round B22 LED Bulb priced at ₹300, and a LEGO Classic Medium Creative Brick Box priced at ₹1,994. (Captioned by AI)1364×552 301 KB

    The image shows three Amazon product pages for a Sony DualSense Wireless Controller at ₹5,555 with a 7% discount, a Halonix Radar 10W B22 LED bulb at ₹199 with a 43% discount, and a LEGO Medium Creative Brick Box at ₹1,994 with a 43% discount. (Captioned by AI)
    The image shows three Amazon product pages for a Sony DualSense Wireless Controller at ₹5,555 with a 7% discount, a Halonix Radar 10W B22 LED bulb at ₹199 with a 43% discount, and a LEGO Medium Creative Brick Box at ₹1,994 with a 43% discount. (Captioned by AI)1366×715 327 KB

  7. Here is the project folder.

    A file directory showing multiple folders and files with different extensions, including .xaml, .xlsx, and .json, organized by date of modification. (Captioned by AI)
    A file directory showing multiple folders and files with different extensions, including .xaml, .xlsx, and .json, organized by date of modification. (Captioned by AI)727×374 21.3 KB

  8. Attachment
    AdventChallenge3PriceTracker_2024_Harshit.zip (43.9 KB)

1 Like