Sharing and looking for help: Utilizing Google Sheets to periodically verify if a site is flagged by Google

Not too long ago, I encountered points the place my area was flagged by Google as a harmful website, and a few pages have been marked as unsafe. Moreover, a employees member from Adsterra knowledgeable me {that a} marketing campaign hyperlink of mine had a redirect URL that was flagged by Google Protected Looking.

Due to this fact, I’ve been eager about methods to promptly discover out if my area has been flagged by Google Protected Looking.

I searched boards however could not discover a comparable answer, apart from a Google Type shared by Dood that sends notifications as soon as flagged by VirusTotal.

I requested ChatGPT for assist, and it instructed utilizing the Protected Looking API to verify URLs.

Right here is the end result:

You could entry the Google Cloud Console, get hold of the Google Protected Looking API, and full the related setup within the Google Sheet to make use of it.

After testing, domains flagged as harmful by Google will be detected, and electronic mail alerts can be despatched to you.

---

However what I need assistance with is:

I used each the Google Protected Looking API and the web site https://transparencyreport.google.com/safe-browsing/search to verify my area.

The API returns solely two outcomes: protected and unsafe,