Is it possible to spin like this

Checa said:

There is a WordPress plugin that does what you want, Page generator Pro i think It will work for what you are looking instead It isnt plugin finallity at all

Click to expand...

Unavailable said:

i think i must be coded

Click to expand...

• $KEYWORD$ is a {good|great|very nice} product.

• =SUBSTITUTE(B2, "$KEYWORDS$", A1)

MatthewGraham said:

1. Replace the {Keyword1| keyword2| keyword3|keyword4} part with a placeholder character or string that won't appear anywhere else in your text. Ex:

• $KEYWORD$ is a {good|great|very nice} product.

2. Go to Google Sheets (or some other spreadsheet application)

3. Put your keywords into column A

4. Put your spun text into column B

5. Run this function in column C (type it into column C and drag it downwards to apply to the other cells in the column:

• =SUBSTITUTE(B2, "$KEYWORDS$", A1)

The spreadsheet will replace your arbitrary placeholder character with the keyword specified in column A

Click to expand...

west555 said:

Ya but that is again manual like i used search and replace in any other tool articleby article or am wrong ?

Click to expand...

function run_spintax(text_to_spin) {
  var text = text_to_spin;
 
  var matches, options, random;
 
  var regEx = new RegExp(/{([^{}]+?)}/);
 
  while((matches = regEx.exec(text)) !== null) {
    options = matches[1].split("|");
    random = Math.floor(Math.random() * options.length);
    text = text.replace(matches[0], options[random]);
  }
 
  return text;
  //console.log(text);
}

• Put your spintax template in some cell (I am using D1 in this example; the dollar signs prevent that cell from being dragged with the rest of the formula)
• Column A is the keyword you want to insert
• Column B is =SUBSTITUTE(run_spintax($D$1), "$KEYWORDS$", A2)

MatthewGraham said:

Would be easy enough to run the spin in bulk through an external tool and then copy-paste it into different cells, which is pretty much entirely automated.

If you want an even easier solution, you could always add a spintax function to Google Sheets by doing this:

1. Go to Tools --> Script Editor

2. Copy-Paste this into the script editor

Code:

function run_spintax(text_to_spin) {
  var text = text_to_spin;
 
  var matches, options, random;
 
  var regEx = new RegExp(/{([^{}]+?)}/);
 
  while((matches = regEx.exec(text)) !== null) {
    options = matches[1].split("|");
    random = Math.floor(Math.random() * options.length);
    text = text.replace(matches[0], options[random]);
  }
 
  return text;
  //console.log(text);
}

3. Press Ctrl+S to save the file

Then to run:

• Put your spintax template in some cell (I am using D1 in this example; the dollar signs prevent that cell from being dragged with the rest of the formula)
• Column A is the keyword you want to insert
• Column B is =SUBSTITUTE(run_spintax($D$1), "$KEYWORDS$", A2)

I tested a mockup of this a minute ago and it worked perfectly on the first attempt. Could easily generate thousands like this.

Click to expand...