Google Spreadsheet

Dear Friends, 

I have google spreadsheet with 100+ links. I have script to validate if the link is broken/301/500 from this sheet. I want find if any link/s is/are broken on a particular web page and list out that string. Along with that I also want to find a particular string present on these web pages. Could you please let me know if any script is available. 

Thanks in advance. 

Thanks, 
Chandramohan 

Hi @csakkoni

This post was moved to a different board that fits your topic of discussion a bit better. This means you’ll get better engagement on your post, and it keeps our Community organized so users can more easily find information.

As you’ll notice, your Topic is now in the Project Development Help board. No action is needed on your part; you can continue the conversation as normal here.

Let me know if you have any other questions or if I can help with anything else.

Cheers!

You might want to try to first convert the spreadsheet to JSON:

https://coderwall.com/p/duapqq/use-a-google-spreadsheet-as-your-json-backend

And then you could make a script in any programming language. For example in Go (golang.org):

import (
  "net/http"
)

func main() {
response, _ := http.Get("google.com")
print(string(response.StatusCode))
}

You will be able to add the JSON stuff and loops etc. yourself and then it should work fine. 

1 Like