I have set up a ”Zapier Transfer" of Excel data into a shared Google sheet and I want to be able to automatically run the transfer each week but only select a filtered section of the transfer data. It is a weekly range of manufacturing data, being filtered by current week number.
Currently I would run a transfer and filter by "week”, selecting the appropriate (current) week number. Then conduct the transfer.
Ideally I would create a Zap from the Transfer, filter and then send to Google Sheets
Currently Transfer by Zapier only works when manually run.
You’d have to configure a Zap to handle the desired logic you’ve described.