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

MatthewGraham

BANNED
Joined
Oct 6, 2015
Messages
1,759
Reaction score
2,740
Website
www.youtube.com
After reading the https://support.google.com/docs/table/25273?hl=en (which you should do), I came across a neat trick to spin anything you want effortlessly. Free and easy, no captcha.

This is a built in Google Sheets function:
  • =GOOGLETRANSLATE(text, [source_language], [target_language])
Full documentation:
  • https://support.google.com/docs/answer/3093331?hl=en

How to Use
Easily used as a spinner by translating into a different language and then back into the source language. For example, this line imports the text stored in cell A2, translates it into Korean, and then translates it back into English:
  • =GOOGLETRANSLATE(GOOGLETRANSLATE(A2, "en", "ko"), "ko", "en")
For a more intense spin, you can add additional layers of translation. For example, here's a formula for English to Korean to Spanish to Arabic and then back to English:
  • =GOOGLETRANSLATE(GOOGLETRANSLATE(GOOGLETRANSLATE(GOOGLETRANSLATE(A2, "en", "ko"), "ko", "es"), "es", "ar"), "ar", "en")

Example Output
The example below is the result of running the function shown above to translate the start of the http://en.wikipedia.org/wiki/Dog to Korean and then back to English.

Before
The domestic dog (Canis lupus familiaris when considered a subspecies of the gray wolf or Canis familiaris when considered a distinct species)[4] is a member of the genus Canis (canines), which forms part of the wolf-like canids,[5] and is the most widely abundant terrestrial carnivore.[6][7][8][9][10] The dog and the extant gray wolf are sister taxa[11][12][13] as modern wolves are not closely related to the wolves that were first domesticated,[12][13] which implies that the direct ancestor of the dog is extinct.[14] The dog was the first species to be domesticated[13][15] and has been selectively bred over millennia for various behaviors, sensory capabilities, and physical attributes.[16]

Their long association with humans has led dogs to be uniquely attuned to human behavior[17] and they are able to thrive on a starch-rich diet that would be inadequate for other canid species.[18] New research seems to show that dogs have mutations to equivalent genetic regions in humans where changes are known to trigger high sociability and somewhat reduced intelligence.[19][20] Dogs vary widely in shape, size and colors.[21] Dogs perform many roles for people, such as hunting, herding, pulling loads, protection, assisting police and military, companionship and, more recently, aiding handicapped individuals and therapeutic roles. This influence on human society has given them the sobriquet "man's best friend".

After (English --> Korean --> English
Domestic dog (considered a distinct species considered when Gray Wolf or subspecies of Canis's familiaris of Canis lupus's familiaris) is [4] Wolf-like member of a portion of canids formation in dogs (canine), [5] is the most widely-rich terrestrial meat . [6] [7] [8] [9] [10] and one because of the presence Gray Wolf does sister taxa is [11] [12] [13] of direct ancestors are not related Wolf close the captured contemporary Wolf, [12] 13] extinction to mean. [14] The dog was in the domesticated species [13] [15] and have been selectively bred for a variety of behavioral, sensory function, and physical properties as thousands. [16]

Their long association with humans and can lead the dog to be uniquely adapted to human behavior [17] and will succeed in improper starch-rich diet on the other canid species. [18] A new study shows that dogs seem to have a genetic mutation in the region corresponding to human-induced changes that are known to the high social and decreased intelligence. [19] [20] Dogs vary the shape, size and color. [21] Dogs perform many roles for people, such as the disabled person and secrete therapeutic role, as recently as hunting, herding, pulling loads, protection, support the police and military, companionship. Human society, this effect has given them the nickname "Man's best friend".


After (English --> Korean --> Spanish --> Arabic --> English
Local dog (considered a separate species is considered when the gray wolf or a dog breed familiaris lupus familiaris dog) is [4] Wolf-like part of a member of the formation of dogs canids (dogs), [5] is the widest range of rich ground meat. [6] [7] [8] Lobo [9] [10] and one due to the presence of varieties sister gray wolf and [11] [12] are not linked [13] The immediate ancestors of the closure of the contemporary wolf capture [12] 13] extinguishers. Domesticated species and [14] dog [13] [15] and I have bred selectively for a variety of behavioral and sensory functions, and physical properties as thousands. [16]

It has a long-term relationship with humans and can lead to a dog that is uniquely adapted to human rights [17] behavior and success in dieting is not enough rich in starch in other species of canids. [18] A new study showed that dogs seem to have a genetic mutation in man corresponding changes known as high social intelligence and reduced the region induced. [19] [20] dogs shape, size and color vary. [21] Dogs perform many roles for people, such as a disabled person and secrete a therapeutic role, in recent times, such as hunting, herding, pulling loads, protection and support for the police and the army, Companionship. Human society, has been given to this effect on the title of "man's best friend."
 

MatthewGraham

BANNED
Joined
Oct 6, 2015
Messages
1,759
Reaction score
2,740
Website
www.youtube.com
Lol, useful, but it's kinda funny how the original "the domestic dog...the most widely abundant terrestrial carnivore" became "the widest range of rich ground meat" after it went through two Korean translations. :D
"Domesticated species and dog and I have bred selectively"

@Neon
 

Alex D.

Supreme Member
Joined
Sep 22, 2017
Messages
1,350
Reaction score
719
That's amazing. Bookmarked for later use. Thanks for share.
 

moonlighsunligh

Jr. VIP
Jr. VIP
Joined
May 1, 2010
Messages
2,181
Reaction score
349
Website
cleverspinner.com
It should work better if you do English-German-English.

And do not forgot you can translate your keywords into German or Spanish for example, find info in German/Spanish, and then translate it to English as well. This might work better as a base for content.
 

tenken29

Junior Member
Joined
Jul 18, 2018
Messages
125
Reaction score
25
Whoa, great post, this should be pinned, thanks Matthew.
 

MatthewGraham

BANNED
Joined
Oct 6, 2015
Messages
1,759
Reaction score
2,740
Website
www.youtube.com
It should work better if you do English-German-English.
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.
 

ThopHayt

Jr. VIP
Jr. VIP
Joined
Jul 25, 2011
Messages
7,010
Reaction score
2,853
If you used a third party translator (that isn't using the same dictionary as Google) as the first step before jumping into Google it should give a more diverse end result. However, beware that Google is able to catch many instances of manually rewritten text, so be careful where and how you test this out before going nuts.

-ThopHayt
 
Top