Email attachments filed into company folders automatically

The scenario takes attachments from emails in почта, identifies the company via a directory in Google Sheets, and files them into folders in Google Drive.

  • Every attachment in its company's folder
  • Sorted by month inside
  • The company is identified via Google Sheets
  • No more hunting for documents by hand
Gmail
Add it to your accountScriptera

How it works

To move data from Google Drive to Google Sheets automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Gmail Trigger
  2. Then: Lookup in Sheets
  3. Then: Search Company Folder1
  4. Check: Company Folder Exists
  5. If yes: YYYY/MM
  6. Then: Search For Folder
  7. Check: Check If Folder Exists
  8. If yes: Gmail
  9. Then: Split Up Binary Data1
  10. Check: Loop Over Items
  11. Then: Upload To Folder
  12. If no: Create Month Folder
  13. If no: Create Company Folder

You can launch this Google Drive + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios