Content generation fails for automation (1. Google Sheets, 2. OpenAI, 3. Google Docs)

[johneu]

Error when generating automated content: The first test row is always successful, but then nothing happens. Only a few tokens consumed

Steps created:

1. Sheets → New or updated spreadsheet row
2. OpenAI → ChatGPT
3. Google Docs → Create a blank document
4. Google Docs → Append a paragraph to a document

What I have taken care of is

• Step 1: Google Sheets → New or updated spreadsheet row
  • Activated Pabbly connect webhook extension
  • Run Initial setup
  • Checked “Send on event”
• Step 2: OpenAI → ChatGPT
  • Connected Pabbly to OpenAI account with project API key
  • Ensured OpenAI account has enough funds available
• Step 3: Google Docs → Create a blank document
  • Connected Pabbly to Google Docs
  • Named document based on certain variables (column names from Google Sheets)
• Step 4: Google Docs → Append a paragraph to a document
  • Replaced suggested document id/name with step 3 Google Docs document id
  • Mapped relevant fields for pulling the paragraph

Also, created another identical workflow but changed Step 2 to ChatGPT → Ask ChatGPT (no success, but 21 tasks consumed)

How to tackle this sort of issue?


Ps. I used this video as a foundation for building workflows:

 

[Subin]

Hey @johneu !

Kindly share the workflow URL in which you have tried the setup?

So we can check on it and guide you further.