Blog Optimization Automation not Wrong

I have the exact same problem with this project.

I have noticed that my Openai.com Has NOT been charged for operation this task, it seems that the problem is the connection between Make and Openai site , they are not connected. 

I have added Openai's Organization number as well but still doesn't work but it confirms it's working.

• The scenario was successfully loaded.
• 1:28 PM
  Preparing scenario for running.
• 1:28 PM
  Requesting execution.
• 1:28 PM
  The request was accepted. Waiting for the server.
• 1:28 PM
  The scenario was initialized.
• 1:28 PM
  The scenario was finalized.
• 1:28 PM
  The scenario run was completed.

@cyrus1st Yes, exactly. Showing me the same.

I have exactly the same problem as you. I have double checked my API keys and open AI keys, and even regenerated them, but the Blog URL sheet is still empty.

i have  a problem when i need to run this automation , i have 404 message about chatgpt , excuse me but i'm a beginner

@kaouisgmailcom Try changing the openai model to gpt-3.5-turbo.

@nehabhoir Are you sure openai is generating and not returning an empty result? Check if your API key is valid. Use it in a simple python script. If the API key is valid and returning a response, so the problem is definitely in the authentication ur using to connect to google sheets, keep in mind that you have to edit some stuff in the google developer's console, like eabeling the API, adding the write scopes, etc...

@nehabhoir did you try to check each modules output to see where it is breaking?

check also if there is a disabled path in the routers

1st step connecting to google sheet isn't finding the correct file. I tried mapping using My Drive search by title feature and also tried changing to manually using the sheet ID. Both cases in the spreadsheet ID being returned is NOT mine.. it ends in ....NkR

Any ideas? I don't need to make the blog ulrs sheet public do I?

it is connecting to correct sheet, but not pulling in the URL from A2

@matts can you please show me the setting of the google sheet module.

from which cell it is pulling?

@admin Ok i got the sheet working but I had to remove the Filter in step 1.. checking for Status = 0. I tried entering a 0 in the status column but still didn't return any rows from the sheet. If I removed the filter from step 1, it works now..

2nd big question is... I tried to create another step to actually take my original blog content and update according to the recommendations it made during the scenario. The content didn't turn out great.. and it didn't incorporate a lot of it's own suggestions like adding a FAQ section etc.. Have you tried to add that next step of updating the original blog content? Care to share your prompt that made it work?

Finally, how can I run just that chat gpt step in the sequence and have it pull in all the dynamic data it normally gets from the sequence? It pops up an input box where it wants the text and a 2nd input content block.. 

thx.

@matts Yeah, am working on a prompt or pore precisely an AI automation that optimized the blog post, and I did some tests, and I will be sharing soon in a video.

sorry, I didn't get the last question

@admin Never mind about the last question. Looking forward to see how you add in the next Chat GPT module prompt to combine it's recommendations into the existing blog article... I tried it but the output was not good. Seems like it needs to step through it's own recommendations one by one and apply those to the existing blog content.. Otherwise it ignores most of it's own recommendations. Didn't even create a section with FAQs like it recommended. 

PS. For the section for FAQs, it should format them in schema markup.

PSS. I output the content in HTML so that it will show nicely in Google Docs with H1, H2, bold formatting...

@matts, can you add another AI layer to generate the Faqs and another layer to generate in HTML?