This was very easy to follow and super easy to implement. However when I requested an article to be 750 words the results it generated in the body were incomplete. Are there limitations in terms of the length of texts in the code?
I also believe you can just copy the values in google sheets so you dont have to do all that. I have a sheet in which a function generates some numbers. If I want to copy it anywhere, all I have to do is control-C. But to paste just the values in sheets, I have to control-shift-V
@@RockTrembath I think you can do entire columns as well. But I'd have to to test it as well. Im also not doing a great job explaining haha. In either case, what you showed worked anyway! And can be fully automated to generate dozens if not 1000s of results
was following along but couldn't complete cause I have ChatGPT plus subscription and not chatgpt thru OpenAI, which is a separate bill. Gonna try to add ChatGPt add on instead to Google Docs/sheets instead.
For some reason the menu function isn't showing up.. any ideas? **update.. i see the menu but also this error: "TypeError: Cannot read properties of null (reading 'getDataRange')Details "
Does your sheet have a name other than the default? You'd need to change where it says Sheet 1 // Select Sheet to Turn into Document - Make sure the name below matches your document var dataSheet = mySheet.getSheetByName('Sheet1');
@@ba_ov I can't replicate this error. If you want to share your sheet with safetoshareonline@gmail.com I'll take a look at it later. Make sure it has Editor access
Hi Rock, Thanks for all your good work :) I ahve foolwed your instructions, but keeop geeting the an error message at the body stage. Ive entered the coomand below, do you know what I'm doing wrong? =AI(As an engaging blog writer, you are creating a blog about "&E1&", extend the text:"&E3&.") Thanks.
Hey Raj - it looks as though you're missing a few quotes. Your prompt should be inside the quotes, and your references should not be. Try this: =AI("As an engaging blog writer, you are creating a blog about "&E1&", extend the text: "&E3&".")
Hi. Awesome video! Thx for that! I got an error when trying to save to document: Exception: Die Parameter (number[]) entsprechen nicht der Methodensignatur für DocumentApp.Body.appendTable. Or in englisch it should be: The parameters (number[]) don't match the method signature for DocumentApp.Body.appendTable. and cannot fix it.. what could be wrong?
I've put the script on a test sheet and tried breaking it. I can't reproduce this error. Check that the name of your sheet matches the variable dataSheet set on line 24. When I google it I see that error is associated with arrays, the script is expecting 2 or more columns of data, so that could be another potential issue.
@@RockTrembath Let say, that we are moving from the old domain to the new domain. When we do SEO migration, we have to map URLs manually one to one. We can ask ChatGPT to map old URLs to new URLs based on the most relevant NLP entity. It can be done Still not sure how to add to Google Sheet and ask to analyse many URLs in bulk and mapp each other
WOW ⭐🚀⭐🚀⭐ (German) Du bist Weltklasse. Bewusst schreibe ich Dir in Deutsch, auch wenn ich perfekt Englisch kann. Also Du bist ein ChatGPT Rockstar! Es gefällt mir extrem gut. Heute habe ich erst dein anderes Video gesehen ua-cam.com/video/C-gFZZWw-DQ/v-deo.html Das war schon sehr cool, aber mir fehlten die wichtigen Informationen, wie man es nach der Einrichtung dann auch tatsächlich effektiv anwendet, doch in diesem Tutorial zeigst Du es. Super klasse. Zudem mag ich Deinen Style. Du bist so schön entspannt! Wären doch früher so meine Lehrer gewesen :) dankeschön !!!
"Export generate text to a Google Doc" function not working for me. I.e I don't see the "Workflow Tools" menu. Anyone else had this problem and if so how did you fix?
Did you authorize the script? Open the app script window and hit the Run button at the top. It should prompt you to give it access to the document. Are you receiving an error message?
great video! Really appreciate the content. I am receiving the same issue where the workflow tools does not appear at the top. However i can run it directly from the code window when I press run and it work just fine. When I did press run from app script directly it asked me to authorize, which I did and like I said it worked, but I still don’t have the workflow tools tab at the top of the google sheet. Any idea how to get that going?
@@lindsayricci8048 Once you save the code in the App script Window, you need to reload the spreadsheet for it to pick it up. Once you reload the page/sheet it should pop up on the left of the menu bar. Takes ~3-5 seconds sometimes.
![How to: Connect OpenAI ChatGPT to Google Sheets [FREE App Script Tutorial and Starter Template]](http://i.ytimg.com/vi/Z0sL2io9CEc/mqdefault.jpg)
![How to: Connect OpenAI ChatGPT to Google Sheets [FREE App Script Tutorial and Starter Template]](/img/tr.png)
Upgrade your blog content generator to use ChatGPT! Get the code here: ua-cam.com/video/Z0sL2io9CEc/v-deo.html
Great vid Rock! Good production values, particularly the audio quality/easter eggs!
I am the value!
Another great video Rock
This was very easy to follow and super easy to implement. However when I requested an article to be 750 words the results it generated in the body were incomplete. Are there limitations in terms of the length of texts in the code?
Yes - in the App Script there is a constant variable named MAX_TOKENS
You can try increasing the amount of tokens to process. The max gpt 3.5 is 4096.
@@RockTrembath Got it- Thanks
BIG THANKS, BRO!
I also believe you can just copy the values in google sheets so you dont have to do all that. I have a sheet in which a function generates some numbers. If I want to copy it anywhere, all I have to do is control-C. But to paste just the values in sheets, I have to control-shift-V
Yep, the Paste Values only Command will allow you to move the text generated. Works good for a single cell. In this case I want both columns.
@@RockTrembath I think you can do entire columns as well. But I'd have to to test it as well. Im also not doing a great job explaining haha. In either case, what you showed worked anyway! And can be fully automated to generate dozens if not 1000s of results
was following along but couldn't complete cause I have ChatGPT plus subscription and not chatgpt thru OpenAI, which is a separate bill. Gonna try to add ChatGPt add on instead to Google Docs/sheets instead.
Brilliant! Is there a way to get it to work with GPT4?
Yep - use the most recent version of the AppScript
github.com/rocktrembath/chatGPT-google-sheets/blob/main/appscript
love it ! thanks🙏
For some reason the menu function isn't showing up.. any ideas?
**update.. i see the menu but also this error: "TypeError: Cannot read properties of null (reading 'getDataRange')Details
"
Does your sheet have a name other than the default?
You'd need to change where it says Sheet 1
// Select Sheet to Turn into Document - Make sure the name below matches your document
var dataSheet = mySheet.getSheetByName('Sheet1');
@@RockTrembath same thing. Name is correct. Is it any other way to fix it?
@@ba_ov I can't replicate this error. If you want to share your sheet with safetoshareonline@gmail.com I'll take a look at it later. Make sure it has Editor access
Awesome video 👏
Hi Rock,
Thanks for all your good work :)
I ahve foolwed your instructions, but keeop geeting the an error message at the body stage. Ive entered the coomand below, do you know what I'm doing wrong?
=AI(As an engaging blog writer, you are creating a blog about "&E1&", extend the text:"&E3&.")
Thanks.
Hey Raj - it looks as though you're missing a few quotes.
Your prompt should be inside the quotes, and your references should not be. Try this:
=AI("As an engaging blog writer, you are creating a blog about "&E1&", extend the text: "&E3&".")
Depending on the chatgpt prompt, it's not unfair to assume you can pull in factual data right????
Yeah. It's generally decent. I'm just not taking any responsibility for saying that it's correct 🙂
Hi. Awesome video! Thx for that!
I got an error when trying to save to document:
Exception: Die Parameter (number[]) entsprechen nicht der Methodensignatur für DocumentApp.Body.appendTable.
Or in englisch it should be: The parameters (number[]) don't match the method signature for DocumentApp.Body.appendTable.
and cannot fix it.. what could be wrong?
I've put the script on a test sheet and tried breaking it. I can't reproduce this error.
Check that the name of your sheet matches the variable dataSheet set on line 24.
When I google it I see that error is associated with arrays, the script is expecting 2 or more columns of data, so that could be another potential issue.
Can we also check how we can use this to URL Mapping for website migration if possible
I'm not sure I understand the question. What Url do you want to map?
@@RockTrembath Let say, that we are moving from the old domain to the new domain. When we do SEO migration, we have to map URLs manually one to one.
We can ask ChatGPT to map old URLs to new URLs based on the most relevant NLP entity. It can be done
Still not sure how to add to Google Sheet and ask to analyse many URLs in bulk and mapp each other
WOW ⭐🚀⭐🚀⭐ (German) Du bist Weltklasse. Bewusst schreibe ich Dir in Deutsch, auch wenn ich perfekt Englisch kann. Also Du bist ein ChatGPT Rockstar! Es gefällt mir extrem gut. Heute habe ich erst dein anderes Video gesehen ua-cam.com/video/C-gFZZWw-DQ/v-deo.html Das war schon sehr cool, aber mir fehlten die wichtigen Informationen, wie man es nach der Einrichtung dann auch tatsächlich effektiv anwendet, doch in diesem Tutorial zeigst Du es. Super klasse. Zudem mag ich Deinen Style. Du bist so schön entspannt! Wären doch früher so meine Lehrer gewesen :) dankeschön !!!
Check out my new video - I've made the template available for you to copy and edit as well:
ua-cam.com/video/V5_T0c17VaI/v-deo.html
"Export generate text to a Google Doc" function not working for me. I.e I don't see the "Workflow Tools" menu. Anyone else had this problem and if so how did you fix?
Did you authorize the script?
Open the app script window and hit the Run button at the top. It should prompt you to give it access to the document.
Are you receiving an error message?
great video! Really appreciate the content. I am receiving the same issue where the workflow tools does not appear at the top. However i can run it directly from the code window when I press run and it work just fine. When I did press run from app script directly it asked me to authorize, which I did and like I said it worked, but I still don’t have the workflow tools tab at the top of the google sheet. Any idea how to get that going?
@@lindsayricci8048 Once you save the code in the App script Window, you need to reload the spreadsheet for it to pick it up. Once you reload the page/sheet it should pop up on the left of the menu bar. Takes ~3-5 seconds sometimes.