Set up permissions on new Google Sheets field

How To
1

I have just started using Make, and I am trying to accomplish the following workflow:

  1. Watch a Google Sheets spreadsheet containing a list of users, identified by their email address
  2. Create a copy of a template spreadsheet for that user on Google Drive
  3. Change the permissions on the copied spreadsheet to allow the new user the ability to write to that spreadsheet.

I have accomplished most of this, but am failing on changing permissions. I am trying to use the Google Drive - Update a File / Folder Access action. I have found the documentation on this action.

There’s nothing in that documentation that indicates what should go into the Permission Name of that action. It’s not clear to me how to specify the name of the user who should be given the specified Role.

This post has essentially the same question, but the suggested answer involves making an API call. I’m trying to teach students how to use Make to do some no-code automation, and the API method is more complicated than I would like.

Can some one weigh in with a better way?

Or, if I have to go the API call way, how would I reference the email address from the “Watch New Rows” module in the API call’s configuration.

2

Welcome to the Make community!

You can use the Google Drive “Get a Share Link” to change user permissions on a file.

Screenshot_2024-10-01_091039
Screenshot_2024-10-01_0910391005×636 83.4 KB

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

3

It seems strange that Get a Share Link is the correct action, rather than Update a file/folder access. But it does just want I want it to do, so thank you!