Importrange permissions In this step-by-step guide, we'll walk you through how to use IMPORTRANGE effectively, from understanding the Nov 22, 2023 · I'm trying to use the importrange function in a google sheet. Hi! I've been trying to use the formula for "Import Range" but it keeps saying "You don't have permissions to access that sheet" I own the sheet I'm trying to pull the data from and didn't get a message or anything. Help Center Community Gemini in Docs EditorsGoogle Docs Editors Nov 29, 2022 · Hi Ivy, Have you tried sharing FILE B as "anyone with the link can view"? If that does not work, try automating the process with Apps Script as shown at How to allow access for importrange function via apps script at Stack Overflow. I wanted to do an importrange from A into B, but when I went to connect them I got a message that I do not have permission to access that spreadsheet (it was saying I do not have permission to access Spreadsheet A. Try out Sheetgo as an alternative to transfer data between spreadsheets. Spreadsheet A owned by Anne, and Spreadsheet B owned by Betty. Permission & access Spreadsheets must be explicitly granted permission to pull data from other spreadsheets using IMPORTRANGE. Apr 8, 2022 · Learn how to use the IMPORTRANGE function in Google Sheets to transfer data between different Google Sheets files. Whenever I attempt to import data, I am greeted with the error Aug 24, 2025 · Learn how to fix Google Sheets IMPORTRANGE not updating issues by reauthorizing permissions, adjusting the formula, and limiting the range. Nov 10, 2025 · Use the IMPORTRANGE Google Sheets function to access data between spreadsheets. evrcg ioieklsm zkfd sdyye wjhu osjf ymk ddyylm wjdavcos ldzd oftcq xjkv pyyos tio qogb