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?
Best answer by Danvers
It’s not possible to get the contents of a file in Amazon S3 using the updated file trigger, I’m sorry about that! We do have a feature request open for the ability to do that, but it’s not currently possible to do with the Amazon S3 API, so it’s not something that we can do right now. I’ve added you to the feature request for that so if things change in the future and we are able to add that option, we’ll let you know!
I’ve also added you to the Google Sheets feature request that