Hello,
We recently created a Contact-Based Workflow where users from an Active List are enrolled into a Google Sheet via the API integration.
The import just completed but we are seeing about 400+ contacts that failed to import with the error being “The connected app returned an error”. Snapshot below.
Whats even stranger is that when I manually enroll these contacts they push over to the sheet immediately without issue.
We cannot seem to understand what is causing the API to break as everything checks out on our end.
Does anyone have any thoughts on how to resolve this?
This is purely an assumption, but you may have hit a page or row “lock” on the google side. I’d suggest setting a delay on the workflow to see if it was a lock or a rate limit that you encountered. Since the sheet ID isn’t changing, “Not Found” is obviously not an accurate description. When you say “API integration” are you referring to the Google Sheets app within the hubspot marketplace?
If possible, I’d recommend adding some retry logic around this. We have a bunch of Google API integrations and get all kind of errors 4xx and 5xx, and had to retry around them.
HubSpot lists APIs are super tricky. You can theoretically use any third-party connector that supports 2-Way Sync with HubSpot & Google Sheets - I recommend using Superjoin, it helps me bring data from HubSpot to Google Sheets.
HubSpot lists APIs are super tricky. If you want to save the headache, you can use any third-party connector that supports 2-Way Sync with HubSpot & Google Sheets - I recommend using Superjoin, it helps me bring data from HubSpot to Google Sheets.
