LSI keywords for seo in google sheets

Generate LSI keywords inside Google sheets

google sheets / By

In this article, we will see how to create Bulk LSI keywords using Google sheets.

  1. Open a Google sheet or create one from sheets.google.com
  2. Go to Tools-> Script editor -> delete the existing code and paste the IMPORTJSON.gs code-> save the file as IMPORTJSON.gs
  3. In cell B2, have a provision to enter source keyword.
  4. Use the following code to generate LSI keywords for the source keyword.
    • =importjson(“http://suggestqueries.google.com/complete/search?output=firefox&hl=en&q=”&B2&” “)
  5. The above step will generate LSI keywords in a single cell. To get it in different cells, you can use the transpose and split function.
    • =TRANSPOSE(arrayformula(to_text(SPLIT(B5,“,”))))
  6. Now you can use the importJSON function on the resulting keywords to generate sub LSI keywords.
  7. Here is a sample sheet you can view for reference.