I’m trying to set up a simple workflow that takes our new drawing files, uploads them to Drive, keeps the versions organized, and automatically emails clients when something gets updated. Nothing fancy, just something that saves us some manual work for a small drafting team.
The files are generated on (URL Removed by Staff) , and I’d really like everything to sync on its own instead of having to upload each update by hand.
If anyone has done something similar with Workspace APIs or knows an easy way to set this up, I’d really appreciate the help.
Where is the source system (ie: where are the CAD files currently stored)? At a high level (using Application Integration) I could see you doing something along the lines of the following:
Once pushed to Application Integration, you can perform any message mediation, enrichment, etc via a set of data transformation tasks native to the platform (no code, low code, Javascript, etc)
You can automate this with the Google Drive API for versioning and the Gmail API for sending client notifications. Use the Drive files.update method to upload new CAD revisions while preserving the same file ID, which keeps version history intact. A small script running on Cloud Functions or Cloud Run can watch for new files in your source location, push them to Drive, and trigger an email via Gmail API when an update occurs. For authentication, set up a service account with drive.file and gmail.send scopes and store credentials securely in Secret Manager. This way the entire workflow runs serverless and hands‑free once deployed.
Appreciate the detailed breakdown. I followed a similar pattern: Cloud Run picks up new CAD exports, updates the existing file in Drive to keep the version history clean, then triggers a notification service via Pub/Sub. Since our drafts originate from https://usadraftsman.com, having everything flow automatically into Drive saves us a lot of manual steps.