Google Sheets enable Import after creating Spreadsheet

How To
1

Scenario:

  1. Create a new spreadsheet from a template.
  2. Add URLs to certain cells and use the IMAGE function in the next column to display the linked pictures.

Problem:
Each time a new spreadsheet is created, it requires manual permission to allow “external parties” access to the data, showing a warning:
“Warning: Some formulas are trying to send and receive data from external parties.”

Goal:
Automate the process to approve external data access automatically when a new spreadsheet is created, so I don’t have to open each sheet and manually click “Allow.”

Bildschirmfoto 2024-11-15 um 13.33.46
Bildschirmfoto 2024-11-15 um 13.33.463790×978 110 KB

2

I post a lot to google sheets with no problem. Even new ones. It might be a google account setting somewhere.

create a google sheet and build a column
create a google sheet and build a column1210×266 39.2 KB

3

you use the IMAGE function? Text is working fine.

6

Hello everyone. I just wanted to share this for anyone who’s still looking for a solution:

Here’s an API call that will update the parameter of the spreadsheet:

image
image814×1262 86.1 KB

Here are the details:

  1. after the spreadsheet ID in the URL: :batchUpdate
  2. Method: POST
  3. Body of the request
{
  "requests": [
    {
      "updateSpreadsheetProperties": {
        "properties": {
          "importFunctionsExternalUrlAccessAllowed": true
        },
        "fields": "importFunctionsExternalUrlAccessAllowed"
      }
    }

  ]
}

Hope this helps.

1 Like