I would like a small - and I mean, very small - cloud-based function that uses Google Photos and Google Drive APIs to copy photos from a signed-in user's Google Photos account and save them on my company's Google Drive Shared Folder.
The function will ideally run whenever a new photo is added to the user's Google Photos account, but if that doesn't work it can run each hour to look for new photos.
The same user will have permission to both their Google Photos account and write permission to the Shared Folder.
Using Make.com No Code, I already have a prototype working that works for a single user. It took me 15 minutes. But now I need a version that I can deploy for all my staff.
Each user will need to authenticate using a Google Sign in. When connected, all photos taken in the connected Google Photos account should be copied to their unique destination folder.
No UI is required. The list of users will be maintained as a Google Sheet with each user's email address and the id of their associated destination Google Drive folder. New users added to the Google Sheet should be sent an email with a link to request that they authenticate. When a user is removed from the Google Sheet, their photos should stop being copied. If a user's Google Account is suspended or deleted, they will not have any photos, so their photos should stop being copied - with no error or fault reported.
When the user changes their Google Account password the function should ideally continue to operate without requiring the user to re-connect. If a new connection is required, the user must be notified by email, similar to initially connecting the account.
I will give you a login to a Project in my Google Cloud account from where you will need to deploy it as a Google Cloud function.
The job is complete when it is fully working, I can manage users connected to the function in the Google Sheet and the photos from all connected users are automatically copied to the Google Drive folder.
Please offer your fixed price quote, and timescale to get working. Thank you