Enable dynamic discovery for stream name (out name for file or table) and the schema.
This can be done by making a request to get your Google Sheet's file metadata to use as the stream name, and the first row of the Sheet data to build the schema, during the discover step in the tap.
This should mean that you can, once you have provided the required tap setting so it can make requests, run tap-google-sheets --discover and you will see the schema generated from your Google Sheet.
Enable dynamic discovery for stream name (out name for file or table) and the schema.
This can be done by making a request to get your Google Sheet's file metadata to use as the stream name, and the first row of the Sheet data to build the schema, during the discover step in the tap.
This should mean that you can, once you have provided the required tap setting so it can make requests, run
tap-google-sheets --discover
and you will see the schema generated from your Google Sheet.