I have a zap that copies an existing Google Sheet that includes an IMPORTRANGE calc (Google Sheet A). Within the original sheet access has been granted to read the data in the IMPORTRANGE calc (it pops up in the cell initially and you select allow access). The IMPORTRANGE calc is reading to a Google Sheet on the same local drive.
So the zap creates a copy of Google Sheet A and creates Google Sheet B. The next step of the zap provides users rights to anyone in our domain with the link (mindfulbirthing.org) to access the sheet.
When I open the newly copied Google Sheet, the IMPORTRANGE calc requires me to manually “Allow Access” for the data to flow through. Any ideas of how to automate the access for this calc as part of the zap rather than a user having to manually step in? Any help will be gratefully received!
Best answer by GetUWiredView original