I’m working in a workflow that reads a file (specific sheet) in Google Docs, at one point I do a Lookup to extract the rows in blank from this file. Then I need manually complete the information and add this info to this same Excel in Google Docs, after, I need to run again this file updated and completed.
My first idea was doing like the image shows, read the file in Docs, do the vlookup, and writer it like an excel file (its opening when the file executes) and complete the data manually, take this data, copie and paste these rows in the Google Docs. But I don’t know if exists another easy way to do this process. The step would like me to delete is “copie and paste”, maybe exist some way to open this file on the go, complete it, and update it without copy & paste.
Thanks in advance!!!