I have created one Zap that is looking for new Google sheet files in a Google Drive folder. Next, it should lookup for a spreadsheet row in the new file and transfer this data to another spreadsheet.
The first step is working fine, but I can’t find out how to tell the second step (the lookup) to use the newly found file from step 1.
The “Lookup Spreadsheet Row in Google Sheets” action only allows me to manually choose a file name from my Google drive and doesn’t seem to dynamically use the file name of the detected new file from step 1.
Any help would be super appreciated 