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
Member of Google Developers Experts Program for Google Workspace (Google Apps Script) and interested in supporting Google Workspace Devs.
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’ }
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’
Not replicating any access errors with that test url – my test sheet https://docs.google.com/spreadsheets/d/1MbU60ap89iZncC-tDLtsrfNlqp4w1KKvrTBrdG7Wnm4/edit#gid=0