[METHOD] Make Your Own PAA Site With OpenAI - Complete Tutorial + FREE Python Script

provocative said:
Firstly, thank you very much to the OP; this is really a great share.
I am not planning to create a PAA website, but I just wanted to try this to learn something new.

But I have a problem: my output.csv file is not saving to the computer. What could be the reason?

I know my script is working because I used ChatGPT to add a timestamp to the code, and I can see requests and credits spent on OpenAI. (It seems I simply thrashed a few dollars:) I have checked the Python folder and Windows Search All PCs, but output files are nowhere.

I can only get it if I call "output_df" as text in a Python script rather than a .csv file saved on my device.
Click to expand...
How many posts? You may have to wait for a little for the script to finish. It took me a few minutes for 10 posts
 
Advertise on BHW
AlbinKurti said:
Text was not showing in Wp All Import but after hitting import they showed as posts. The only problem I have is that i am asking openai to add h2 tags but out of 10 articles, openai adds the tags only on 3-4 of them. Any idea why openai does this?
Click to expand...

It’s probably an issue with your prompt. Try instructing it differently.
 
provocative said:
Firstly, thank you very much to the OP; this is really a great share.
I am not planning to create a PAA website, but I just wanted to try this to learn something new.

But I have a problem: my output.csv file is not saving to the computer. What could be the reason?

I know my script is working because I used ChatGPT to add a timestamp to the code, and I can see requests and credits spent on OpenAI. (It seems I simply thrashed a few dollars:) I have checked the Python folder and Windows Search All PCs, but output files are nowhere.

I can only get it if I call "output_df" as text in a Python script rather than a .csv file saved on my device.
Click to expand...

You need to wait atleast 7-8min, don’t close the software until that. I had the same problem.
 
autobaned said:
>>> import openai
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
ImportError: No module named openai
>>> import pandas as pd
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
ImportError: No module named pandas
>>>
>>> df = pd.read_csv ("input.csv")
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
NameError: name 'pd' is not defined
>>>

Why i get error Sir?
Click to expand...
hey dude did you solve this error?
 
Frostern said:
You need to wait atleast 7-8min, don’t close the software until that. I had the same problem.
Click to expand...

Somehow it doesn't save, even for 1 post I have waited half an hour just in case :)

Later, I have found that there is an output.csv on windows>sys32 (which is unrelated to where was my input and python codes) but file is not working. I think kind of a writing permission issue on Windows that I need to dig on.)
 
Last edited:
Great post, was wondering do you use any other tool for paraphrasing? to make it less likely google knows content is written by AI?
 
I keep on getting this error:

openai.error.ServiceUnavailableError: The server is overloaded or not ready yet.

I saw a few posts on open ai forum about this. It keeps on using my credits, crashing, and not producing output.
Any way to fix this, or just wait for OpenAI to get theit $hit together?
 
Thankyou, from this idea i can manage to make my own bot posting that can make post almost any niche..
 
provocative said:
Somehow it doesn't save, even for 1 post I have waited half an hour just in case :)

Later, I have found that there is an output.csv on windows>sys32 (which is unrelated to where was my input and python codes) but file is not working. I think kind of a writing permission issue on Windows that I need to dig on.)
Click to expand...
hey dude can u tell me how I compile this py code? I am getting errors repeatedly. Please help me.ai.png
 
warriorsam53 said:
Imo, there’s no duplicate content penalty as such. Even if the majority of your content is copied. Duplicate content ranks fine.

If you’re still worried, you can use OpenAI to do a rewrite of each article.
Click to expand...
Thanks for your reply. So based on your response, are you saying that you do think that there's a good chance that much of these articles are duplicate content?
 
After some tweaks, I was able to generate text, but whatever I do, the output text is always between 300-400 words. Does anybody know what I should do to make 1000 words articles?
 
Last edited:
AlbinKurti said:
you need to first install openai module. use this command
pip install openai
Click to expand...
Q.1 hey I ran the code but didn't happen it stuck here
ai 2.png

Q.2 Where is the output file if the task has been completed, Where I can find it the file?
 
As others have said, this was a great share.
Some people seem to be struggling with Python, so I used pyinstaller to make an executable version of the script which works on Windows platforms.
Download the file here:
https://www.mediafire.com/file/gmamp1v5kguq283/BHW+Script.zip/file

It's a zip file with three components:
- openai_scraper_v1.exe - a Windows executable -
- input.csv - an example of the input file
- openai_key.txt

INSTRUCTIONS

Download and extract onto your Windows machine - I recommend you use a sandbox until you're comfortable it's safe (!)
Edit the input .csv file with your queries
Edit the txt file and use your own openAI key, not the example in the file

Double click to run, and wait - nothing much happens until the run is completed and you end up with an output.csv file. I think Sheets is the best way to manipulate .csv files - you can do a one-click cleanup to remove extra spaces in the text (Data > data cleanup)

No guarantees or warranties. Kudos to OP @warriorsam53 who wrote the original script .

I checked the executable with Virustotal. I have no idea why it's showing 3 positives out of 67 - as I said, use at your own risk.

https://www.virustotal.com/gui/file...60ec7420ebd22b84cd6cadc7cd3cfa715f3?nocache=1
 
Kronickal said:
Great post, was wondering do you use any other tool for paraphrasing? to make it less likely google knows content is written by AI?
Click to expand...

I use OpenAI to rewrite content as well. I have a script that does that rewrites for me in bulk.

welshman said:
I keep on getting this error:

openai.error.ServiceUnavailableError: The server is overloaded or not ready yet.

I saw a few posts on open ai forum about this. It keeps on using my credits, crashing, and not producing output.
Any way to fix this, or just wait for OpenAI to get theit $hit together?
Click to expand...

Yeah there’s not much you can do. You can modify the script to keep trying on errors but it’ll still use up and waste your credits as far as I


ClickNinja said:
Thanks for your reply. So based on your response, are you saying that you do think that there's a good chance that much of these articles are duplicate content?
Click to expand...

What I’m saying is that it doesn’t really matter even if some of the content is duplicate.

Depending on your niche and keywords, you may have some duplicate content. But it doesn’t really matter.

People have done tests and ranked 70-80% duplicate content. This shouldn’t be an issue.
 
rapkishor said:
can you share some ideas for some prompts.
Click to expand...
It’s best if you come up with your own prompts. There’s no point in everyone using the same prompts.

Look into prompt engineering. It’ll take a few hours to get a hang of it but it’s worth it.
 
warriorsam53 said:
I use OpenAI to rewrite content as well. I have a script that does that rewrites for me in bulk.
Click to expand...

Seeing how you said that dup content isn't an issue, why do you have a script that rewrites content for you?

Could you please share that script with us? (Or a non-exactly the same version as yours)
 
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