I have been trying to find a way to trigger a zap when a file is added or changed on a server.
I know this is easy to do using a cloud service like Google Drive, but in this case, a cloud service is not an option. The files can only exist on the server hosted by our web hosting service.
So far, I have had no luck in finding a solution, but am probably overlooking something obvious.
Best answer by RonW
We use Google Drive Stream to provide local Windows access to the files on our Google drive. So I set up a scheduled Windows batch process that uses WinSCP to copy any newly created files on our hosted server to a local folder on my computer that is synced to our Google Drive. Once on the file is synced to Google Drive, I can then use Zapier's Google Drive - Updated File app to watch for and process any newly added files.
Not a very elegant solution, but works and is good enough until I can come up with something better.