What Am I Doing Wrong Here? Update Sheets Node
Hello everybody. Can someone let me know what I’m doing wrong? My scenario is: I have 100 videos that have been uploaded to Google Drive and their files names have been written in a GoogleSheet. The idea of the workflow is, first, it will look for the filename (Get_rows node) then if the status is “todo” and the video URL is not empty (check one node) it will extract the video URL (extract URL), after that if fileID is not empty (check Two node) it will go to batches and 3 videos will be processed every time. 3 videos will be downloaded, transcribed and my LLM Basic Chain will create a title, description, hashtags etc based on the transcription. My idea is to fill the spreadsheet columns (“title”, “description”, “hashtags” and “x_description”) with the information produced by the LLM Basic Chain node.However, I run into an issue. For example, every 3 videos that are processed (batches) rows 2, 3 and 4 gets updated in the spreadsheet. So basically if I run the workflow twice, the data gets overwritten because rather than adding the new data (second batch of 3 videos) to row number 5, 6 and 7 (for example) the new batch overwrites rows 2, 3 and 4, so I end up with the data from videos 04 (row 5), 05 (row 6) and 06(row 07) in the row 2, 3 and 4. This is hard to explain, but do you understand what I mean? I’ve tried to map this out using the filename (which is unique) and row number but I keep getting this behaviour. What I want is the workflow to fill the rows based on the filename, not overwrite the information. Do you know what I’m doing wrong and how I should fix this? Thanks in advance for your input!