AppsScriptPulse

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

Photo by Joel Mott on Unsplash

Sometimes my best option is to write code on the go rather than using libraries or searching for ready-to-use code. I’ve made a short script for parsing URLs and putting the result into my Google Sheet.

As a developer it is always interesting to see how other people approach problems. This little snippet from Max Makhrov caught my eye because the approach to parsing data in a Google Sheet wasn’t one I’d seen before. Follow the source link to have a look yourself…

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

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

  1. L.Klein
    5 May, 2021 at 18:5120

    I tried this on some URLs and it failed miserably??? I am being blocked as spam by wordpress??? [Exception: Invalid argument: http://[object%20Object]] name: ‘Exception’ }

  2. LiKlein
    5 May, 2021 at 18:5320

    Try again and send a sample URL separate from the error message as WordPress blocks comment when both included url: ‘https://community.lincs.ed.gov/group/25/event/2021-05-13t180000/decoding-instructional-strategies-part-1-2-live-session’

  3. 5 May, 2021 at 21:3020

    Not replicating any access errors with that test url – my test sheet https://docs.google.com/spreadsheets/d/1MbU60ap89iZncC-tDLtsrfNlqp4w1KKvrTBrdG7Wnm4/edit#gid=0

Leave a Reply

Your email address will not be published. Required fields are marked *