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

Open a Google sheet or create one from sheets.google.com Go to Tools-> Script editor -> delete the existing code and paste the IMPORTJSON.gs code-> save the file as IMPORTJSON.gs In cell B2, have a provision to enter source keyword. 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 & ” “ ) 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 , “,” ) ) ) ) Now you can use the importJSON function on the resulting keywords to generate sub LSI keywords. Here is a sample sheet you can view for reference.