Just built this: Make.com hits a Google Apps Script web app (deployed as a web deployment) -> script zips up a Google Drive folder -> sends the zip back to Make to use however you want. Basically, Apps Script becomes a custom "tool" Make doesn't natively have.
Once you deploy a script as a web app, Make can just call it like an API.
What this opens up (in simple terms):
- Zip/unzip files in Drive automatically
- Bulk rename, move, or organize files
- Generate custom PDFs/docs Make can't build natively
- Read/write Google Sheets in complex ways beyond Make's built-in modules
- Basically anything Google's APIs can do but Make doesn't have a direct module for
If you're hitting a wall with Make's native Google modules, this is the workaround.
Happy to share the setup if anyone wants to try it.