How to Build an AI Blog Content Generator with GPT 3 (or ChatGPT) + Google Sheets and Docs

Рет қаралды 6,736

Жыл бұрын

Create your own AI content generator with Open AI's GPT-3. Generate your custom content inside a Google Sheet, then export the text to a Google Doc to share and edit. In this video I'll show you how to generate prompts to create blog posts and marketing assets.
Get the Code to Save your AI Generated Sheet to a Google Doc: www.rocktrembath.com/ExportToDoc
#ai #aicontentwriter #gpt3 #openai
Contents
0:27 What you'll need to start building your content generator
1:23 Notes on what AI is good at
2:13 Notes on what AI is bad at
3:00 Why use AI to generate a blog post?
3:31 [ SHORTCUT ] - Start building your GPT-3 Content Generator
4:04 Adjust GPT-3 Settings for blog posts
5:04 Outline content structure for generating
5:43 Choose a keyword to focus the post on
6:11 Write prompts for your post sections
6:40 How to reference a cell in a GPt-3 prompt
8:00 Generate a blog post intro
8:58 Generate blog post body copy
10:19 Generate related keywords
10:39 Generate a meta description, referencing keywords
11:42 Generate a Tweet to promote the post
12:17 Export AI generated text to a Google doc
12:53 Setting your destination folder for exported text
13:33 Using the Workflow Tools menu
13:44 Authorizing the export script
14:04 Setting content to export to Google Doc
14:47 Generating more blog posts with the blog post template
15:22 Using built in Google Doc functions to edit and provide feedback
15:50 Final thoughts and warnings
Ask a question on Twitter: / rocktrembath
rocktrembath.com

Пікірлер: 34

@RockTrembath Жыл бұрын

Upgrade your blog content generator to use ChatGPT! Get the code here: kzfaq.info/get/bejne/kJajf5Wa1J-ndZc.html

@jamesrogers2680 Жыл бұрын

Great vid Rock! Good production values, particularly the audio quality/easter eggs! I am the value!

@TharinduGunawardana Жыл бұрын

Another great video Rock

@chanakanb.6153 Жыл бұрын

love it ! thanks🙏

@1seliger Жыл бұрын

BIG THANKS, BRO!

@p.khachatryan6299 Жыл бұрын

Awesome video 👏

@jobelab Жыл бұрын

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.

@pvic6959 Жыл бұрын

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 Жыл бұрын

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.

@pvic6959 Жыл бұрын

@@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

@ABITATco Жыл бұрын

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?

@RockTrembath Жыл бұрын

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.

@ABITATco Жыл бұрын

@@RockTrembath Got it- Thanks

@user-rq9sp3oo2n 4 ай бұрын

Brilliant! Is there a way to get it to work with GPT4?

@RockTrembath 4 ай бұрын

Yep - use the most recent version of the AppScript github.com/rocktrembath/chatGPT-google-sheets/blob/main/appscript

@rajsalhan3820 Жыл бұрын

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.

@RockTrembath Жыл бұрын

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&".")

@TharinduGunawardana Жыл бұрын

Can we also check how we can use this to URL Mapping for website migration if possible

@RockTrembath Жыл бұрын

I'm not sure I understand the question. What Url do you want to map?

@TharinduGunawardana Жыл бұрын

@@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

@joshuadharman Жыл бұрын

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 "

@RockTrembath Жыл бұрын

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 Жыл бұрын

@@RockTrembath same thing. Name is correct. Is it any other way to fix it?

@RockTrembath Жыл бұрын

@@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

@markusw.8978 Жыл бұрын

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?

@RockTrembath Жыл бұрын

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.

@winfriedwengenroth Жыл бұрын

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 kzfaq.info/get/bejne/eZOXeb2LvN2RdIU.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 !!!

@RockTrembath Жыл бұрын

Check out my new video - I've made the template available for you to copy and edit as well: kzfaq.info/get/bejne/jJuPh5OUlp26kX0.html

@andrewlawson8233 Жыл бұрын

"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?

@RockTrembath Жыл бұрын

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?

@lindsayricci8048 Жыл бұрын

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?

@RockTrembath Жыл бұрын

@@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.