Wondering if there's a way to pull multiple records from Airtable into a Google Sheet via Zapier based on a conditional Y/N column in Airtable.
Basically, I want to create a Zap that searches all the records in the table and any record with a 'Y' in the column is pulled into a Google Sheet.
Zapier have told me it's only possible to do this by utilizing Code by Zapier however my skills are pretty minimal so I was wondering if anyone could point me in the right direction as to how I'd achieve this or if there's anything existing on Stackoverflow (I've had a search but can't see anything).
Any help would be massively appreciated!
Cheers!
David here, from the Zapier Platform team.
Based on your comments on the original question, running daily is the requirement that's making this much more complicated. Given that you said the zap can run continuously, I recommend the following setup:
First, Create a view that filters for records that have all the properties you want ('Y' in a certain field, etc). The zap will look for new records in this view, so it'll work even if 'Y' is added to an existing record. The zap is as follows:
I'm not sure what sort of volume or pattern you're expecting, but I would probably add a field to Airtable like "email sent". Then, add a step 5 to update the airtable row that clears rows out of the view to help avoid this bug. That's optional though. It really depends on if you're going to be adding 'Y' to records that aren't in the 200 most recently created in the view.