Google Sheets Zap cannot find the worksheet - both custom and static values don't work

Hi,

I am setting up an integration to read multiple records from a Google Sheet, and load them as various Salesforce objects/records at the receiving end. 

The scenario is an exported data file, in a pre-determined format (ie. set of columns in a specific order in a google sheet). There is always only one worksheet in every exported file. The source system which exports the data out names the file and the worksheet based on the event date and other parameters (thus, for the zap, there is no way to predict the worksheet name and the sheet name). The staffmember uploads this file to a drive folder, and there is a zap listening to new files within that folder, and then kicks off to dump the data in the destination database.

Here is my sample data:

Essentially, note that Event Name and Date are the same across all rows, but other fields vary. Thus, the zap has a step to read only the Row2, columns 1,2 and creates a “Campaign” in Salesforce, and then reads the individual rows as the attendees (become campaign members).

My zap is consistently halted “Safely” at this step, and I am getting error “Halted Exception: Could not find the selected worksheet (0). Does it still exist?” Screenshot showing the runtime data below:

1. I looked into “Find a worksheet” but it asks for a name to locate the sheet ID. I do not know the worksheet name when the file lands! All I know is that this is the first and only worksheet.
2. I have tried “Static Value” with “Default Id=0”, and custom value as “0”, and I am hitting the exact same error.

What gives? I tried asking the AI assistent and it did not help! 

Parting thoughts: The “New File in Folder” type triggers or similar actions should publish the basic schema information such as the list of worksheets within the file as line items! Currently, Google Sheet support is inadequate for a schenario of reading multiple rows in an existing sheet.

Thank you in advance.