Google Sheets IMPORTDATA with csv not working

Hey there,

wondering if anyone else has run into this or figured out a workaround.
I’m using Metabase 0.24.2 on Heroku, public sharing is enabled.

When I import a Question as a csv into a Google Sheet via the IMPORTDATA function, all works well for about an hour, then the formula errors either with “Internal Import Error.” or “Resource under https://xyz.csv could not be found.”.

When I use Heroku dataclips with the exact same logic everything is fine and the data is always visible.

Anyone else experienced this?