Question

Moving new file in Google Drive according to file name

Userlevel 1

Hello Community,

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.

Thanks

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

Userlevel 7

+14

Lookup tables would probably be the best for your use case.

You use a GSheet as a lookup table too: Lookup Row (and pass in the Dealership and Department)

You’d have to create the GSheets lookup table by getting all the folder IDs for the Dealerships and Departments.

Otherwise, try this App: Formatter > Utilities > Lookup Table

Article: https://zapier.com/help/create/format/create-lookup-tables-in-zaps

Userlevel 1

Thanks @Troy Tessalone

Any idea of what the steps should look like in Zapier?

Am I missing something, I’m having trouble linking the steps together..

Thanks

Userlevel 7

+10

Hi @MattGPA

Sorry we missed your reply. Did you manage to get something sorted here?

Sign up