Parse 16K URLs and Put the Result to Google Sheet in 3 Minutes

Sometimes my best option is to write code on the go rather than using libraries or searching for ready-to-use code.

In this way, I’ve made a short script for parsing URLs and putting the result into my Google Sheet.

Photo by Joel Mott on Unsplash

Setup:

  1. The column with URLs
  2. The column to put the result
  3. The parsing logic. It’s a regex in my case

From my experience, the best way to use batch fetching is to split tasks by 50 requests in a bunch. And that’s it, the code execution time was 3 minutes, not the best result, but OK.

Here’s the code:

Hope someone, or future me, will find it helpful. Happy coding!

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store