I am using Google Forms with Form Approvals for Timesheet submissions. From those submissions we get an Approval Form that includes payroll information I need, a supervisor signature, and a link to the uploaded timesheet. For our grant billing I am trying to create a Zap that would automatically copy any timesheet approvals matching the filter criteria to another designated folder so that when billing for that program comes I will have them already ready instead of having to pick through a folder full of approvals and find just the ones I need for that particular program.
Right now the simplest idea seemed to be to set up a Zap triggered by the new file created in the approval form folder when a timesheet submission is approved. But when I try to use the “copy file” option is asks me to choose a file… the file doesn’t exist yet… I want to copy the new file that triggers the Zap. Anyone know how to accomplish this? I started out several different ways last night (Google Form trigger, email from Form Approvals trigger, etc) which all ended up being overly complicated. This seems to be the most simplistic way, and I would think it should be possible.