Logic flow seems to work, but still returns error

tob · July 4, 2023, 9:46am

Hi,

I’m trying to set up a logic flow to update my CMS collection with new items as I add them in Google Sheets. Even though the flow seems to work, and new items are being added, I also get an error for each item that is added. I can’t seem to find what is causing the error. If I’m adding several items at once, the flow automatically turns off due to these errors.

On the google sheet side, I have added a script that sends the first cell of each new row as JSON to the webflow webhook.

Anyone know what might be the issue?

Best,
Tobias

Edit:
Forgot the read-only:

https://preview.webflow.com/preview/iris-restaurant?utm_medium=preview_link&utm_source=designer&utm_content=iris-restaurant&preview=c10cb91eb5bc906edc35ef430be1fc6b&workflow=preview

memetican · July 4, 2023, 10:07am

Unfortunately, preview mode shows very little about Logic flows.
No details and no error history.

From your screenshot, yeah looks vague.

My best guess is that you’re over your CMS item limit (?) what plan is the site on?

Ha, in fact if I go into the CMS, and hover over an item’s duplicate button I see an error-

tob · July 4, 2023, 11:27am

Thanks for the reply!

I’m on a CMS plan, so the item limit should not be an issue, I guess.

To clarify: the flow does work in that it is adding new items. It is just that it generates an error as well, and eventually turns off.

Here is a walkthrough of the process:

I add a new row in Google Sheets
I send the data in the row to the webhook using a google script
the flow triggers and creates a new CMS item AND then triggers the error.

Todd_Gochenour · October 15, 2023, 11:08pm

I too have this issue where Logic Flow Run History reports a run has failed yet the Create CMS Item action fired successful. This flow handles two use cases, one creates an item when roster-name is empty, the other updates an existing item when roster-name is not empty. The previous ‘Successful’ run is from this second use-case. Both use-cases are working but one reports a failure.