Trigger: A new Google Form submission lands in our Opportunity Intake Google Sheet.
Step 2: A ChatGPT action reads that row, then generates the project summary, checklist, deliverables, travel notes, etc.—all the merge-field text our Google-Docs templates need.
Steps 3-5 (what the Zap should do):
-
Create the correct Google Docs – Project Brief always, plus Creative Brief and/or Travel Brief when flagged.
-
Save each doc in the project’s Drive folder (one copy each).
-
E-mail the team the right brief(s) and SMS me an alert.
What’s going wrong:
-
Google-Docs step throws
Cannot read properties of undefined (includes)
even though it still creates files. -
An extra “All Paths” branch fires, so we get duplicate docs, the wrong file attached to the e-mail, and the SMS sometimes doesn’t send.
Suspected root causes & desired fixes:
-
Some ChatGPT fields arrive as undefined → default every merge field to an empty string so the error disappears.
-
Delete the duplicate “All Paths” branch (or gate doc-creation with Filters) and move e-mail/SMS so they run once per Zap.
All templates, screenshots, Zap-history CSV, and detailed notes are attached below. I’m looking for guidance—or hands-on help—implementing those fixes so the automation runs clean every time.