[Easy Trick] Google Sheets has a built in content spinner

MatthewGraham said:
English --> Spanish --> English was the first thing I tested. It was definitely more readable; too readable, really, since it was mostly unchanged after the EN-->ES-->EN test. Bots seem to be pretty good at translating between similar languages, so the text ends up being so similar that it's essentially a duplicate.

Would imagine EN-->German-->EN would hit a similar issue. Maybe looping through a ton of European languages (e.g., EN-->French-->German-->Spanish-->Italian-->Greek-->Etc-->Etc-->Etc-->English) would give you a good change while being more grammatically coherent than translating into vastly different languages like Arabic/Asian languages. Might try that out.
Click to expand...

Maybe try to group languages?

I.e. English is a West Germanic language, so is Dutch and German. The nearest neighbors are the North Germanic languages like Danish, Nordic, Icelandic, and Swedish.

Stepping through translations in this order might render a (more) comprehensible but unique text?
 
Advertise on BHW
We can also use translation function in Microsoft Excel Sheet
Open Excel file - Select any cell you need to translate - go to Review tab at the top menu - select translate option
You would see translation panel on right side
Select the target language
You can either copy the final output or simply select destination cell.

This way we can hide our spinning activity from google
 
Since this thread seems to have been useful to people, here's a bonus tip for manual spintax in Google Sheets:

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

4. You now have a function called run_spintax that will spin standard spintax.
 
Last edited:
For similar languages such as English-German you get less uniqueness but probably better accuracy than with other options. Because translate most likely better translates to similar languages that to ones that are not similar.

So. Everything should be tested.
 
MatthewGraham said:
Since this thread seems to have been useful to people, here's a bonus tip for manual spintax in Google Sheets:

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

4. You now have a function called run_spintax that will spin standard spintax.
Click to expand...


Brother can you explain how this works???? I have saved the function, then what?
 
Thank you a very good share, I was using WordAI will definitely give this a try.
 
Indiangrubby said:
I'm not understanding how it wud work & even if it works then how do i know it did ?

After saving the file, I dont know what I'm looking for .
Click to expand...
Simple. Just follow step by step and it will work. In one word i can't explain you. as where you are stuck don't know.
So just follow his step by step and it's easy once done. :)
 
payal23j said:
Simple. Just follow step by step and it will work. In one word i can't explain you. as where you are stuck don't know.
So just follow his step by step and it's easy once done. :)
Click to expand...
my friend may be i have become noob enough to not understand what is happening here.
This is so embarrassing

The original content is pasted into a2, the google translate code is there on b2

now I have the spun/translated content.......i do not understand where the run the function "run_spintax"

I'm such a noob sorry!
 
Indiangrubby said:
my friend may be i have become noob enough to not understand what is happening here.
This is so embarrassing

The original content is pasted into a2, the google translate code is there on b2

now I have the spun/translated content.......i do not understand where the run the function "run_spintax"

I'm such a noob sorry!
Click to expand...
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);
}



This one even i haven't tried. Just try now but not getting where to put text. It's running with myfunction but results were empty as i haven't added text anywhere. On google translate its working.
 
Advertise on BHW
You must log in or register to reply here.
Sign up now!

Main Menu

Home Main Forum List Black Hat SEO White Hat SEO BHW Newbie Guide Blogging Black Hat Tools Social Media Downloads

Marketplace

Account Selling Content / Copywriting EBooks / Methods Hosting Misc Proxies For Sale SEO - Link building SEO - Packages Social Media Social Media - Panels Web Design More

Making Money

Affiliate Programs Hire a Freelancer IM Journeys Making Money Pay Per Click Site Flipping Want to Buy

BlackHat World

Dispute Resolution Forum Suggestions & Feedback Introductions Lounge
Back
Top