Data not importing from metabase into google sheets using IMPORTDATA

Hi just a few hours back I was using the import data function of google sheets to get data from metabase but now it is showing error of "Could not fetch URL". Can you please see to what the issue is?

Are you running in Metabase Cloud just by chance?

Yes, the current metabase we are using is based on cloud.

Please write to our support email, we’ve identified that there’s an issue on the Google side unfortunately and you need a custom function