Importdata on Google Sheets giving #N/A

[sudeep]

No worries, I found the answer. We have a basic authentication set up for Metabase, so I just had to write a Google Apps script to go around it.