google-sheetsgoogle-sheets-formulagoogle-bucket

Using IMPORTDATA() with objects from google bucket

Does the '=IMPORTDATA()' function within google sheets, work when using URLs from google buckets?

I can only seem to get external URLs from other sites (AWS, etc.) to load when using the function.

Solution

  • You can try with the googleapis endpoint instead:

    =IMPORTDATA("https://storage.googleapis.com/mypublicbucket99/test2.txt")

    Reference: https://cloud.google.com/storage/docs/request-endpoints#typical