ChatGPT to Google Doc for Blog Entry Limit on Length?

How To
,
1

Hey All -

I created a script that:

  1. pulls from a Google Sheet for Article Title, overall question to answer, and keywords to target
  2. pushes that to ChatGPT Assistant with the intent to return a full Blog Article (1,500 words)
  3. returns that output to a Google Doc.

In my testing, the results (regardless of GPT 3 or 4), seems to only write ~1,600 characters, or 239 words, yet when I inspect the return result from the GPT output, it is the full article.

Any ideas how to get the translation from the output to Google Doc for the full article? Is this a limit on Make? or Google Doc Ingress that needs me to chunk the article into smaller components?

Any help would be appreciated!

2

Welcome to the Make community!

Can you please show us evidence of the full blog post returned by OpenAI, and truncated article in Google Doc?

1. Screenshots of module fields and filters

Please share screenshots of 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:
Screenshot_2023-10-07_111039

2. Scenario blueprint

Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

Screenshot_2023-08-24_230826
(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)

3. And most importantly, Input/Output bundles

Please provide the input and output bundles of the 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”.
Screenshot_2023-10-06_141025

A.

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

Uploading them here will look like this:

module-1-input-bundle.txt (12.3 KB)
module-1-output-bundle.txt (12.3 KB)

B.

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

  • Either add three backticks ``` before and after the code, like this:

    ```
    input/output bundle content goes here
    ```

  • Or use the format code button in the editor:
    Screenshot_2023-10-02_191027

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.

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

2 Likes
3

blueprint.json (27.7 KB)

After further inspection looks like I am losing packets on the output from GPT

Output from ChatGPT:

[
    {
        "id": "chatcmpl-9090R5LL9wHPHy64ul6OUhQjhIPpA",
        "object": "chat.completion",
        "created": "2024-03-07T14:27:27.000Z",
        "model": "gpt-4-0613",
        "choices": [
            {
                "index": 0,
                "message": {
                    "role": "assistant",
                    "content": "Title: SparkSMB: Your Fractional AI Automation Expert – How It Can Revolutionize Your Business \n\nIn the age of rapidly growing technologies, successful enterprises continue to seek innovative ways to optimize processes, augment productivity, and ultimately propel their bottom lines. Among these evolving technologies, AI automation stands as a paramount element. But is it feasible for every organization to maintain an in-house AI team? What if your business seeks a more fractional approach, where you can harness the robust power of AI automation without completely rinsing your resources? Here’s where SparkSMB, a leading Fractional AI Automation Expert, comes to the rescue.\n\n##What Is Fractional AI Automation?\n\nFractional Artificial Intelligence (AI) automation is a highly efficient and economical method that offers businesses access to leading AI experts for a fraction of their time, and, consequently, cost. This approach allows for small to medium-sized businesses to retain competitive advantage, without necessarily committing to full-time AI engagement.\n\n##The Crucial Role of SparkSMB\n\nIn the broad competitive landscape today, SparkSMB stands as an industry-leading Digital AI Consultancy, positioning itself as your go-to Fractional AI Automation Expert. SparkSMB spares no effort in crafting personalized AI solutions, ranging from data analysis to prediction models, tailored specifically to the unique needs of your business.\n\n##How Can Fractional AI Automation Benefit Your Business?\n\n###Cost-Efficient: \nEmerging businesses may perceive AI automation as a luxury or indulgence due to associated high"
                },
                "logprobs": null,
                "finish_reason": "length"
            }
        ],
        "usage": {
            "prompt_tokens": 107,
            "completion_tokens": 300,
            "total_tokens": 407
        },
        "system_fingerprint": null
    }
]

Input to Google Docs:

[
    {
        "name": "How can Fractional AI Automation benefit my business?",
        "footer": false,
        "header": false,
        "content": "Title: SparkSMB: Your Fractional AI Automation Expert – How It Can Revolutionize Your Business \n\nIn the age of rapidly growing technologies, successful enterprises continue to seek innovative ways to optimize processes, augment productivity, and ultimately propel their bottom lines. Among these evolving technologies, AI automation stands as a paramount element. But is it feasible for every organization to maintain an in-house AI team? What if your business seeks a more fractional approach, where you can harness the robust power of AI automation without completely rinsing your resources? Here’s where SparkSMB, a leading Fractional AI Automation Expert, comes to the rescue.\n\n##What Is Fractional AI Automation?\n\nFractional Artificial Intelligence (AI) automation is a highly efficient and economical method that offers businesses access to leading AI experts for a fraction of their time, and, consequently, cost. This approach allows for small to medium-sized businesses to retain competitive advantage, without necessarily committing to full-time AI engagement.\n\n##The Crucial Role of SparkSMB\n\nIn the broad competitive landscape today, SparkSMB stands as an industry-leading Digital AI Consultancy, positioning itself as your go-to Fractional AI Automation Expert. SparkSMB spares no effort in crafting personalized AI solutions, ranging from data analysis to prediction models, tailored specifically to the unique needs of your business.\n\n##How Can Fractional AI Automation Benefit Your Business?\n\n###Cost-Efficient: \nEmerging businesses may perceive AI automation as a luxury or indulgence due to associated high",
        "folderId": "/1TlsjKYZ778qCh0-utfxtJv8WgbX-IQLy",
        "destination": "drive"
    }
]
4

If you aren’t getting the full output you are expecting, increase the number of tokens.

3 Likes