Thank you.
I’ve messed with this on and off all day, and here’s where I am:
Data goes into a Google Sheet:
Data goes from a Google Sheet to an OpenAI call:
Then, everything falls to pieces. This is the output.
[
{
"id": "chatcmpl-8seQmToWR5KXVvE22dVplVW2ryVLx",
"object": "chat.completion",
"created": "2024-02-15T22:23:40.000Z",
"model": "gpt-4-0125-preview",
"choices": [
{
"index": 0,
"message": {
"role": "assistant",
"content": "```\n[\n {\n \"Hook\": \"Trading your expertise for pennies? Stop now.\",\n \"Contrarian\": \"Many believe that sharing knowledge is a quick path to diminishing returns. That's a myth rooted in outdated pricing strategies and a lack of confidence.\",\n \"In_Reality\": \"The truth is, there's a profitable demand for what you know, if you know how to package and sell it.\",\n \"Advice\": \"Focus on identifying your unique proposition. Package your knowledge into digestible products or courses. Use strategic marketing to target your ideal clientele. Confidence in your expertise is key.\",\n \"Wrap\": \"It's not about selling time; it's about monetizing wisdom. Ready to shift gears?\"\n },\n {\n \"Hook\": \"Think an MBA is necessary to succeed? Think again.\",\n \"Contrarian\": \"The belief that formal qualifications are the only path to success is not only daunting but inaccurate. It's about understanding your value, not your diploma.\",\n \"In_Reality\": \"Expertise and real-world solutions are more valuable than ever in today’s market.\",\n \"Advice\": \"Leverage what you know now. Start small, think big. Focus on solving problems for your target audience and let your results speak for themselves.\",\n \"Wrap\": \"Your expertise is your degree. Are you ready to graduate to success?\"\n },\n {\n \"Hook\": \"90% of experts are missing out on big money.\",\n \"Contrarian\": \"Many experts undercharge, thinking it'll lead to more clients. Wrong. It leads to burnout and low-value perceptions.\",\n \"In_Reality\": \"Higher rates attract more serious clients and emphasize the value of your expertise.\",\n \"Advice\": \"Evaluate your pricing. Understand your value. Start charging what you're truly worth. Remember, it's not about the quantity of clients, but the quality.\",\n \"Wrap\": \"Elevate your rates, elevate your business. Ready for the leap?\"\n },\n {\n \"Hook\": \"Passive income a game for few? Not anymore.\",\n \"Contrarian\": \"The idea that passive income streams are inaccessible or complicated is rooted in fear and misunderstanding. The barrier isn't as high as you think.\",\n \"In_Reality\": \"With the right knowledge and tools, anyone can build passive income streams around their expertise.\",\n \"Advice\": \"Identify what you can offer that people would pay for repeatedly. Create digital products, courses, or subscriptions. Set up systems for sales and marketing automation.\",\n \"Wrap\": \"Unlocking passive income is a matter of strategy. Ready to strategize?\"\n },\n {\n \"Hook\": \"Struggling to profit from your passion? Here's why.\",\n \"Contrarian\": \"If you're passionate but not profitable, it's likely because you're not positioning and packaging your expertise effectively, not because your passion isn't valuable.\",\n \"In_Reality\": \"Profit comes from recognizing the unique value you offer and communicating it clearly to those in need.\",\n \"Advice\": \"Define your niche. Create clear, compelling offers that solve specific problems. Communicate your unique value through storytelling.\",\n \"Wrap\": \"Turn passion into profit by clarifying your value. Shall we begin?\"\n },\n {\n \"Hook\": \"Your big career break is closer than you think.\",\n \"Contrarian\": \"Many await an external change to revolutionize their careers. In reality, the change needed is within, particularly in how you leverage your expertise.\",\n \"In_Reality\": \"You have the power to transform your career by turning your knowledge into a profitable business.\",\n \"Advice\": \"Start by understanding the market need for your expertise. Build an offering that stands out. Utilize digital tools to reach and serve your audience.\",\n \"Wrap\": \"Your next career breakthrough starts with you. Ready to take the first step?\"\n },\n {\n \"Hook\": \"Tired of one-time gigs? Let's talk sustainability.\",\n \"Contrarian\": \"Relying solely on freelance projects can feel like a never-ending hustle. The real issue? Not creating assets that work for you.\",\n \"In_Reality\": \"Building resources or products from your expertise can provide consistent revenue over time.\",\n \"Advice\": \"Consider creating online courses, writing ebooks, or starting a subscription service related to your field. Leverage existing content and knowledge.\",\n \"Wrap\": \"Shift from gig seeker to asset creator. Intrigued?\"\n },\n {\n \"Hook\": \"Feeling stuck in your expert journey? You're not alone.\",\n \"Contrarian\": \"Most experts hit a wall not because of a lack of knowledge, but because of a lack of clarity and marketing know-how.\",\n \"In_Reality\": \"Success hinges on your ability to package, position, and market your expertise effectively.\",\n \"Advice\": \"Narrow down your niche. Develop clear, compelling messaging. Learn basic marketing to reach and resonate with your audience.\",\n \"Wrap\": \"Clarity and marketing are your best allies. Time to team up?\"\n },\n {\n \"Hook\": \"Why smart experts still struggle financially.\",\n \"Contrarian\": \"It's a common misconception that knowledge automatically translates to wealth. Without the right framework, even the smartest experts flounder.\",\n \"In_Reality\": \"Wealth comes from applying your knowledge within a proven system designed to monetize your expertise.\",\n \"Advice\": \"Embrace systems thinking. Focus on building scalable, repeatable processes for generating income from your knowledge. Stay adaptable.\",\n \"Wrap\": \"Expertise + System = Wealth. Ready to calculate your formula?\"\n },\n {\n \"Hook\": \"Dream clients don't know you exist? Fix that now.\",\n \"Contrarian\": \"The myth that good work alone will attract your ideal clients leaves many experts invisible to those they can best serve.\",\n \"In_Reality\": \"Attracting dream clients requires intentional positioning and marketing that speaks directly to their needs.\",\n \"Advice\": \"Define your ideal client in detail. Craft messaging that addresses their specific pain points and desires. Utilize targeted marketing channels.\",\n \"Wrap\": \"Become irresistible to your dream clients. Ready to shine?\"\n }\n]\n```"
},
"logprobs": null,
"finish_reason": "stop"
}
],
"usage": {
"prompt_tokens": 3049,
"completion_tokens": 1283,
"total_tokens": 4332
},
"system_fingerprint": "fp_f084bcfc79"
}
]
I ran it through a “is this JSON broken?” checker, and it came back fine. Not broken.
But I can’t parse it.
So I send it through the JSON parser.
And I get an error.
Somehow it is not JSON, according to make.com.
I tried stripping the quotation mark things, and that still didn’t get recognized as JSON.
I’ve done this with HTML, with comma delimited strings, with pipe (|) delimited strings, and I can’t get past this part.
What now?