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


  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