Scrape keywords from data in google sheets

How can I scrape data from an exsisting google sheet for a particular keyword and make a new a google sheet of that data

Hi James, this question lacks context, can you please elaborate?

  • Your use-case
  • You have any example, screenshots, looms?
  • What page will you scrape based on the keywords.