I retrieve data from Googlesheets, run a filter, limit the number of rows to avoid API request limit, then loop through to send email, wait 70 seconds and continue till the list is exhausted.
However, I am having a challenge sending the aggregated list to Googlesheets for a bulk update of rows I have emailed.
Hello @Rachel,
i think the problem is that the “aggregate sent emails” node creates a single item with an array of emails while the “update row status” node, on the other hand, expects individual items to update each row.
Try adding a split out node for the email_first field.
I also found another community thread that may be right for you: Google Sheets Update Multiple Rows
I have tried using Split Out and Aggregate nodes to send a list of email_first, but I am not getting the expected result. Is there a Googlesheet batch update node I could use?
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.