projects
clients
K
words
reviews
The easiest way to contact me is through social media. If you visit there, you’ll find posts tailored to your needs. Just leave a comment under any post, and I’ll respond. If you’d like to hire me, you can do so directly through Upwork.
I’m Biddrup Mallick, and I’m dedicated to helping businesses create meaningful, impactful content that resonates with their audience and aligns with their commitment to sustainability. As an individual service provider, I offer a range of content strategy services designed to boost your brand while promoting green initiatives and social responsibility.
Your Success, My Strategy
Quick Solutions
A script to collect Facebook, instagram, YouTube, LinkedIn, Email, X – Copy the code and check this video how to use it.
function extractInformation() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var dataRange = sheet.getDataRange();
var values = dataRange.getValues();
// Iterate through each row
for (var i = 0; i < values.length; i++) {
var url = values[i][0]; // Assuming the URLs are in column A
if (url !== "") {
try {
var htmlContent = fetchUrlContent(url);
// Extract email addresses, Facebook, LinkedIn, Instagram, Twitter, and YouTube links
var email = extractEmail(htmlContent);
var facebook = extractSocialLink(htmlContent, 'facebook');
var linkedin = extractSocialLink(htmlContent, 'linkedin');
var instagram = extractSocialLink(htmlContent, 'instagram');
var twitter = extractSocialLink(htmlContent, 'twitter');
var youtube = extractSocialLink(htmlContent, 'youtube');
// Write the extracted information to the corresponding columns
sheet.getRange(i + 1, 2).setValue(email); // Column B for email
sheet.getRange(i + 1, 3).setValue(facebook); // Column C for Facebook
sheet.getRange(i + 1, 4).setValue(linkedin); // Column D for LinkedIn
sheet.getRange(i + 1, 5).setValue(instagram); // Column E for Instagram
sheet.getRange(i + 1, 6).setValue(twitter); // Column F for Twitter
sheet.getRange(i + 1, 7).setValue(youtube); // Column G for YouTube
// Pause to avoid rate limiting
Utilities.sleep(1000);
} catch (error) {
// Log the error and continue to the next iteration
console.error(`Error processing ${url}: ${error}`);
}
}
}
}
function fetchUrlContent(url) {
try {
var response = UrlFetchApp.fetch(url);
return response.getContentText();
} catch (error) {
// If there's an error fetching the URL, throw it to be caught in the main try-catch block
throw `Error fetching content from ${url}: ${error}`;
}
}
function extractEmail(content) {
// Match email addresses using mailto: links
var emailRegex = /mailto:([^\s"']+)|[\w._%+-]+@[\w.-]+\.[a-zA-Z]{2,}/g;
var matches = content.match(emailRegex);
// If mailto: link is present, extract the email address
if (matches && matches.length > 0) {
return matches[0].startsWith("mailto:") ? matches[0].substring(7) : matches[0];
} else {
return "";
}
}
function extractSocialLink(content, platform) {
var regex = new RegExp(`https?:\\/\\/(?:www\\.)?${platform}\\.com\\/[^\\s"]+`, 'i');
var match = content.match(regex);
return match ? match[0] : "";
}