Is anyone familiar with the way

tap-google-sheets

handles state? Basically trying to only capture new rows in a Sheet between different runs of the Singer tap. From what I can tell it uses some extra stream called

file_metadata

for this – not sure if what I’m going for is possible

No idea on the tap-googles-sheets tap. What I know is that Google Docs / Sheets stores data in something like "mutations" (I'm probably butchering the name) but it's chunks of changes. I'm almost certain there's no tie to rows. And I'm not sure if you can touch the history I"m talking about with the API. https://developers.google.com/sheets/api/reference/rest/v4/DataFilter Looks to be your best bet. Create a column on the sheet you care about, make like an

updated_at

field and use this api to filter down what you want?