Please create a official API add-on for Google Sheets. Would love to get direct access to backlink data without making any exports.
Not sure if this will work, but worth a shot. In Google Sheets...
Have the domain or whatever you are trying to collect data from in cell "A2"
Then in cell "B2", add something like this (replace SEMRush url with the appropriate Ahrefs url):
Would be great to have the IMPORTXML function of Google Spreadsheets also working for the API! :)
+1 on this