I’m looking for a solution to execute this workflow in Google Sheets:
In a Worksheet (Google Sheet A) I save a list of different URLs pointing to different Google Sheets (Google sheet 1,2,3,4,5…). I write the URLS in the same column, in different rows.
When a new URL of a new Google Sheet is added (URL Google sheet 1, 2,3,4,5…) in the specific column, I trigger the workflow
I need to go the that single Google Sheet (since I have the URL of Google sheet 1, 2,3,4,5…), go to a specific Worksheet, retrieve a single row (the only one existing, no problem of lookup)
Store the retrieved Row (from Google sheet 1, 2,3,4,5…) to a different Google Sheet B
I didn’t find a solution to execute Step3.
I have the URL of the google sheet from Step2, I tried to execute a lookup step but if I put the URL of the sheet as Custom Value in Spreadsheet field, Zapier is not resolving the Worksheet name field and the lookup column field. They are all required field to enable the lookup.
Is there any other way to approach these? Any idea or test?
Best answer by GetUWiredView original