Adding multiple rows to Google Sheets

This is a different question from before (so thanks for putting up with me!).

I’m having trouble with the iterator.

Here’s my whole setup:

You can see from this screenshot that the data is pulling correctly (FINALLY):

In Google Sheets, it looks pretty good:

Let’s ignore the fact that there were ten and now there’s five.

Here are my iterator settings:

I’m clearly doing something wrong with the iterator, because it created five slide decks. Or rather, one slide deck, five times:
Screenshot 2024-02-16 at 5.35.47 PM

Here’s the JSON output, which looks great:

[
    {
        "posts": [
            {
                "Hook": "Studying for the CCMP exam feels like climbing Everest, barefoot.",
                "Contrarian": "It's often believed that acing this exam requires nothing but brute memorization and endless hours buried in dry material. That method is not just daunting, it's outdated.",
                "In_Reality": "Effective learning comes from understanding concepts through practice and application, not just reading.",
                "Advice": "Ditch the monotonous reading sessions. Engage with practice exams and interactive flashcards. Test your knowledge repeatedly in a real-world context. Focus on understanding the 'why' behind the answers. This approach makes learning stick and prepares you for actual decision-making.",
                "Wrap": "Unlocking CCMP success is not about memorization but understanding. Ready to try a new path?"
            },
            {
                "Hook": "Change management certifications aren't worth the paper they're printed on. Or are they?",
                "Contrarian": "The skeptic's view argues that certifications don't measure real-world skills or impact. This view, however, misses the broader picture.",
                "In_Reality": "The CCMP certification shapes understanding, validates experience, and opens professional doors.",
                "Advice": "If you're on the fence, consider the benefits beyond the certificate. The preparation expands your toolkit, enhances your credibility, and connects you with a community. Approach the exam as a milestone in a larger journey of growth and opportunity.",
                "Wrap": "Isn't it time we looked at certifications as more than just credentials?"
            },
            {
                "Hook": "Countless hours of studying - but is it really making you smarter?",
                "Contrarian": "The belief that more study time equals better exam scores is a myth that needs busting. Quality trumps quantity.",
                "In_Reality": "Focused and strategic study sessions deliver far better outcomes than marathon memorization attempts.",
                "Advice": "Break your study into targeted sessions. Focus on areas where you're weakest. Use varied materials like practice tests and flashcards to keep engagement high. Mix it up with some group studying to broaden perspectives. And don't forget to schedule regular breaks to keep your brain fresh.",
                "Wrap": "Smart studying, not hard studying, is the key to exam success."
            },
            {
                "Hook": "Thought you were too busy to fit in study time for your CCMP?",
                "Contrarian": "The common excuse of 'I don't have time' is just that, an excuse. It's not about having time, it's about making time.",
                "In_Reality": "Efficient studying can fit into any schedule, no matter how packed.",
                "Advice": "Evaluate your daily routine for pockets of unused time. Even 15-minute intervals can be golden. Utilize mobile-friendly resources to study on-the-go. Blend studying into your daily life by listening to audio materials during your commute or while exercising. Remember, consistency is crucial, not the length of study sessions.",
                "Wrap": "Transform 'I don't have time' into 'I make the most of my time'. Your CCMP is waiting."
            },
            {
                "Hook": "Fear of failure holding you back from the CCMP exam?",
                "Contrarian": "It's a natural sensation but bowing to this fear means missing out on growth opportunities. Failure is only the end if you stop trying.",
                "In_Reality": "Every attempt, successful or not, is a step forward.",
                "Advice": "Embrace a growth mindset. See each study session, each practice test, as progress. Learn from any setbacks and adjust your strategy. Surround yourself with supportive peers, and don't hesitate to seek mentorship. Remember, resilience turns potential failure into future success.",
                "Wrap": "In the face of fear, will you step back or step up?"
            },
            {
                "Hook": "Memorizing the Standards for Change Management feels like a drag.",
                "Contrarian": "Thinking you have to grind through dry material is a recipe for boredom and inefficiency. Engaging materials matter.",
                "In_Reality": "Interactive studying through questions and flashcards can transform the learning experience.",
                "Advice": "Shift your approach. Dive into practice questions that challenge and intrigue you. Use flashcards for quick, repetitive learning anywhere. Incorporate active recall and spaced repetition into your strategy. This method not only makes studying more palatable but also more effective.",
                "Wrap": "Who said studying can't be dynamic and engaging? Time to flip the script."
            },
            {
                "Hook": "Struggling with self-discipline for CCMP exam prep?",
                "Contrarian": "Self-discipline is often portrayed as the be-all and end-all. Yet, it's not just about willpower.",
                "In_Reality": "Creating a personalized study routine that aligns with your lifestyle and preferences is key.",
                "Advice": "Identify your peak productivity times and tailor your study schedule accordingly. Set small, achievable goals to foster a sense of progress. Engage with a study group or partner for accountability. Reward yourself for milestones reached to maintain motivation. Remember, discipline is developed, not innate.",
                "Wrap": "Discipline is not just driven by willpower, but by wisely structured effort."
            },
            {
                "Hook": "Think you’re too smart for practice exams?",
                "Contrarian": "Underestimating the value of practice tests is a critical mistake. They're not just about validating knowledge.",
                "In_Reality": "Practice exams are about strategy, timing, and understanding the test's structure.",
                "Advice": "Incorporate practice exams early in your study plan. Analyze your performance to identify weak areas. Don't rush through them; take time to understand why certain answers are correct. Mimic exam conditions to build test-taking stamina and reduce anxiety. This preparation goes beyond the content, sharpening your exam skills.",
                "Wrap": "The real test of intelligence? Knowing the power of practice."
            },
            {
                "Hook": "Studying for the CCMP? Don’t go it alone.",
                "Contrarian": "Solo study has its merits, but ignoring the benefits of group study is a missed opportunity.",
                "In_Reality": "Collaborative learning can offer new insights, shared resources, and moral support.",
                "Advice": "Join or form a study group with peers. Exchange practice questions and discuss concepts for deeper understanding. Utilize collaborative tools for remote study sessions. Most importantly, embrace diverse perspectives to enrich your learning experience. A problem shared is a problem halved, after all.",
                "Wrap": "The journey to CCMP certification is a shared adventure. Are you ready to join?"
            },
            {
                "Hook": "Believing you can't afford quality CCMP study materials?",
                "Contrarian": "The assumption that quality resources come with a hefty price tag is not only discouraging, it's false.",
                "In_Reality": "Affordable, high-quality study materials are within your reach.",
                "Advice": "Research beyond the most advertised options. Look for bundles that offer a variety of study tools at a reasonable price. Evaluate resources based on testimonials and free samples. Remember, investing in your education doesn't have to break the bank. Value exists—you just need to find it.",
                "Wrap": "High-quality, affordable study materials are a reality. Ready to discover them?"
            }
        ]
    }
]

Here’s the input for the iterator (clearly where this all starts to fall apart):

[
    {
        "array": [
            {
                "value": null
            },
            {
                "value": null
            },
            {
                "value": null
            },
            {
                "value": null
            },
            {
                "value": null
            }
        ]
    }
]

And the output:

[
    {
        "value": null,
        "__IMTINDEX__": 1,
        "__IMTLENGTH__": 5
    },
    {
        "value": null,
        "__IMTINDEX__": 2,
        "__IMTLENGTH__": 5
    },
    {
        "value": null,
        "__IMTINDEX__": 3,
        "__IMTLENGTH__": 5
    },
    {
        "value": null,
        "__IMTINDEX__": 4,
        "__IMTLENGTH__": 5
    },
    {
        "value": null,
        "__IMTINDEX__": 5,
        "__IMTLENGTH__": 5
    }
]

Please tell me this is a seven-second fix! Something obvious I’m not seeing?

you need to iterate through the posts array

2 Likes

OK thank you. I haven’t tried that so I’ll attempt it. Is that just the iterate module?

Turn on the MAP toggle on the Iterator and insert your Posts array.

You aren’t meant to manually insert collection properties into an iterator.

Then in your Google Sheets, reference the Iterator module, NOT the JSON module.

3 Likes

OK thank you! I will try it. FINGERS CROSSED.

ALL RIGHT!!!

That was it!

Also I needed a different data structure.

THANK YOU SO MUCH @samliew – I appreciate your help more than I can articulate.

1 Like

No problem, glad I could help!

1. If you have a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.

2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.

This marks the topic as solved, so that:

others can save time when catching up with the latest activity here, and

  • allows others to quickly jump to the solution if they come across the same problem

To do this, simply click the checkbox at the bottom of the post that answers your question:
Screenshot_2023-10-04_161049

3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!

3 Likes

Thank you for letting me know!

2 Likes