Hi,
I am building this automation that takes the content of a document and then adds and updates a row on a Google sheet. The idea here is that whenever I run an interview or an AMA, I get all the content ready for another automation to start, which will create a blog post.
I am struggling to extract the exact information of the text from ChatGPT.
Here is how it is supposed to work:
- When a document is modified in a specific folder
- That document is retrieved
- I use an aggregator so that I can have the entire body of the content in one bundle
- If within the document there is a sentence like: :STATUS: INITIATE BLOG POST", then the flow continues
- ChatGPT here is instructed to get 90% of the data
ROLE DEVELOPER / SYSTEM
### OUTPUT FORMAT
The full output should be provided within the "feedback" quotes, EXACTLY in the following JSON format:
{
"email": "",
"name": "",
"blog_type": "",
"target_audience": "",
"tone_of_voice": "",
"personal_or_brand": "",
"title": "",
"description": "",
"blog_keywords": "",
"blog_count_question": "",
"Created at": ""
}
### INSTRUCTIONS
- You need to identify where each field is (e.g. "email", "name", and so on) in the body of the document and the answer given for each field
- The fields "description" might contain long text. You need to make sure to report all of it.
- Just write the output in the given JSON format and no other sentences before or after
ROLE USER
-
I am just passing the array
{{6.array[].text}}
-
The data is then passed to a JSON parse for better classification
-
A new row is added in the Google sheet - so far so good
-
I have now another ChatGPT that is specifically looking to one field, called “extra_questions”; normally it is here where 99% of the content is (meaning the interview or the AMA)
ROLE USER
{{split(6.array[].text; "extra_questions")}}
ROLE DEVELOPER / SYSTEM
### OUTPUT FORMAT
The full output should be provided within the "feedback" quotes, EXACTLY in the following JSON format:
{
"extra_questions": ""
}
### INSTRUCTIONS
- You need to identify where the field "extra_questions" is in the body of the document and the answer given for that
- The field might contain long text. You need to make sure to extract all of it as it as
- You will not rewrite or paraphrase the content, you will simply extract it its integrity
- Just write the output in the given JSON format and no other sentences before or after
- Also here using JSON parse
- Then merging by updating a specific column of that new row on Google sheet
The problem is that the field with long text is not reported in its entirety. Never.
I tried to use 4o-mini, 4o, 4.1, 4.1 mini. No luck.
How can I retrieve the exact info, the full text? Perhaps I don’t even need to use ChatGPT for that…
And how can I optimize this flow? I am not even sure using an aggregator and a JSON parse are the right thing to do.
Blueprint attached.
Thanks!!
From AMA to Blog Post Automation_blueprint.json (118.4 KB)