Description: This automation is designed to streamline the process of organizing and uploading receipts to Google Drive. Here’s a brief overview of its functionality:
- Retrieve Sheet Content: It starts by fetching content from a Google Sheet.
- Check for Existing Records: It checks a datastore to see if a record already exists.
- Search for Folders: It searches Google Drive for folders named after the current year and month.
- Create or Upload: Depending on whether the folders exist:
- Record Management: It adds records to the datastore for tracking purposes.