Custom node throwing multiple errors before running (mostly) successfully

[afreymuth]

I have 2 issues.

Because the google sheets node doesn’t pass the row ID (which is insane), I’ve had to try to make a couple of custom nodes to try and clear rows where a value entered into a specific column is detected as a duplicate.

The problem lies in the fact that every time an Update/Create is detected in the Google Sheet, the flow executes twice (failing improperly) and throws errors saying the mandatory input fields on my custom nodes are missing (they aren’t). But on the 3rd run it executes and nearly makes it through the whole thing.
Error 1: https://www.gumloop.com/pipeline?run_id=WmgXfHMSmZ3jw43JVCbxuh&workbook_id=qMRrEsMTvKEDjz5HvFfp9S
Error 2: https://www.gumloop.com/pipeline?run_id=KHwGuVnJyrU5JAgQPRXmYZ&workbook_id=qMRrEsMTvKEDjz5HvFfp9S
Error 3: https://www.gumloop.com/pipeline?run_id=oRoymrNN4je5uAZjTgKX7Z&workbook_id=qMRrEsMTvKEDjz5HvFfp9S

The other error which pops up is that I’m trying to have the custom node connect to Google Sheets, but the node throws a credentials error. I’m burning credits trying to troubleshoot this even though it’s faulty and not executing. I assumed the auto-code aspect would work, but clearly it’s not.

https://www.gumloop.com/pipeline?workbook_id=qMRrEsMTvKEDjz5HvFfp9S

[Gumloop_Bot]

Hey @afreymuth! If you’re reporting an issue with a flow or an error in a run, please include the run link and make sure it’s shareable so we can take a look.

1. Find your run link on the history page. Format: https://www.gumloop.com/pipeline?run_id={your_run_id}&workbook_id={workbook_id}

2. Make it shareable by clicking “Share” → ‘Anyone with the link can view’ in the top-left corner of the flow screen.
   

3. Provide details about the issue—more context helps us troubleshoot faster.

You can find your run history here: https://www.gumloop.com/history

[Wasay-Gumloop]

@afreymuth

Error 3: https://www.gumloop.com/pipeline?run_id=oRoymrNN4je5uAZjTgKX7Z&workbook_id=qMRrEsMTvKEDjz5HvFfp9S

@afreymuth - The error here seems to be unrelated to Google Sheet - you’re trying to access a credentials file that doesn’t exist - credentials.json

Error 2: https://www.gumloop.com/pipeline?run_id=KHwGuVnJyrU5JAgQPRXmYZ&workbook_id=qMRrEsMTvKEDjz5HvFfp9S

The flow fails in error 1 & 2 because the sheet reader did not output anything - likely because the row creation was fired by a different column. Could you test this again please? I’ll compensate the credits but just want to make sure the flow works for you first.