Issue with Google Sheets to HubSpot Scenario – Deal Not Created Despite Success Status
Hey everyone, I’m running into a strange issue with a scenario that automates lead capture from Google Sheets to HubSpot.
Scenario Setup:
- Google Sheets: Watch Rows - Monitors new entries in a “Lead Magnet - Mastersheet”
- HTTP: Send Data - Sends data to a Google Apps Script to mark the row
- HubSpot: Upsert a Contact - Creates/updates a contact
- HubSpot: Create Deal - Should create a deal tied to the contact
What’s Going Wrong:
-
The scenario works perfectly when run manually, if the Google Sheets module detects and logs new data.
-
During live execution or when running manually multiple times, it only creates the contact — the “Create Deal” step silently fails.
-
No error message is shown, but the deal never appears in HubSpot.
-
Even weirder: the scenario sometimes uses old/stale data, despite a new contact getting created. It’s like it’s stuck on a previous row.
Observations:
- The issue only happens when the Google Sheets module doesn’t properly update with fresh data.
- Once a new row is detected, everything flows — but if it’s not, the process seems to continue with outdated values.
- It silently fails, which makes debugging harder.
Looking for Help:
- Is this a known issue with how “Watch Rows” caches data?
- Any tricks to force refresh or clear stale values between runs?
- Open to workarounds or module alternatives.
Things I Tried:
- Reconnected, verified, and reauthorized Google Spreadsheet and Hubspot Account.
- Tried asking Make.com built-in AI Helper.
*Please see attached images for reference
Thanks in advance for any guidance or similar experiences
