Hello @-Jaye
That is great news and a great way to do it. What you could do it write a simple Java script Script. I've added an example.
This will go through the list of the links. Until all links have been has been hit.
const links = [
'https://example.com',
'https://another-example.com',
// Add more links as needed
];
async function callLinks(linkList) {
for (const link of linkList) {
try {
const response = await fetch(link);
console.log(`Successfully called ${link}, Status Code: ${response.status}`);
} catch (error) {
console.error(`Failed to call ${link}, Error: ${error}`);
}
}
}
// Call the function with the list of links
callLinks(links);
If you have a Google on how to run these for the computer your on there should be enough documentation out there to get this running. Let me know if you have any trouble.
If there hyperlink creation part takes alot of time we can look at that aswell. But I'm hoping it's just a drag down the sheet job.
