I’m trying to integrate a csv from amazon S3 with a google sheet.
When the S3 file updates,find or create a row in a specified google sheet.
I created an “Index” column in both the google sheet and the S3 csv file, but when I want to specify the “lookup value” in the S3 file (named Index as well), the zap doesn’t actually open the csv, but only allows to specify things like Name / File / File name / Metadata.
Naturally, if the zap doesn’t know it needs to look for the Index column in the S3 csv, it won’t be able to update the values correctly.
This should be pretty straightforward, what am I missing?