Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Copying a Google Sheet and IMPORTRANGE requires access to connect sheets

  • December 30, 2021
  • 2 replies
  • 1409 views
C
Forum|alt.badge.img

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 GetUWiredBest answer by GetUWired

Hi @Ciara M 

I don’t believe there is a programmatic way to authorize access. The only solution that I am aware of is to alter the permissions of the spreadsheet file from which you are importing data. If the file is public, no need to authorize access. 

If that is not a viable solution, someone will have to continue to manually authorize it. 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

GetUWired
Forum|alt.badge.img+12
  • GetUWiredZapier Expert
  • Zapier Expert
  • 1030 replies
  • Answer
  • December 30, 2021

Hi @Ciara M 

I don’t believe there is a programmatic way to authorize access. The only solution that I am aware of is to alter the permissions of the spreadsheet file from which you are importing data. If the file is public, no need to authorize access. 

If that is not a viable solution, someone will have to continue to manually authorize it. 

C
Forum|alt.badge.img
  • Ciara MBeginner
  • Author
  • Beginner
  • 14 replies
  • December 30, 2021

Thanks a million for looking. I can’t make it public I’m afraid, so we’ll have to stick with the manual update. It’s not a great hardship but was looking for something slicker. Thanks for coming back so quickly.

Terms & Conditions