I’m building a workflow that generates draft emails for us to send. We’re using a Google Sheet as our database to track the total number of follow-ups sent, the last_sent date, whether a draft has been created, and whether we’re waiting for the next due date before generating the next draft.
For example, let’s say I just sent the second follow-up today—our third follow-up waits 4 days (unless they respond) before drafting the next email. Everything works perfectly on the drafting side, but when it goes to update the database, it isn’t updating all the rows.
I just sent 22 today—it created them all and said it updated the database with no errors, but that wasn’t the case. It only updated a few of them. I tried to troubleshoot it, but honestly couldn’t find a solution. Hoping you all can help me figure it out.
I’m attaching a screenshot of the overall workflow, plus screenshots of the Google Sheet and the node that says it updated properly.
