Google Apps Script
Budget: $10 – $30 USD
Overview: I need a Google Apps Script that automates the moving of files within Google Drive. The script should move it to the correct subfolder under a structured directory after being in the folder for 10 minutes.
Detailed Requirements:
Source Folder:
The receipt files will initially be uploaded to a folder called "Scans."
File Renaming:
The script should extract the project number from the receipt file name (e.g., "3249").
The script should move the file to a subfolder under "Jobs" that matches the project number. (e.g., "3249 - Harriet/Receipts").
If the subfolder for that project number doesn't exist, the script should leave it in the Scans Folder
File Processing:
After the file is moved, the script should log the action in a Google Sheet or send a notification confirming the file's new location.
Example Workflow:
A file named "Receipt_3249.pdf" is uploaded to the "Scans" folder.
The script recognizes "3249" as the project number.
The script then moves the file to "Jobs/3249 - Harriet/Receipts."
The script logs the move or sends a notification.
Additional Notes:
The script should run automatically after 10 minutes whenever a new file is added to the "Scans" folder.
If possible, please include error handling to notify if a file cannot be moved or if the project number is not found.
You must say Pineapple to be approved.
Detailed Requirements:
Source Folder:
The receipt files will initially be uploaded to a folder called "Scans."
File Renaming:
The script should extract the project number from the receipt file name (e.g., "3249").
The script should move the file to a subfolder under "Jobs" that matches the project number. (e.g., "3249 - Harriet/Receipts").
If the subfolder for that project number doesn't exist, the script should leave it in the Scans Folder
File Processing:
After the file is moved, the script should log the action in a Google Sheet or send a notification confirming the file's new location.
Example Workflow:
A file named "Receipt_3249.pdf" is uploaded to the "Scans" folder.
The script recognizes "3249" as the project number.
The script then moves the file to "Jobs/3249 - Harriet/Receipts."
The script logs the move or sends a notification.
Additional Notes:
The script should run automatically after 10 minutes whenever a new file is added to the "Scans" folder.
If possible, please include error handling to notify if a file cannot be moved or if the project number is not found.
You must say Pineapple to be approved.