How can I have make.com work with multiple sheets in a single Google spreadsheet?

Here’s what I’m trying to do:

  1. Have make.com watch for a new row in Sheet 1 (blog topic ideas)
  2. Input the idea to ChatGPT, which will generate ten eye-catching blog titles based on the prompt along with an identified “Target Audience,” “Pain Point,” and “Dominant Emotion.”
  3. The prompt’s output would be added to Sheet 2 in the same spreadsheet. The title would go into column A, the Target Audience to column B, the Pain Point to column C, and the Dominant Emotion to column D.
  4. Since each Blog Topic Idea will generate 10 titles = 10 rows. I’m not sure how to proceed. Would I use the Sheets Bulk Add Rows module or something else?

Any ideas are very welcome! I’m very keen to find out!

Thanks,
Shawn

Hi @Shawn_Soszka
Utilize the “Watch New Row” module to trigger when a new row is added to the sheet. Then, use the ChatGPT module to generate ten compelling blog titles based on the prompt, along with an identified “Target Audience,” “Pain Point,” and “Dominant Emotion” by mapping the topic idea from the sheet. Request ChatGPT to return the results in a JSON format, with each row’s value structured as a collection. Afterward, use the “Add a Row” module to insert each collection back into the sheet. If you need further help, don’t hesitate to reach out!

Best regards,

Msquare Automation
platinum Partner of Make
@Msquare_Automation

Wow, thanks for your response. It totally makes sense to have the ChatGPT prompt do all the work! When setting up the last “Add Row” module, is any special setup required to input the JSON data?

Hi @Shawn_Soszka
Yes, if you request ChatGPT to provide the response in a JSON structure with a sample format and set response type as follows , you’ll be able to map the values directly from ChatGPT

Best regards,

Msquare Automation
platinum Partner of Make
@Msquare_Automation

Hello! I don’t want to be a nuisance, but the scenario isn’t working, and I have 2-3 questions.

Here’s my setup so far. Does this look right?

  1. In the filter between the ChatGPT and Add Row Modules, I understand that I have to add the parsed JSON output in the condition field. But do I need to add anything to the “Text Operators: Equal to” field?

  2. Finally, I have my Add a Row module set up like this:

Hi @Shawn_Soszka
If you can share the output bundle of chatgpt module we could further assist you.

Best regards,

Msquare Automation
platinum of Make
@Msquare_Automation

Here’s the output bundle:

[
    {
        "result": {
            "headlines": [
                {
                    "headline": "How to Spot Hidden Thyroid Issues Without Missing a Beat",
                    "target_audience": "Healthcare practitioners",
                    "pain_point": "Overlooking thyroid problems due to time constraints",
                    "dominant_emotion": "Frustration"
                },
                {
                    "headline": "7 Eye-Opening Signs of Thyroid Problems You Might Be Missing",
                    "target_audience": "General public",
                    "pain_point": "Not recognizing signs of thyroid issues",
                    "dominant_emotion": "Curiosity"
                },
                {
                    "headline": "13 Shocking Facts About Thyroid Health Every Doctor Should Know",
                    "target_audience": "Doctors and specialists",
                    "pain_point": "Lack of awareness about lesser-known thyroid facts",
                    "dominant_emotion": "Surprise"
                },
                {
                    "headline": "How to Detect Thyroid Disorders in 5 Minutes Without Stress",
                    "target_audience": "Busy healthcare providers",
                    "pain_point": "Limited time for comprehensive diagnosis",
                    "dominant_emotion": "Anxiety"
                },
                {
                    "headline": "7 Simple Steps to Accurately Identify Thyroid Irregularities",
                    "target_audience": "General physicians and nurses",
                    "pain_point": "Difficulty in diagnosing thyroid issues accurately",
                    "dominant_emotion": "Doubt"
                },
                {
                    "headline": "7 Crucial Tips for Uncovering Thyroid Problems Early",
                    "target_audience": "Healthcare practitioners",
                    "pain_point": "Missing early signs of thyroid disorders",
                    "dominant_emotion": "Concern"
                },
                {
                    "headline": "15 Hidden Thyroid Disorders That Could Be Affecting Your Patients",
                    "target_audience": "Healthcare professionals",
                    "pain_point": "Overlooking less obvious thyroid problems in patients",
                    "dominant_emotion": "Worry"
                },
                {
                    "headline": "How to Be a Thyroid Detective and Relieve Patient Suffering",
                    "target_audience": "Endocrinologists and general practitioners",
                    "pain_point": "Inability to diagnose thyroid issues effectively",
                    "dominant_emotion": "Determination"
                },
                {
                    "headline": "7 Astonishing Ways to Enhance Your Thyroid Diagnostic Skills",
                    "target_audience": "Healthcare educators and trainers",
                    "pain_point": "Insufficient training in thyroid diagnosis",
                    "dominant_emotion": "Hope"
                },
                {
                    "headline": "7 Underrated Symptoms of Thyroid Disorders Every GP Should Know",
                    "target_audience": "General practitioners",
                    "pain_point": "Lack of knowledge about subtle thyroid symptoms",
                    "dominant_emotion": "Interest"
                }
            ]
        },
        "id": "chatcmpl-AM76vUsXMaEHHVMrCjZJEc3NUORbV",
        "object": "chat.completion",
        "created": "2024-10-25T05:25:13.000Z",
        "model": "gpt-4o-2024-08-06",
        "choices": [
            {
                "index": 0,
                "message": {
                    "role": "assistant",
                    "content": "{\n    \"headlines\": [\n        {\n            \"headline\": \"How to Spot Hidden Thyroid Issues Without Missing a Beat\",\n            \"target_audience\": \"Healthcare practitioners\",\n            \"pain_point\": \"Overlooking thyroid problems due to time constraints\",\n            \"dominant_emotion\": \"Frustration\"\n        },\n        {\n            \"headline\": \"7 Eye-Opening Signs of Thyroid Problems You Might Be Missing\",\n            \"target_audience\": \"General public\",\n            \"pain_point\": \"Not recognizing signs of thyroid issues\",\n            \"dominant_emotion\": \"Curiosity\"\n        },\n        {\n            \"headline\": \"13 Shocking Facts About Thyroid Health Every Doctor Should Know\",\n            \"target_audience\": \"Doctors and specialists\",\n            \"pain_point\": \"Lack of awareness about lesser-known thyroid facts\",\n            \"dominant_emotion\": \"Surprise\"\n        },\n        {\n            \"headline\": \"How to Detect Thyroid Disorders in 5 Minutes Without Stress\",\n            \"target_audience\": \"Busy healthcare providers\",\n            \"pain_point\": \"Limited time for comprehensive diagnosis\",\n            \"dominant_emotion\": \"Anxiety\"\n        },\n        {\n            \"headline\": \"7 Simple Steps to Accurately Identify Thyroid Irregularities\",\n            \"target_audience\": \"General physicians and nurses\",\n            \"pain_point\": \"Difficulty in diagnosing thyroid issues accurately\",\n            \"dominant_emotion\": \"Doubt\"\n        },\n        {\n            \"headline\": \"7 Crucial Tips for Uncovering Thyroid Problems Early\",\n            \"target_audience\": \"Healthcare practitioners\",\n            \"pain_point\": \"Missing early signs of thyroid disorders\",\n            \"dominant_emotion\": \"Concern\"\n        },\n        {\n            \"headline\": \"15 Hidden Thyroid Disorders That Could Be Affecting Your Patients\",\n            \"target_audience\": \"Healthcare professionals\",\n            \"pain_point\": \"Overlooking less obvious thyroid problems in patients\",\n            \"dominant_emotion\": \"Worry\"\n        },\n        {\n            \"headline\": \"How to Be a Thyroid Detective and Relieve Patient Suffering\",\n            \"target_audience\": \"Endocrinologists and general practitioners\",\n            \"pain_point\": \"Inability to diagnose thyroid issues effectively\",\n            \"dominant_emotion\": \"Determination\"\n        },\n        {\n            \"headline\": \"7 Astonishing Ways to Enhance Your Thyroid Diagnostic Skills\",\n            \"target_audience\": \"Healthcare educators and trainers\",\n            \"pain_point\": \"Insufficient training in thyroid diagnosis\",\n            \"dominant_emotion\": \"Hope\"\n        },\n        {\n            \"headline\": \"7 Underrated Symptoms of Thyroid Disorders Every GP Should Know\",\n            \"target_audience\": \"General practitioners\",\n            \"pain_point\": \"Lack of knowledge about subtle thyroid symptoms\",\n            \"dominant_emotion\": \"Interest\"\n        }\n    ]\n}",
                    "refusal": null
                },
                "logprobs": null,
                "finish_reason": "stop"
            }
        ],
        "usage": {
            "prompt_tokens": 265,
            "completion_tokens": 591,
            "total_tokens": 856,
            "prompt_tokens_details": {
                "cached_tokens": 0
            },
            "completion_tokens_details": {
                "reasoning_tokens": 0
            }
        },
        "system_fingerprint": "fp_45c6de4934"
    }
]

Hi @Shawn_Soszka

Iterate through the headlines array and map values from iterator module to add a row module

Best regards,

Msquare Automation
Platinum Partner of Make
@Msquare_Automation

Hello!

First, thank you so very much for all your help; the technology is impressive, but your willingness to help me out is truly amazing!

So, I set up the scenario as you suggested, and the flow goes as far as Interator but doesn’t move on the last module, “Add a Row.” Looking at the output, it appears the Interator received no data from Chat GPT.

Here’s the ChatGPT output bundle:

[
    {
        "result": {
            "headline": "How to Manage Hashimoto’s with Gluten-Free Choices",
            "target_audience": "Individuals with Hashimoto's Thyroiditis",
            "pain_point": "Finding effective dietary strategies",
            "dominant_emotion": "Frustration"
        },
        "id": "chatcmpl-AMT9o7Fke9vcgtUw70y5y5u9Eohy9",
        "object": "chat.completion",
        "created": "2024-10-26T04:57:40.000Z",
        "model": "gpt-4o-2024-08-06",
        "choices": [
            {
                "index": 0,
                "message": {
                    "role": "assistant",
                    "content": "{\n    \"headline\": \"How to Manage Hashimoto’s with Gluten-Free Choices\",\n    \"target_audience\": \"Individuals with Hashimoto's Thyroiditis\",\n    \"pain_point\": \"Finding effective dietary strategies\",\n    \"dominant_emotion\": \"Frustration\"\n}",
                    "refusal": null
                },
                "logprobs": null,
                "finish_reason": "stop"
            }
        ],
        "usage": {
            "prompt_tokens": 283,
            "completion_tokens": 201,
            "total_tokens": 484,
            "prompt_tokens_details": {
                "cached_tokens": 0
            },
            "completion_tokens_details": {
                "reasoning_tokens": 0
            }
        },
        "system_fingerprint": "fp_90354628f2"
    }
]

Here’s the Interator Output Bundle:

[]

Any thoughts?

Thanks again!!

Here’s the set up for the ChatGPT module:

Hi @Shawn_Soszka
In the previous output, there’s only one collection. You can use that output as a sample structure in your ChatGPT module’s prompt. Additionally, if you need more headlines in each output, you can specify in the prompt to include 3 or 4 headlines as per your requirement, which will provide a collection of headlines.

[
    {
        "result": {
            "headlines": [
                {
                    "headline": "How to Spot Hidden Thyroid Issues Without Missing a Beat",
                    "target_audience": "Healthcare practitioners",
                    "pain_point": "Overlooking thyroid problems due to time constraints",
                    "dominant_emotion": "Frustration"
                },
                {
                    "headline": "7 Eye-Opening Signs of Thyroid Problems You Might Be Missing",
                    "target_audience": "General public",
                    "pain_point": "Not recognizing signs of thyroid issues",
                    "dominant_emotion": "Curiosity"
                },
                {
                    "headline": "13 Shocking Facts About Thyroid Health Every Doctor Should Know",
                    "target_audience": "Doctors and specialists",
                    "pain_point": "Lack of awareness about lesser-known thyroid facts",
                    "dominant_emotion": "Surprise"
                },
                {
                    "headline": "How to Detect Thyroid Disorders in 5 Minutes Without Stress",
                    "target_audience": "Busy healthcare providers",
                    "pain_point": "Limited time for comprehensive diagnosis",
                    "dominant_emotion": "Anxiety"
                },
                {
                    "headline": "7 Simple Steps to Accurately Identify Thyroid Irregularities",
                    "target_audience": "General physicians and nurses",
                    "pain_point": "Difficulty in diagnosing thyroid issues accurately",
                    "dominant_emotion": "Doubt"
                },
                {
                    "headline": "7 Crucial Tips for Uncovering Thyroid Problems Early",
                    "target_audience": "Healthcare practitioners",
                    "pain_point": "Missing early signs of thyroid disorders",
                    "dominant_emotion": "Concern"
                },
                {
                    "headline": "15 Hidden Thyroid Disorders That Could Be Affecting Your Patients",
                    "target_audience": "Healthcare professionals",
                    "pain_point": "Overlooking less obvious thyroid problems in patients",
                    "dominant_emotion": "Worry"
                },
                {
                    "headline": "How to Be a Thyroid Detective and Relieve Patient Suffering",
                    "target_audience": "Endocrinologists and general practitioners",
                    "pain_point": "Inability to diagnose thyroid issues effectively",
                    "dominant_emotion": "Determination"
                },
                {
                    "headline": "7 Astonishing Ways to Enhance Your Thyroid Diagnostic Skills",
                    "target_audience": "Healthcare educators and trainers",
                    "pain_point": "Insufficient training in thyroid diagnosis",
                    "dominant_emotion": "Hope"
                },
                {
                    "headline": "7 Underrated Symptoms of Thyroid Disorders Every GP Should Know",
                    "target_audience": "General practitioners",
                    "pain_point": "Lack of knowledge about subtle thyroid symptoms",
                    "dominant_emotion": "Interest"
                }
            ]
        },
        "id": "chatcmpl-AM76vUsXMaEHHVMrCjZJEc3NUORbV",
        "object": "chat.completion",
        "created": "2024-10-25T05:25:13.000Z",
        "model": "gpt-4o-2024-08-06",
        "choices": [
            {
                "index": 0,
                "message": {
                    "role": "assistant",
                    "content": "{\n    \"headlines\": [\n        {\n            \"headline\": \"How to Spot Hidden Thyroid Issues Without Missing a Beat\",\n            \"target_audience\": \"Healthcare practitioners\",\n            \"pain_point\": \"Overlooking thyroid problems due to time constraints\",\n            \"dominant_emotion\": \"Frustration\"\n        },\n        {\n            \"headline\": \"7 Eye-Opening Signs of Thyroid Problems You Might Be Missing\",\n            \"target_audience\": \"General public\",\n            \"pain_point\": \"Not recognizing signs of thyroid issues\",\n            \"dominant_emotion\": \"Curiosity\"\n        },\n        {\n            \"headline\": \"13 Shocking Facts About Thyroid Health Every Doctor Should Know\",\n            \"target_audience\": \"Doctors and specialists\",\n            \"pain_point\": \"Lack of awareness about lesser-known thyroid facts\",\n            \"dominant_emotion\": \"Surprise\"\n        },\n        {\n            \"headline\": \"How to Detect Thyroid Disorders in 5 Minutes Without Stress\",\n            \"target_audience\": \"Busy healthcare providers\",\n            \"pain_point\": \"Limited time for comprehensive diagnosis\",\n            \"dominant_emotion\": \"Anxiety\"\n        },\n        {\n            \"headline\": \"7 Simple Steps to Accurately Identify Thyroid Irregularities\",\n            \"target_audience\": \"General physicians and nurses\",\n            \"pain_point\": \"Difficulty in diagnosing thyroid issues accurately\",\n            \"dominant_emotion\": \"Doubt\"\n        },\n        {\n            \"headline\": \"7 Crucial Tips for Uncovering Thyroid Problems Early\",\n            \"target_audience\": \"Healthcare practitioners\",\n            \"pain_point\": \"Missing early signs of thyroid disorders\",\n            \"dominant_emotion\": \"Concern\"\n        },\n        {\n            \"headline\": \"15 Hidden Thyroid Disorders That Could Be Affecting Your Patients\",\n            \"target_audience\": \"Healthcare professionals\",\n            \"pain_point\": \"Overlooking less obvious thyroid problems in patients\",\n            \"dominant_emotion\": \"Worry\"\n        },\n        {\n            \"headline\": \"How to Be a Thyroid Detective and Relieve Patient Suffering\",\n            \"target_audience\": \"Endocrinologists and general practitioners\",\n            \"pain_point\": \"Inability to diagnose thyroid issues effectively\",\n            \"dominant_emotion\": \"Determination\"\n        },\n        {\n            \"headline\": \"7 Astonishing Ways to Enhance Your Thyroid Diagnostic Skills\",\n            \"target_audience\": \"Healthcare educators and trainers\",\n            \"pain_point\": \"Insufficient training in thyroid diagnosis\",\n            \"dominant_emotion\": \"Hope\"\n        },\n        {\n            \"headline\": \"7 Underrated Symptoms of Thyroid Disorders Every GP Should Know\",\n            \"target_audience\": \"General practitioners\",\n            \"pain_point\": \"Lack of knowledge about subtle thyroid symptoms\",\n            \"dominant_emotion\": \"Interest\"\n        }\n    ]\n}",
                    "refusal": null
                },
                "logprobs": null,
                "finish_reason": "stop"
            }
        ],
        "usage": {
            "prompt_tokens": 265,
            "completion_tokens": 591,
            "total_tokens": 856,
            "prompt_tokens_details": {
                "cached_tokens": 0
            },
            "completion_tokens_details": {
                "reasoning_tokens": 0
            }
        },
        "system_fingerprint": "fp_45c6de4934"
    }
]

Best regards,

Msquare Automation
Platinum Partner of Make
@Msquare_Automation

Hello,

I adjusted the ChatGPT prompt, and we have a winner! It’s operating perfectly. Thanks so much for your help!

I feel like I just discovered fire and a whole new world opened up.

I may have spoken too soon. I generated it perfectly once, but since then, the ChatGPT module has only produced 1 headline, even when the prompt asks for 10.

I have to wonder if the prompt is faulty.

Hi @Shawn_Soszka

Select “Add a message” as shown and choose “Assistant,” and provide the sample JSON structure. Request 10 headlines from the assistant as well.

Best regards,

Msquare Automation
Platinum Partner of Make
@Msquare_Automation

Thank you for the advice. I tried your suggestion but still have the same problem.

The ChatGPT module usually generates one headline. When it does generate the 10 headlines listed in the prompt, everything else works. This makes me think that the problem is in the ChatGPT module.

If it’s of any use, I’m including my ChatGPT prompt, thinking that perhaps there’s a problem with the prompt itself. I don’t see any problems myself, but maybe you will…

I’m writing an article about {{1.`0`}} (this is the input from the first Google Sheets module.  Please brainstorm headline ideas based on the following instructions: 
1. My typical reader is someone with a thyroid disorder seeking answers. Please consider this when creating output.
2. Use a proven headline template, like, How to [Blank], How to Be [Desirable Quality], How to [Blank] Without [Objectionable Action], How to [Blank] and [Blank], How to [Do Something] in 5 Minutes, 7 Ways to [Do Something], 13 Ways to [Do Something] When [Situation], 7 Steps to [Objective], 7 Tips For [Objective], 7 [Adjective] Facts [Person/Audience] Should Know, 7 [Blank] That Will Change Your Life, 15 Things You Didn’t Know About [Person/Thing]. 
3. Your headlines should use power words and sensory words that evoke emotion. 
4. Your headlines should tease the reader and pique their curiosity about the topic. 
Based on instructions 1 – 4, write 10 headlines for me. For each headline, identify the target audience and cite their biggest pain point and the dominant emotion associated with that pain point. Please generate each headline, target audience, pain point, and dominant emotion in JSON format, with each row’s value structured as a collection.
Here's an example of the output you can use to understand this goal better:

"headline": "How to Manage Hashimoto’s with Gluten-Free Choices",
"target_audience": "Individuals with Hashimoto's Thyroiditis",
"pain_point": "Finding effective dietary strategies",
"dominant_emotion": "Frustration"