Google Sheets to Chatgpt to PDF creation not working

Hi Team
Hope you’re doing great!

I have created a pretty simple scenario for Chapter Book creation as follows:
Google Sheets > Chatgpt > Markdown > PDF creation
(screenshot attached for reference)

I can see that the output is being generated from chatgpt module (screenshot attached for reference) -

However, the markup module does not have any data (screenshot attached for reference) -
There is no error, but, there is also no output!

Can you please share any pointers to help me out?

Thanks!

Looks like only a single # is inserted into the Markdown module.

1. Screenshots of module fields

Please share screenshots of relevant module fields? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:

2. Scenario blueprint

Please export the scenario blueprint file to allow others to view the mapped variables in the module fields. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.


(Note: Exporting your scenario will not include private information or keys to your connections)

Uploading it here will look like this:

blueprint.json (12.3 KB)

Following these steps will allow others to assist you here. Thanks!

Thanks Sam!

Yes, I had added only one single # to the markup based on the reason that the whole chatgpt output is in one part (OUTPUT > Bundle 1 > Result) of chatgpt module.

Attaching the export blue print document
blueprint.json (93.3 KB)
for reference -

Thank You!!

You should not add additional markup to the Markdown module, because the output from OpenAI already includes markup, as seen in your second screenshot. What do you think a # does? It means that line is a header. By adding additional things to the Markdown you may be making it invalid.

This field should probably just contain the 2.Result variable.

I can’t run the scenario because I don’t have example Google Forms output.

If you need further assistance, please provide the following:

Please provide the output bundles of the FIRST TWO modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.

A.

Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

B.

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles in this manner:

Here are two ways to format text so that it won’t be changed by the forum:

A. Type code block manually
Add three backticks ``` before and after the content/bundle, like this:

```
content goes here
```

B. Highlight and click the format button in the editor

Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

This will allow others to better assist you. Thanks!

Hi Sam,
Thank you for helping me out!

Please find below ouput details for reference:
Google-form-output-bundle

[
    null
]

chatgpt-output-bundle

[
    {
        "result": "# Custom Wellness Plan for YOU: Unlocking Your Full Potential\n\n## Chapter 1: Physical Wellness – Your Body, Your Temple\n\nIn the journey towards optimal physical wellness, it's essential to recognize that your body is not just a vessel; it's a sacred temple that houses your spirit. You have the power to transform it into a powerhouse of health. Remember, \"The only limit to your impact is your imagination and commitment.\" - Tony Robbins.\n\n### Setting Your Vision\n\nBegin by envisioning what physical wellness means to you. Perhaps it’s losing weight, gaining muscle, or simply moving more efficiently through your day. Whatever it is, hold onto this vision tightly as it will guide your actions. \n\n### Action Steps to Reach a Level 5\n\n1. **Assessment:** Start by conducting a self-assessment of your current physical health. This includes noting your weight, measurements, and fitness level. \n2. **Set SMART Goals:** Create Specific, Measurable, Achievable, Relevant, and Time-bound goals. This gives you clarity and a roadmap to reach your destination.\n3. **Create a Routine:** Design a balanced fitness regimen that includes strength training, cardiovascular workout, and flexibility exercises. Aim for at least 150 minutes of moderate-intensity cardio each week, combined with strength training twice a week.\n4. **Nutrition Focus:** Fuel your body with nutritious food. Embrace a diet filled with whole foods, lean proteins, healthy fats, and lots of colorful fruits and vegetables. Remember, \"The right diet can change your life.\"\n5. **Stay Hydrated:** Water is your body’s elixir! Aim for at least 8 cups of water daily and keep yourself hydrated, especially during workouts.\n\n### Motivational Section\n\nCelebrate every small victory! \"Success is the result of perfection, hard work, learning from failure, loyalty, and persistence.\" - Colin Powell. Share your progress with a friend or social media for accountability, and let those small wins elevate your spirit!\n\n---\n\n## Chapter 2: Mental Wellness – Sculpting Your Mind\n\nYour mind is a powerful tool – it can either propel you forward or hold you back. Embrace the power of your thoughts! \"The way we communicate with others and with ourselves ultimately determines the quality of our lives.\"\n\n### Achieving Mental Clarity \n\nTo enhance your mental wellness, let go of limiting beliefs and embrace a mindset of abundance. \n\n### Action Steps to Reach a Level 5\n\n1. **Mindfulness Practices:** Incorporate meditation or journaling into your daily routine to decrease stress and enhance mental clarity.\n2. **Limit Toxic Influences:** Be aware of your inputs; limit exposure to negativity, whether from people, news, or social media.\n3. **Continuous Learning:** Engage in lifelong learning – read books, attend workshops, or take online courses that kindle your curiosity.\n4. **Professional Support:** If needed, consider consulting with a mental health professional for guidance and support.\n5. **Gratitude Practice:** Cultivate gratitude by writing down three things you’re grateful for every day. This simple practice can radically shift your mindset.\n\n### Motivational Section\n\n“Your life changes the moment you make a new, congruent, and committed decision.” Celebrate your mental growth by acknowledging every positive thought that nourishes your inner strength!\n\n---\n\n## Chapter 3: Spiritual Wellness – Connecting with Your Inner Self\n\nWhat is your ‘why’? Understanding your purpose is critical for spiritual wellness. \"You can’t understand where you’re going until you understand where you’ve been.\" \n\n### Deep Dive into Your Spirituality\n\nExploring spiritual wellness opens a pathway to your inner self. \n\n### Action Steps to Reach a Level 5\n\n1. **Reflection Time:** Schedule quiet time to meditate, pray, or reflect on your life’s purpose.\n2. **Nature Connection:** Spend time outdoors. Nature rejuvenates the spirit and brings clarity.\n3. **Volunteering:** Giving back enriches your soul and fosters connection with others.\n4. **Mindful Practices:** Engage in yoga or tai chi to connect your mind, body, and spirit.\n5. **Read Inspirational Texts:** Books, scriptures, or quotes that resonate with your spiritual journey provide insight and encouragement.\n\n### Motivational Section\n\n“Follow your bliss and the universe will open doors where there were only walls.” Trust the process and let your spiritual path unfold. \n\n---\n\n## Chapter 4: Emotional Wellness – Mastering Your Emotions\n\nYour emotions are signposts on the highway of life. \"Emotion is created by motion,\" so take that leap towards mastering your feelings! \n\n### Building Emotional Intelligence\n\nEmotional wellness involves understanding, feeling, and expressing your emotions appropriately.\n\n### Action Steps to Reach a Level 5\n\n1. **Self-Awareness:** Practice recognizing your emotions in real-time. What triggers feelings of joy or frustration?\n2. **Healthy Expression:** Find constructive ways to express emotions – whether talking, writing, or engaging in art.\n3. **Cultivate Empathy:** Understand the emotions of others and respond with kindness and compassion.\n4. **Boundaries:** Set healthy emotional boundaries. It’s okay to say ‘no’ when it drains your energy.\n5. **Seek Support:** Join support groups or talk to a therapist if you need guidance through emotional challenges.\n\n### Motivational Section\n\n“Change happens when the pain of staying the same is greater than the pain of change.” Embrace your emotional wellness and watch your life transform!\n\n---\n\n## Chapter 5: Customized Growth – Your Unique Path to Wellness\n\nEvery journey is unique; tailor this chapter to your personal growth in emotional wellness. \n\n### Your Personalized Action Steps\n\n1. **Identify Your Emotional Triggers:** Create a list of triggers and practice how to respond constructively.\n2. **Develop a Support Network:** Identify friends, family, or mentors you can turn to when you need support.\n3. **Engage in Healthy Coping Mechanisms:** Explore hobbies or activities you love to reduce stress and enhance happiness.\n4. **Practice Daily Affirmations:** Affirmations can reshape your mindset. Say them out loud – believe them!\n5. **Reflect Regularly:** Weekly, take time to assess your emotional health. What obstacles or achievements did you experience?\n\n### Motivational Section\n\n“Your past does not equal your future.” Every moment is a chance to change, to grow, and to embrace the exuberance of life!\n\n---\n\n## Chapter 6: Overall Wellness – One Step at a Time\n\nTrue wellness encompasses physical, mental, spiritual, and emotional dimensions. Balance is your key. \"Success is doing what you love and being where you want to be.\"\n\n### Comprehensive Action Steps\n\n1. **Holistic Approach:** Incorporate elements from each chapter into a daily routine that suits you.\n2. **Mindful Progress:** Remember that wellness is a marathon, not a sprint. Celebrate progress, no matter how small.\n3. **Track Your Journey:** Utilize journals or apps to keep track of your development and insights.\n4. **Community Connection:** Build connections with others who share your wellness goals. Support each other!\n5. **Adapt and Adjust:** Regularly revisit and tweak your plan as needed; wellness is a dynamic journey.\n\n### Inspirational Section\n\n“Taking small, persistent steps in the right direction can lead to incredible transformation.” Slow and steady progress will create lasting change.\n\n---\n\n## Disclaimer \n\nThis wellness plan serves as a guide and may need personalization or expert consultation. Achieving physical wellness may require consultation with a medical doctor before following the steps detailed herein. For further support or feedback on your journey, please reach out at ezpzrun@gmail.com. \n\nBreathe deeply, take action, and let your journey unfold before you! You've got this!",
        "id": "chatcmpl-9sONKb4HRj3rLRtozjAvrveA7ivVG",
        "object": "chat.completion",
        "created": "2024-08-04T05:47:18.000Z",
        "model": "gpt-4o-mini-2024-07-18",
        "choices": [
            {
                "index": 0,
                "message": {
                    "role": "assistant",
                    "content": "# Custom Wellness Plan for YOU: Unlocking Your Full Potential\n\n## Chapter 1: Physical Wellness – Your Body, Your Temple\n\nIn the journey towards optimal physical wellness, it's essential to recognize that your body is not just a vessel; it's a sacred temple that houses your spirit. You have the power to transform it into a powerhouse of health. Remember, \"The only limit to your impact is your imagination and commitment.\" - Tony Robbins.\n\n### Setting Your Vision\n\nBegin by envisioning what physical wellness means to you. Perhaps it’s losing weight, gaining muscle, or simply moving more efficiently through your day. Whatever it is, hold onto this vision tightly as it will guide your actions. \n\n### Action Steps to Reach a Level 5\n\n1. **Assessment:** Start by conducting a self-assessment of your current physical health. This includes noting your weight, measurements, and fitness level. \n2. **Set SMART Goals:** Create Specific, Measurable, Achievable, Relevant, and Time-bound goals. This gives you clarity and a roadmap to reach your destination.\n3. **Create a Routine:** Design a balanced fitness regimen that includes strength training, cardiovascular workout, and flexibility exercises. Aim for at least 150 minutes of moderate-intensity cardio each week, combined with strength training twice a week.\n4. **Nutrition Focus:** Fuel your body with nutritious food. Embrace a diet filled with whole foods, lean proteins, healthy fats, and lots of colorful fruits and vegetables. Remember, \"The right diet can change your life.\"\n5. **Stay Hydrated:** Water is your body’s elixir! Aim for at least 8 cups of water daily and keep yourself hydrated, especially during workouts.\n\n### Motivational Section\n\nCelebrate every small victory! \"Success is the result of perfection, hard work, learning from failure, loyalty, and persistence.\" - Colin Powell. Share your progress with a friend or social media for accountability, and let those small wins elevate your spirit!\n\n---\n\n## Chapter 2: Mental Wellness – Sculpting Your Mind\n\nYour mind is a powerful tool – it can either propel you forward or hold you back. Embrace the power of your thoughts! \"The way we communicate with others and with ourselves ultimately determines the quality of our lives.\"\n\n### Achieving Mental Clarity \n\nTo enhance your mental wellness, let go of limiting beliefs and embrace a mindset of abundance. \n\n### Action Steps to Reach a Level 5\n\n1. **Mindfulness Practices:** Incorporate meditation or journaling into your daily routine to decrease stress and enhance mental clarity.\n2. **Limit Toxic Influences:** Be aware of your inputs; limit exposure to negativity, whether from people, news, or social media.\n3. **Continuous Learning:** Engage in lifelong learning – read books, attend workshops, or take online courses that kindle your curiosity.\n4. **Professional Support:** If needed, consider consulting with a mental health professional for guidance and support.\n5. **Gratitude Practice:** Cultivate gratitude by writing down three things you’re grateful for every day. This simple practice can radically shift your mindset.\n\n### Motivational Section\n\n“Your life changes the moment you make a new, congruent, and committed decision.” Celebrate your mental growth by acknowledging every positive thought that nourishes your inner strength!\n\n---\n\n## Chapter 3: Spiritual Wellness – Connecting with Your Inner Self\n\nWhat is your ‘why’? Understanding your purpose is critical for spiritual wellness. \"You can’t understand where you’re going until you understand where you’ve been.\" \n\n### Deep Dive into Your Spirituality\n\nExploring spiritual wellness opens a pathway to your inner self. \n\n### Action Steps to Reach a Level 5\n\n1. **Reflection Time:** Schedule quiet time to meditate, pray, or reflect on your life’s purpose.\n2. **Nature Connection:** Spend time outdoors. Nature rejuvenates the spirit and brings clarity.\n3. **Volunteering:** Giving back enriches your soul and fosters connection with others.\n4. **Mindful Practices:** Engage in yoga or tai chi to connect your mind, body, and spirit.\n5. **Read Inspirational Texts:** Books, scriptures, or quotes that resonate with your spiritual journey provide insight and encouragement.\n\n### Motivational Section\n\n“Follow your bliss and the universe will open doors where there were only walls.” Trust the process and let your spiritual path unfold. \n\n---\n\n## Chapter 4: Emotional Wellness – Mastering Your Emotions\n\nYour emotions are signposts on the highway of life. \"Emotion is created by motion,\" so take that leap towards mastering your feelings! \n\n### Building Emotional Intelligence\n\nEmotional wellness involves understanding, feeling, and expressing your emotions appropriately.\n\n### Action Steps to Reach a Level 5\n\n1. **Self-Awareness:** Practice recognizing your emotions in real-time. What triggers feelings of joy or frustration?\n2. **Healthy Expression:** Find constructive ways to express emotions – whether talking, writing, or engaging in art.\n3. **Cultivate Empathy:** Understand the emotions of others and respond with kindness and compassion.\n4. **Boundaries:** Set healthy emotional boundaries. It’s okay to say ‘no’ when it drains your energy.\n5. **Seek Support:** Join support groups or talk to a therapist if you need guidance through emotional challenges.\n\n### Motivational Section\n\n“Change happens when the pain of staying the same is greater than the pain of change.” Embrace your emotional wellness and watch your life transform!\n\n---\n\n## Chapter 5: Customized Growth – Your Unique Path to Wellness\n\nEvery journey is unique; tailor this chapter to your personal growth in emotional wellness. \n\n### Your Personalized Action Steps\n\n1. **Identify Your Emotional Triggers:** Create a list of triggers and practice how to respond constructively.\n2. **Develop a Support Network:** Identify friends, family, or mentors you can turn to when you need support.\n3. **Engage in Healthy Coping Mechanisms:** Explore hobbies or activities you love to reduce stress and enhance happiness.\n4. **Practice Daily Affirmations:** Affirmations can reshape your mindset. Say them out loud – believe them!\n5. **Reflect Regularly:** Weekly, take time to assess your emotional health. What obstacles or achievements did you experience?\n\n### Motivational Section\n\n“Your past does not equal your future.” Every moment is a chance to change, to grow, and to embrace the exuberance of life!\n\n---\n\n## Chapter 6: Overall Wellness – One Step at a Time\n\nTrue wellness encompasses physical, mental, spiritual, and emotional dimensions. Balance is your key. \"Success is doing what you love and being where you want to be.\"\n\n### Comprehensive Action Steps\n\n1. **Holistic Approach:** Incorporate elements from each chapter into a daily routine that suits you.\n2. **Mindful Progress:** Remember that wellness is a marathon, not a sprint. Celebrate progress, no matter how small.\n3. **Track Your Journey:** Utilize journals or apps to keep track of your development and insights.\n4. **Community Connection:** Build connections with others who share your wellness goals. Support each other!\n5. **Adapt and Adjust:** Regularly revisit and tweak your plan as needed; wellness is a dynamic journey.\n\n### Inspirational Section\n\n“Taking small, persistent steps in the right direction can lead to incredible transformation.” Slow and steady progress will create lasting change.\n\n---\n\n## Disclaimer \n\nThis wellness plan serves as a guide and may need personalization or expert consultation. Achieving physical wellness may require consultation with a medical doctor before following the steps detailed herein. For further support or feedback on your journey, please reach out at ezpzrun@gmail.com. \n\nBreathe deeply, take action, and let your journey unfold before you! You've got this!"
                },
                "logprobs": null,
                "finish_reason": "stop"
            }
        ],
        "usage": {
            "prompt_tokens": 357,
            "completion_tokens": 1564,
            "total_tokens": 1921
        },
        "system_fingerprint": "fp_9b0abffe81"
    }
]

Markup-output-bundle

[
    {
        "data": "<html><head></head><body><h1 id=\"\"></h1>\n</body></html>"
    }
]

Please let me know if further details are needed from me?

Thanks!!

By using just the Result variable, I get the HTML as output

Output

Then, in your PDF module, you do not need any HTML tags, because the Markdown module already can output a full HTML page.

Hope this helps! Let me know if there are any further questions or issues.

@samliew

1 Like

Thank you for your quick response Sam!!

I used only “Result” in Make module now -

Also, removed the HTML tags in PDF module -

However, the PDF file is still empty!

Please find below output bundle from Markdown module for reference -

[
    {
        "data": ""
    }
]

Please let me know if further details are needed.

Thank you!!!

You still need to leave the HTML variable in the Input HTML Code field, not leave it completely empty!

See my screenshot above.

1 Like

Thanks for support Sam!!

After adding the HTML variable in the HTML Code field, something changed (I think its one step closer now).
Getting a new error “BundleValidationError” at PDF generator module -

Please let me know if further details are needed.

Thank you!!

Hi Team,

Hope you’re doing great.

Can please help me with any pointers?

Thanks!

How are you doing it now? Please upload as many relevant screenshots as possible whenever you make a change.

To allow us to assist you with your scenario, please provide the following:

1. Relevant Screenshots

Please share screenshots of your scenario, any error messages, relevant module fields, and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:

1 Like

Hi Sam,

Thank you for checking!
Sorry for delayed reply.

Looks like the issue is happening either at the Markup module or at the PDF module.
I am not able to debug this part - about which module has the issue.

Please find attached screenshots of markup and pdf modules along with the blueprint json file.

Please let me know if any more details are needed?

Thanks!



blueprint-new.json (93.1 KB)

  • What is the value of 2.result?

  • What is the output bundle of Markdown to HTML?

Hi Sam,

Thank you for checking!

Can please let me know how to get the following?:

  • What is the value of 2.result?
  • What is the output bundle of Markdown to HTML?

Please find below screenshot of settings options for Markdown module -

Not able to see an option to view 2.result !

Thanks!

Hi @EasyPeasyRun,

2.result is the result of the ChatGPT request.

To get the output bundle of any module, run your scenario, then click on the bubble with the number and click on “Download Output Bundle.”

It’s what @samliew explains here:

You might also want to see this lesson in the Make Academy:

https://academy.make.com/courses/take/BasicsC01/multimedia/41089500-unit-6-introduction-to-bundles

L

Thank you for the reply and academy link Sam!

I see only 1 bubble after the Google Forms module -

So, I am thinking that issue at Chatgpt module.

Will go through the documentation and then reply back.

Thanks!

Polling Triggers & Empty “Check Runs”

This is because the module is a POLLING trigger, and not an INSTANT (Webhook) trigger.

If you don’t see any operations after the trigger module, it means there are no new responses (empty output bundle) when the scenario ran to check for new items. This is called a “Check run”.

There are two main types of triggers, Polling (scheduled), and Instant (webhooks). Polling triggers can only run on a schedule. Instant triggers can be run as soon as data is received by the webhook.

  • Polling means Make checks external service for changes (pull changes to Make).
  • Webhook (instant) triggers means external service calls Make when there are new changes (push changes to Make).

The module you are using does not push changes — it’s basically a API request that Make has to occasionally “call” to fetch the latest changes/items.

To find out more on the different types of Trigger modules, see refer to Types of Modules and Webhooks sections of the Make Help Centre.

If you want your scenario to only run when there is new data (and not on a schedule or timed interval), see if your app has an “Instant” or “Webhook” trigger in Make. If not, check if the third-party service has a feature that can send out a webhook when content is created/updated - and then you can point it to a “Custom Webhook” trigger in your scenario.

If you want to re-run your scenario on older data,

Polling Triggers: Epoch Panel & Selecting Older Data

Go to the Epoch Panel, by right-clicking on the trigger module (polling triggers only), and select “Choose where to start” from the list of options in the context menu.

If you select “From now on”, the next time the scenario runs it will only return new data (or nothing if there is no new data).

You can also select other old data to re-run your scenario with next using the “Choose manually” option. This will then show you a list of previous historical items you can select to process the next time the scenario is triggered.

For more information, see

Hope this helps! Let me know if there are any further questions or issues.

@samliew

Hi Sam,

Thank you for taking time to reply!
Appreciate your patience !!

I was able to change the setting on Google Forms module and now can see the output after the chatgpt module :slight_smile:

However, when I try to run the Markdown module, it asks for the “Result” field to be entered manually -

This value should be coming in from the “Result” value from previous (chatgpt) module actually.

Any pointers to enter this value for “Result” field will help me please ?

Thanks!

Yes, run the full scenario, not just that module.

Thanks Sam!!
Its working now :slightly_smiling_face:

Thank you!!