Google Sheets: Some formulas are trying to send and receive data from external parties
Last verified
Warning: Some formulas are trying to send and receive data from external parties.What it means
This banner appears the first time an IMPORTHTML, IMPORTXML, IMPORTFEED, IMPORTDATA or IMAGE formula is added or edited in a spreadsheet. Google blocks those external requests until an editor clicks Allow access. Until then, existing imports stay blocked and cells do not load.
Google documents that only editors can act on the notification, that it appears once per spreadsheet, and that access cannot be revoked after it is accepted except by restoring an earlier version from Version history.
What is not wrong: your formulas. They will work once access is allowed.
What it looks like
Warning: Some formulas are trying to send and receive data from external parties.
[Allow access]Why it happens
- An import or IMAGE formula was added to a spreadsheet for the first time.
- You copied a template that contains import or IMAGE formulas.
- A script or integration wrote import formulas into the sheet.
- You are a viewer or commenter, so you see blocked imports but cannot approve them.
How to fix it
- Review which formulas reference external URLs before approving, especially in sheets you did not build.
- As an editor, click Allow access on the banner, or click a blocked formula cell and allow access from its prompt.
- If you are a viewer, ask an editor to allow access.
- On mobile, Google says to use a desktop browser, or request the desktop site in Chrome, to allow access.
How to stop it recurring
When you share templates that rely on external data, tell recipients to expect the banner and what it unlocks. Approve access only for sheets whose formulas you have reviewed, since an approved import can send cell data to the URL it calls.
Official documentation: support.google.com/docs/answer/12188454. See all Google Sheets error messages or the Google Sheets limits and quotas.
Related errors
Definitions
Quick answers
What does "Some formulas are trying to send and receive data from external parties" mean in Google Sheets?
This banner appears the first time an IMPORTHTML, IMPORTXML, IMPORTFEED, IMPORTDATA or IMAGE formula is added or edited in a spreadsheet. Google blocks those external requests until an editor clicks Allow access . Until then, existing imports stay blocked and cells do not load.
How do I fix "Some formulas are trying to send and receive data from external parties"?
1. Review which formulas reference external URLs before approving, especially in sheets you did not build. 2. As an editor, click Allow access on the banner, or click a blocked formula cell and allow access from its prompt. 3. If you are a viewer, ask an editor to allow access. 4. On mobile, Google says to use a desktop browser, or request the desktop site in Chrome, to allow access.
When an IMPORT formula cannot read the page
IMPORTXML and IMPORTHTML only see the HTML the server sends. An Autonoly extraction step reads the page in a real browser and writes rows to Google Sheets. Sites that block automated visitors can still block it.
Also see Google Sheets integration.