Currently working on a project in Google Drive and don’t know exactly where to start.
I’ve set up a zap that automatically recreates a google doc with the answers from a Google Form.
The file is the bi-annual performance review for each employee from 15 different locations.
I would like to be able to move new files automatically in the right folder and sub folder.
Each dealership has 4 or 5 departments.
Folder structure is : Dealership → Department.
Files that are generated through the first zap all have the same structure with parts separated with a |
Dealership name|Department|Period of the year (winter 2021 or summer 2021 i.e)|Employee Name.
I’ve read about lookup tables and zapier extract function but am not sure exactly if that the right solution.