ahref_airtable.js

const AirtablePlus = require('airtable-plus');
const fetch = require('node-fetch');

const airtable = new AirtablePlus({
    baseID: 'app6ttxB70e3TjmCL',
    apiKey: 'AIRTABLE_API_KEY',
    tableName: 'Themes',
});

const token = 'AHREF_API_TOKEN';

(async () => {

    try {
        const themes = await airtable.read({ view: 'Newsroom', filterByFormula: `({UR} = '')`});

        for (let theme of themes) {
            console.log(`Running report for ${theme.fields.Url}`);

            try {
                const url = encodeURIComponent(theme.fields.Url);

                const urlRating = await fetch(`https://apiv2.ahrefs.com/?token=${token}&from=ahrefs_rank&target=${url}&limit=10&output=json&mode=exact`)
                    .then(response => response.json())
                    .then(data => {
                        return data.pages[0].ahrefs_rank;
                    });

                const domainRating = await fetch(`https://apiv2.ahrefs.com/?token=${token}&from=domain_rating&target=${url}&limit=10&output=json&mode=exact`)
                    .then(response => response.json())
                    .then(data => {
                        // could also use ahrefs_top
                        return data.domain.domain_rating;
                    });

                const referringDomainsRating = await fetch(`https://apiv2.ahrefs.com/?token=${token}&from=refdomains&target=${url}&limit=10&output=json&mode=exact`)
                    .then(response => response.json())
                    .then(data => {
                        return data.stats.refdomains;
                    });

                const organicTraffic = await fetch(`https://apiv2.ahrefs.com/?token=${token}&from=positions_metrics&target=${url}&limit=10&output=json&mode=exact`)
                    .then(response => response.json())
                    .then(data => {
                        return data.metrics.traffic;
                    });


                const data = {
                    'UR' : urlRating/100,
                    'DR' : domainRating/100,
                    'Referring Domains' : referringDomainsRating,
                    'Traffic Estimate' : organicTraffic,
                }

                console.log(data);
                await airtable.update(theme.id, data);
            } catch (Error) {
                console.log(Error);
            }
        }

    } catch (Error) {
        console.log(Error);
    }

})();