How to Capture YouTube Videos Closed Caption Texts Using Google Chrome

YouTube closed captions can be useful for research, documentation, analysis, or creating rough transcripts. While YouTube does not always allow direct subtitle downloads, you can capture the live closed caption text using Google Chrome’s built-in Developer Tools.

This guide explains how to do it step by step.

Requirements

• Google Chrome browser
• A YouTube video with Closed Captions enabled
• Basic copy-and-paste knowledge

No browser extensions or third-party tools are required.

Step-by-Step Instructions

1. Open Google Chrome
   Launch the Google Chrome browser.
2. Go to YouTube
   Navigate to https://www.youtube.com.
3. Open a YouTube Video
   Select a video that supports subtitles or closed captions.
4. Enable Subtitles / Closed Captions
   Click the CC button on the video player to turn captions on.
   Make sure captions are visible before continuing.
5. Open Chrome Menu
   Click the three-dot menu (Customize and Control Google Chrome) beside your profile picture.
6. Go to More Tools
   From the menu, select More tools.
7. Open Developer Tools
• Click Developer tools.
• Shortcut:
  Windows: Ctrl + Shift + I
  Mac: Cmd + Option + I
8. Open the Console Tab
   Inside Developer Tools, select the Console tab.
9. Copy the Script Below

10. Paste and Run the Script
    Paste the script into the Console and press Enter.

The script will now log the currently displayed closed caption text every 1.5 seconds.

How It Works

• The script detects the active caption text displayed on the video
• It reads the text from the caption container
• Every 1.5 seconds, the text is printed in the Console
• As the video plays, captions appear in real time in the Console output

How to Save the Captured Captions

You can:

• Manually copy the Console output
• Select and save logs for short transcription needs
• Extend the script to store captions in variables or files

Notes and Limitations

• Only captures captions currently visible on screen
• Does not retrieve past or future subtitles
• YouTube UI changes may affect class names
• Best used for short to medium-length videos

Conclusion

This approach provides a simple and lightweight way to capture YouTube closed captions directly from the browser. It is especially useful for quick analysis, note-taking, and research when subtitle downloads are not available.

MathMaster: My First AI-Powered Adventure in Web App Creation!

As a newcomer to the world of generative AI, I recently embarked on an exciting journey to explore its potential—and the result is MathMaster, a dynamic web app built on Base44 that makes math learning fun and engaging. Powered by AI, this app is my first foray into leveraging cutting-edge technology to create something meaningful. Try it at https://math-master-0b4f05d5.base44.app/ with JavaScript enabled!

Why MathMaster? A Newbie’s AI Experiment

• Diving into generative AI for the first time was both thrilling and eye-opening. With Base44’s AI-driven tools, I crafted MathMaster to transform math education. Here’s what makes it special:
• AI-Driven Quizzes: Adaptive AI personalizes math challenges—from basic arithmetic to calculus—tailoring them to your skill level with instant feedback.
• Smart Visuals: AI-generated animations and 3D diagrams simplify complex equations and geometry, a feature I was amazed to create as a beginner.
• Intelligent Tracking: AI analyzes your progress, offering clear insights into strengths and areas to improve—something I found surprisingly intuitive to implement.
• Gamified Fun: AI awards badges and powers leaderboards, making learning feel like a game.
• Mobile-Friendly: Built on Base44’s AI-optimized platform, it’s fast, free, and works anywhere.

As a first-time explorer of generative AI, I was blown away by how it simplified app development, enabling me to focus on creativity while AI handled the heavy lifting.

Get Started

1. Open MathMaster in your browser.
2. Ensure JavaScript is enabled.
3. Explore AI-powered math learning!

Join the Journey

Tried MathMaster? Share how it’s helping you conquer math! As I continue exploring generative AI, follow for more insights on AI-driven edtech.

The Power of Connection: Insights from Leadership Is Language

In Leadership Is Language: The Hidden Power of What You Say—and What You Don’t, L. David Marquet redefines the role of language in leadership, emphasizing how words can create connection and drive engagement. Marquet, a former U.S. Navy submarine captain, challenges the traditional "command-and-control" approach, arguing that leadership today is less about issuing orders and more about fostering collaboration.

Central to the book is the idea of replacing "leader-follower" dynamics with "leader-leader" relationships. This shift hinges on the power of intentional communication. Instead of dictating tasks, leaders should ask open-ended questions, encourage thoughtful dialogue, and create a safe space for team members to share ideas. By doing so, leaders build trust and empower others to take ownership, fueling innovation and deeper connection.

Marquet introduces a cycle of "thinking blue" (reflection and creativity) and "doing red" (execution and action), encouraging leaders to balance these modes. Through practical tools and examples, he demonstrates how language can dismantle barriers, unlock potential, and foster genuine engagement.

Ultimately, Leadership Is Language underscores that connection begins with conversation. By choosing words thoughtfully, leaders can inspire collaboration, build stronger teams, and create a culture where every voice matters.

Buy the book here: Leadership Is Language: The Hidden Power of What You Say--and What You Don't

 

Quantum Computers: Ultimate Questions

Quantum computers could solve problems in minutes that would take today's supercomputers millions of years

In "The Hitchhiker's Guide to the Galaxy" by Douglas Adams, the ultimate question of life, the universe, and everything is famously revealed to be "What is the meaning of life, the universe, and everything?" The answer, as calculated by the supercomputer Deep Thought, is 42, though the actual question is never known.

When it comes to quantum computers and problem-solving, there are interesting parallels that can be drawn. Quantum computers leverage the principles of quantum mechanics to perform certain computations much more efficiently than classical computers. While they excel at specific types of problems, their application is not universal and depends on the nature of the problem being addressed.

In the context of the Hitchhiker's Guide to the Galaxy, one could draw a parallel between the ultimate question and the challenges that quantum computers are uniquely positioned to solve. Quantum computers are particularly adept at solving complex optimization problems, simulating quantum systems, and factoring large numbers—tasks that would take classical computers an impractical amount of time.

Just as the ultimate question in the Hitchhiker's Guide remained elusive, there are still challenges and limitations to the full realization of quantum computing. The field is continually evolving, and researchers are working to harness the potential of quantum computers for a broader range of problems.

In essence, the connection lies in the idea that both the ultimate question and quantum computing represent a quest for understanding and unlocking the mysteries of the universe—whether that's the meaning of life or the efficient solution to complex problems through advanced computational methods.

Top 5 Black Friday Wishlist

1. Tech Marvels:Upgrade your gadgets with the latest in tech! From smartphones to smart home devices, Amazon's Black Friday wishlist promises unbeatable deals on cutting-edge technology.
2. Fashion Finesse:Revamp your wardrobe with top-notch fashion finds. Whether you're into trendy styles or timeless classics, Amazon's Black Friday wishlist has the perfect ensemble waiting for you.
3. Home Sweet Home:Transform your living space with home decor, furniture, and kitchen essentials. Amazon's Black Friday wishlist offers discounts that make it easy to give your home a stylish and functional makeover.
4. Bookworm's Paradise:For the avid readers, Amazon's Black Friday wishlist is a dream come true. Snag deals on the latest bestsellers, e-readers, and book accessories to create the ultimate reading nook.
5. Fitness and Wellness:Kickstart your health journey with Amazon's Black Friday wishlist for fitness enthusiasts. Whether it's workout gear, fitness trackers, or wellness products, find the tools you need to prioritize your well-being.

Remember to keep an eye on Amazon's lightning deals and limited-time offers to make the most of your Black Friday wishlist. Happy shopping!

Top 10 new technologies 2023

2023 is almost up and the field of technology have been very interesting for this year. So, before the year is up, Here's top 10 technology that have revolutionized the field

1. Artificial Intelligence and Machine Learning: These technologies continue to advance rapidly, with applications in areas like autonomous vehicles, healthcare, finance, and more.
2. Quantum Computing: Quantum computers have the potential to revolutionize computing by solving complex problems much faster than classical computers.
3. 5G Technology: The rollout of 5G networks is expected to enable faster and more reliable wireless communication, paving the way for the Internet of Things (IoT) and smart cities.
4. Biotechnology: Advancements in gene editing (e.g., CRISPR) and personalized medicine are on the horizon, potentially revolutionizing healthcare.
5. Blockchain and Cryptocurrencies: These technologies are changing the landscape of finance, supply chain management, and more.
6. Clean Energy Technologies: Continued developments in renewable energy sources, such as solar and wind power, and energy storage solutions are vital for addressing climate change.
7. Augmented Reality (AR) and Virtual Reality (VR): AR and VR technologies are increasingly being used in gaming, education, training, and healthcare.
8. Robotics: Robots are becoming more advanced and are being used in industries like manufacturing, healthcare, and logistics.
9. Internet of Things (IoT): The IoT is expanding, connecting everyday objects and enabling data-driven decision-making in various sectors.
10. Space Exploration: Advancements in space technology, including private sector efforts, could lead to new discoveries and commercial opportunities beyond Earth.
    
    
    
    

VO2 max in Apple Watch

The integration of VO2 max measurement into Apple Watch has revolutionized personal fitness tracking. VO2 max, a key indicator of cardiovascular fitness, is now conveniently accessible to Apple Watch users. This feature offers insights into one's aerobic capacity and overall health.

Apple Watch calculates VO2 max based on various factors, including heart rate, age, sex, and workout intensity. During outdoor running and walking workouts, the watch estimates VO2 max by analyzing your pace and heart rate data. This information provides valuable feedback on your cardiovascular health and helps you tailor your exercise regimen.

Tracking your VO2 max with Apple Watch allows you to set personalized fitness goals and monitor your progress over time. As your aerobic fitness improves, you can witness the positive impact of your efforts on this important metric.

However, it's essential to recognize that while Apple Watch provides a convenient way to estimate VO2 max, it may not be as accurate as lab-based tests. Factors like environmental conditions and individual variations can affect the readings. Therefore, it's advisable to view the measurements as general trends rather than absolute values.

Incorporating VO2 max tracking into Apple Watch underscores the device's commitment to enhancing users' health and well-being. It empowers individuals to take proactive steps toward better fitness and offers a glimpse into the potential of technology to support a healthier lifestyle.

Top 5 Free-to-Play Racing Games on iOS (2023)

In the dynamic world of mobile gaming, iOS users continue to be spoiled for choice when it comes to high-quality, free-to-play racing games. These adrenaline-pumping titles offer thrilling experiences, realistic graphics, and engaging gameplay, all without costing a dime. Here are the top five free-to-play racing games on iOS in 2023 that are revving up excitement among gamers:

1. Asphalt 9: Legends: Renowned for its stunning visuals and arcade-style racing, Asphalt 9 offers an extensive car roster and a plethora of tracks to conquer.
2. Real Racing 3: With its emphasis on realism, Real Racing 3 remains a favorite. Featuring an array of licensed cars and meticulously detailed tracks, it offers a true-to-life racing experience.
3. CSR Racing 2: Focused on drag racing, CSR Racing 2 boasts jaw-dropping car customization and boasts a strong online multiplayer mode.
4. Mario Kart Tour: Nintendo's iconic racing game takes a joyful spin on iOS, allowing players to race as beloved characters through imaginative tracks inspired by the Mario Kart series.
5. Racing Rivals: This drag racing game stands out for its intense real-time multiplayer duels and a wide selection of cars to tune and upgrade.

With these five stellar options, iOS users can dive into the fast-paced world of virtual racing without spending a dime. Whether you're seeking realistic simulations or whimsical karting adventures, these games offer a variety of experiences to satisfy every racing enthusiast's craving for speed and competition.

20 Reasons Why Your Facebook Account May Get Hacked

In today's digital age, social media has become an integral part of our lives, and Facebook remains one of the most popular platforms for connecting with friends and family. However, with its widespread usage comes an increasing risk of account hacking. Understanding the potential vulnerabilities can help users safeguard their accounts. Here are 20 reasons why your Facebook account may get hacked:

1. Weak Passwords: Easily guessable passwords make it easy for hackers to gain unauthorized access.
2. Phishing: Falling for phishing scams can lead to divulging login credentials to malicious actors.
3. Malware and Keyloggers: Infected devices can capture login information without your knowledge.
4. Unsecured Wi-Fi: Logging in from public Wi-Fi exposes your credentials to potential attackers.
5. Password Reuse: Using the same password across multiple platforms increases the risk of compromise.
6. Social Engineering: Hackers can manipulate individuals into revealing sensitive account information.
7. Account Recovery Weaknesses: Inadequate recovery options can be exploited by attackers.
8. Outdated Software: Using outdated apps or systems may expose known vulnerabilities.
9. Insider Threats: Trusted individuals with access may misuse account privileges.
10. Phony Apps: Installing unauthorized third-party apps can compromise your account.
11. Clickjacking: Hidden malicious links can trick users into clicking and compromising their accounts.
12. Brute Force Attacks: Repeated login attempts with various passwords until one succeeds.
13. Account Sharing: Letting others access your account can lead to unauthorized use.
14. Public Profile Information: Sharing sensitive details openly can aid hackers in impersonation.
15. Insecure Browser Extensions: Certain extensions may compromise your account security.
16. Lack of Two-Factor Authentication (2FA): Absence of an extra layer of security leaves accounts vulnerable.
17. Account Cloning: Hackers may replicate accounts to conduct scams or phishing.
18. Forgotten Logins: Abandoned accounts might be easier targets if recovery information is outdated.
19. Third-Party Website Compromises: Using Facebook credentials on untrusted sites may expose your login information.
20. Data Breaches: Security breaches on Facebook's end can lead to compromised accounts.

Protecting your Facebook account involves staying vigilant, using strong passwords, enabling 2FA, being cautious with links, and staying updated on security best practices. Regularly reviewing and adjusting privacy settings can also minimize the risk of falling victim to hacking attempts, ensuring a safer and more enjoyable social media experience.

How to build site with google apps script

To build a website using Google Apps Script, you can follow these general steps:

1. Create a new Google Apps Script project:
• Go to https://script.google.com and create a new project.
• Give your project a name and save it.
2. Set up the HTML and CSS files:
• In your Apps Script project, click on the "Files" menu and choose "New > HTML file" to create an HTML file.
• Write your HTML code in the editor.
• You can also create a CSS file by choosing "New > HTML file" and writing your CSS code.
3. Write server-side code:
• In your Apps Script project, go to the "Code.gs" file.
• Write server-side code using JavaScript.
• You can handle requests, process data, and interact with other Google services.
4. Create web app deployment:
• In your Apps Script project, go to the "Publish" menu and choose "Deploy as web app."
• Set the access permissions and choose the version you want to deploy.
• Click on "Deploy" and copy the generated web app URL.
5. Test and iterate:
• Open the generated web app URL in a browser to test your website.
• Make any necessary adjustments to the code and redeploy the web app.
6. Enhance your website:
• Add functionality using client-side JavaScript code in the HTML file.
• Interact with external APIs, databases, or other services as needed.
• Customize the design using CSS.

Remember that Google Apps Script has certain limitations and is primarily designed for automating tasks within Google services. It may not be suitable for building complex websites with advanced functionality. If you require a more robust and scalable web development solution, consider using other frameworks and technologies like JavaScript, HTML, CSS, and hosting platforms like Firebase, Google Cloud, or other web hosting services.

Examples:

• https://ashfull1979.blogspot.com/2020/07/how-to-build-web-app-in-google-apps.html
• https://ashfull1979.blogspot.com/2020/07/attendance-log-application-in-google.html

Fireworks photography

Settings for fireworks photography

Photographing fireworks can be a beautiful and exciting experience. Here are some settings and tips to help you capture stunning fireworks photos:

1. Use a Tripod: Stability is crucial when shooting fireworks. A sturdy tripod will keep your camera steady during long exposures.
2. Manual Mode: Switch to Manual Mode on your camera to have complete control over the settings.
3. Low ISO: Set your ISO to the lowest value (typically ISO 100 or 200) to reduce noise in your images.
4. Aperture: Start with a mid-range aperture like f/8 to f/11. This allows you to have a good balance of sharpness and depth of field.
5. Shutter Speed: For most fireworks, a shutter speed of 2 to 6 seconds works well. Experiment with longer exposures for multiple bursts in a single frame.
6. Manual Focus: Set your lens to manual focus and focus to infinity. Fireworks are often far away, and manual focus ensures sharp shots.
7. Use a Remote Shutter Release: A remote shutter release or the self-timer function will help eliminate camera shake during exposure.
8. Turn off Image Stabilization: If your lens has image stabilization, turn it off when using a tripod to avoid unintended blur.
9. Composition: Consider the composition of your shots. Include interesting foreground elements, like a city skyline or a landmark, to add depth to your images.
10. Shoot in RAW: Photograph in RAW format to retain more information for post-processing adjustments.
11. Be Prepared: Anticipate the timing of the fireworks and be ready to capture the bursts as they happen.
12. Experiment and Have Fun: Fireworks photography can be unpredictable, so experiment with different settings and enjoy the process.

Remember, each fireworks display can be different, so don't be afraid to adjust your settings as needed throughout the event. Take the time to review your shots as you go, making adjustments to get the best results. With some practice and creativity, you can capture stunning fireworks photos to celebrate the 4th of July or any other fireworks event.

Top 5 4th of July hacking movies

As of my last update in September 2021, there aren't many 4th of July-specific hacking movies that are well-known. However, there are some great hacking-themed movies that you might enjoy watching on Independence Day or any other day:

1. WarGames (1983) - Directed by John Badham, this classic film follows a young computer whiz who inadvertently hacks into a military supercomputer and almost starts World War III.
2. Hackers (1995) - Directed by Iain Softley, this cult classic features a group of young hackers who uncover a conspiracy while navigating the world of hacking and cybercrime.
3. Sneakers (1992) - Directed by Phil Alden Robinson, this movie revolves around a team of security experts who are blackmailed into stealing a powerful decryption device.
4. The Matrix (1999) - Directed by the Wachowskis, this iconic sci-fi action film showcases hackers discovering the truth about their reality and their role in a simulated world controlled by machines.
5. Live Free or Die Hard (2007) - Directed by Len Wiseman, this is the fourth installment of the Die Hard series, where John McClane battles cyber-terrorists attempting to shut down the entire United States.

Please note that the hacking landscape in movies can be fictionalized and exaggerated for entertainment purposes, and real hacking may have different implications and consequences. Nevertheless, these movies can be a fun way to enjoy some tech-related action on the 4th of July.

Travel itinerary template google sheets

Are you planning a trip and looking for a convenient and organized way to keep track of your travel plans? Look no further! With our custom Travel Itinerary Template on Google Sheets, your travel planning will become a breeze.

Our template is designed to help you stay on top of all the important details for your trip. It includes sections for dates, destinations, accommodation information, transportation details, activities, and even a packing checklist. With this template, you can easily input and update your travel information, making it accessible from any device with an internet connection.

Why choose our Travel Itinerary Template on Google Sheets? Here are a few key reasons:

1. Convenience: Access your travel itinerary anytime, anywhere, as long as you have an internet connection and a device to log in to your Google account.
2. Customizable: Tailor the template to your specific needs and preferences. Add or remove sections, adjust the layout, and make it truly your own.
3. Collaboration: Share the itinerary with your travel companions, allowing them to contribute and stay informed about the trip's plans.
4. Real-time Updates: Keep your itinerary up-to-date with real-time changes. Whether you modify the schedule or add new activities, your travel plan will reflect the latest information.
5. Easy Organization: Stay organized with a comprehensive overview of your travel arrangements, ensuring nothing is overlooked.

So, if you're ready to make your travel planning smoother and more efficient, give our Travel Itinerary Template on Google Sheets a try. Create a new sheet, customize it to your liking, and embark on your journey with peace of mind, knowing that all your travel details are well-organized and easily accessible. Happy travels!

https://docs.google.com/spreadsheets/d/1cwZxpA5ONcwzkGGJKomhR_Usbnm_uWbJeI01m4g39ig/edit?usp=sharing

https://docs.google.com/spreadsheets/d/1qRJx82_TMkrfAOLwKY8IIB67QTX7PWxJITLPvx2V9KE/edit?usp=sharing

binary search tree

In computer science, a binary search tree (BST), also called an ordered or sorted binary tree, is a rooted binary tree data structure with the key of each internal node being greater than all the keys in the respective node's left subtree and less than the ones in its right subtree. Wikipedia

Books for Learning

Chapters on Binary Search Tree and Microprocessor-Microcontroller

Binary Search Tree (BST) is a node-based binary tree data structure. It is one of the most widely used techniques for searching in non-linear data structure. Microprocessor and Microcontroller is a part of computer that plays an important role in today's technology. Reading these chapters will equip the readers with a summarized understanding of Binary Search Tree (BST) using C-Language and current trends on Microprocessor and Microcontroller

Advanced Algorithms and Data Structure

Advanced Algorithms and Data Structures introduces a collection of algorithms for complex programming challenges in data analysis, machine learning, and graph computing

Algorithms on Strings, Trees, and Sequences: Computer Science and Computational Biology

Traditionally an area of study in computer science, string algorithms have, in recent years, become an increasingly important part of biology, particularly genetics. This volume is a comprehensive look at computer algorithms for string processing. In addition to pure computer science, Gusfield adds extensive discussions on biological problems that are cast as string problems and on methods developed to solve them. This text emphasizes the fundamental ideas and techniques central to today's applications. New approaches to this complex material simplify methods that up to now have been for the specialist alone. With over 400 exercises to reinforce the material and develop additional topics, the book is suitable as a text for graduate or advanced undergraduate students in computer science, computational biology, or bio-informatic

auto click mac

Giguid USB Mouse Jiggler Undetectable Auto Clicker RGB Switchable with ON/Off Button Mouse Mover Plug & Play (ROBYMICE Series, 1 Item)

About this item

• Tiny powerful smart chip with high-tech alien face, make all the difference.
• Built in power saving LED indicator, can be turned off manually or automatically in standby.
• 7 light color options with memory function, breathe softly while moving, flicker softly while click.
• Make cursor moves randomly, or switch to automatically click 2 times per second on the target location.
• Plug and Play, no driver needed, no software installation required, easy and simple.
• USB Type-A connector can plug into any USB 1.0, USB 2.0, USB 3.0 port on the computer.
• Compatible with popular desk PC and laptops, like Windows, Mac, Linux, Android, Chrome.
• 1 year warranty with no reason to exchange, just feel free to contact us if there's any problem.

Should you Learn VBA or Power Query?

Should you Learn VBA or Power Query? Data Analytics and Business Analytics is quiet making some attention lately. It's a not new subject or system. Instead a very interesting approach and drives demands in the industry.

But the core of this two sciences (if I'm attributing them correctly) is of course Data and the Efficiency in managing the models. Speaking of efficiency is of course Automation ( to some degree if not totally ).

VBA

Visual Basic for Application is a legacy platform and it's been in existence, like ever since. It's a staple, comfort tools to some office productivity tools developers out there. Many applications have been build around it. It offered some relief to some office suite automation requirements. Very effective, but some find it hard for it needs programming skills to be able to build. Though there's Macro Recording, in Microsoft Excel, it really comes in handy.

Yet, just like any other technology new comes along, offers alternative and no coding involved.

Power Query

"Data prep done smart, fast, easy. Power Query is the easiest way to connect, extract, transform and load data from a wide range of sources" ---https://powerquery.microsoft.com/en-us/

ETL - Extract, Transform and Load are three basic steps for data usage and application. Most of the time in repetition and with repetition needs automation. In power query this is a guided steps and no coding involved. Every steps recorded instantaneously with less worry of maintaining a code base. We can say, like a Macro Recorder in a way that you can rearrange your steps without going into the actual codes. Convenient it is.

What's the verdict?

Data manipulation, cleansing or modelling. Power Query can be a very potent tool specially if we're dealing with large sets. It can also, deal a multitude of data sources. Local or online data streams. 

Automation and Repetition, both VBA and Power Query can efficiently offer. But, VBA can give level of customization with your applications. Specially with User Interaction, tapping other applications and just simply doing thing the other way.

So which should you choose?

Online Alarm Clock

Most of us were, or maybe still, working from home. It's one of those new normal where we spend most making a living at home. Though we are in the comfort of our homes, we often stricken with procrastination.

Guilty yet? With no pressure of commuting to the office. No pressure of those prying eyes of your every move. Concealed with all the corners of our house we can never deny that there are times we are off tracked of things to do. 

Complacent or just being lazy?

Here's a convenient way of poking those ears and pay attention to your todo's. Conventional todo list is sometimes boring. Sticky notes seems static and most of times in hidden view. Why not integrate alarm clock with notes. Although we have some mainstream apps out there. But, since we are all in the virtual environment with our PC in front of us most of the time. This tool well surely be of use. 

Check out the app below.

Create Online Quiz

When I started coding with Google Apps Script, this web app was one of those that is very clumsy yet working. I remember developing this one with the intent of providing a skills assessment for my team and other teams in my previous employer.

I've spent many hours creating this one and we did rollout this. The app was misunderstood at that time. As far as I could remember, that was 5 years ago. Today, this app makes even more sense. Especially, with online or virtual classrooms are a necessity. Distributing exams to students online is even more a requirement.

The Goal

• To create a web based application that could hold multiple exams from different topics/subjects.
• To have an easy setup of questions. Using google sheets as database.
• To have a quick turn around of the results.
• Teachers and proctors can have visibility of the students progress.

I've embedded the app on this article and leave a comment below if you'd like to try and setup an exam. No further development was done in the app. So bare with it if experiencing issues. As of the moment open for those with Gmail accounts.

Amazon Reviews Scraper

Amazon has the clout in the eCommerce segment. Most the brands, big and small, are crowding the platform hoping to get a pie of the consumer dollars. Selling through this platform is profitable and very competitive as well. So, how to gain advantage in understanding consumer profiles on line and learn how your products fits their needs and behaviors, The most important is understanding there feedbacks.

Star ratings and Reviews

Customer feedback still the key. More reviews means more sales. Yes, but how was the reviews? Good or Bad, 5 star or 1 star? How your product stack up against the competition? Amazon provides access to reviews if you a seller. To your own listing only. So, how would you capture those reviews from other sellers?

Web scraping

A staple and still useful. I'm not going to discuss the Customer Metric analytics. Instead, I'm going to share a tool to small Amazon sellers out there who would like to capture customer feedback and understand there sentiments. Please see link below:

Perseverance pictures straight to your Gmail

Mars Perseverance Rover is at Sol 186 on Mars. Since it's landing last February 18, 2021, it already roamed 1.97 km (1.22 mi) and spent 4611 hours on an alien planet. I'm going to describe the science and the technical aspect of the Rover. Instead, I will share to you on how to capture the raw images from Mars as captured by Mars Perseverance rover's many camera.

Note: The script/code is not a gmailapp, it's a stand alone script written with Google Apps Script

NASA Open API

The images are open for public to view. Stay tune on their Mars Perseverance Multimedia site when it's published. Or, you can always get ahead using NASA Open API. Of course, we'll make use of Google Apps Script to fetch from the API. Run the code on a daily basis. Then email the images properly into our Gmail inbox. Now, that's really cool way to get those images fresh.

Sample email output

Just a caution, the script only allows upto 100 images to be embedded in the Gmail body. It's the html table with rows capped at that number. Beyond that cap, will cause an error. As a remedy, I've added a line where the full html saved into a text file, saved into a my GDrive then attach it to the email notification.

The Script (have fun!):