I’ve set up a document tracker automation that automatically transfers information from Google Drive to a Google Sheet whenever files are added to a client’s folder. While most of the columns are populating correctly, I’m having trouble linking the folder path to display the folder name in a specific column. Any advice would be appreciated! Also is there a way I can watch the whole folder and the folders inside, without building out seperate scenarios for each folder within the client folder. Thanks.
1 Like
To identify the column, use if() function i.e {{if(foderPath=example;folderName)}}
AND for watching all folders in one automation, setting an app script might can help.
Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation
1 Like