Google Spreadsheet nodes not consistent results
Hello,
I want to insert certain information to certain cells in google spreashsheet. I modified the code from the nodes and the code should work. However I get inconsistent results - some times only one part of the information is inserted, another time only another part, third time again some different part. This is rather strange because I am sure the code works and should work and insert all the information. I feel that at some point the node just decides not to listen and skips some values at random. What would be the reason for this?
1 Reply
I think I managed to resolve this one because I saw that some of the elements were not inserted because the google API has a limit for 'write' per minute per user so I added time delay of 2 minutes and then to continue to insert values. That way after 2 minutes the algorithm continues and the values are inserted.
However now I have a new bisare problem in other workflow but again with google sheet. Sometimes when I execute the workflow I do not get this error and works but sometimes I get it and it does not work. Why it is like that? What is the reason sometimes there to be this error and sometimes not? What could cause this?