Zakch93
Elite Member
- Mar 7, 2020
- 2,309
- 856
Hello BHW. I found this Google Sheets app called "GPT for Sheets". This app is free to use, you just put your API key. Here is a screenshot of the sheet with the general idea, but I need your help to finish it.
- Column 1 has the keywords. This list of KWs is not cleaned, but it's easy to do that with ChatGPT.
- In column 2 I ask it to create an outline
- Column 3 is for a title
- In column 4 I ask it to write section 1. You can see the exact prompt I'm using below the Sheets toolbar.
- Dropping down the formulas creates an article for each keyword
I don't ask it to write all the sections because my OpenAI outputs don't exceed 500 words. It's the same in Playground or when using the API. I don't know if it's by design. If you have an idea about this, please share it.
So the idea is to write each section separately, then use a simple formula in Sheets to combine them into the articles, which we'll export to WP. But as you can see, there are some issues.
- AI doesn't respect prompts. When asked to write section 2 of the outline, it also writes other sections.
- Ends with an incomplete sentence.
- GPT for Sheets extension lags is slow and sometimes gives Error: Exceeded maximum execution time (line 0). I think this error is mitigated by reducing the token value.
- Outputs are created in Markdown format, but how to convert them to HTML when exporting the sheet to WP?
I gave you the premise. Now try to complete the project, and we'll have one of the best article generators, and we won't need to pay for content again. Share all your ideas, findings, technical solutions, and prompts here.
Explanation:
- Column 1 has the keywords. This list of KWs is not cleaned, but it's easy to do that with ChatGPT.
- In column 2 I ask it to create an outline
- Column 3 is for a title
- In column 4 I ask it to write section 1. You can see the exact prompt I'm using below the Sheets toolbar.
- Dropping down the formulas creates an article for each keyword
I don't ask it to write all the sections because my OpenAI outputs don't exceed 500 words. It's the same in Playground or when using the API. I don't know if it's by design. If you have an idea about this, please share it.
So the idea is to write each section separately, then use a simple formula in Sheets to combine them into the articles, which we'll export to WP. But as you can see, there are some issues.
- AI doesn't respect prompts. When asked to write section 2 of the outline, it also writes other sections.
- Ends with an incomplete sentence.
- GPT for Sheets extension lags is slow and sometimes gives Error: Exceeded maximum execution time (line 0). I think this error is mitigated by reducing the token value.
- Outputs are created in Markdown format, but how to convert them to HTML when exporting the sheet to WP?
I gave you the premise. Now try to complete the project, and we'll have one of the best article generators, and we won't need to pay for content again. Share all your ideas, findings, technical solutions, and prompts here.