Generate LSI keywords inside Google sheets

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

  1. Open a Google sheet or create one from
  2. Go to Tools-> Script editor -> delete the existing code and paste the code-> save the file as
  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(“”&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.
Exit mobile version