Copy button to copy the code snippet.function importDataFromWeb() {
var url = "www.example.com"; // Replace with the correct URL of the webpage
var filterValues = [""]; // Specify the values to filter on
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
// Fetch the webpage content
var response = UrlFetchApp.fetch(url);
var content = response.getContentText();
// Regex to extract table, rows, and cells
var tableRegex = /<table[^>]*>([\s\S]*?)<\/table>/g;
var rowRegex = /<tr[^>]*>([\s\S]*?)<\/tr>/g;
var cellRegex = /<t[hd][^>]*>([\s\S]*?)<\/t[hd]>/g;
// Find all tables in the page
var tables = content.match(tableRegex);
if (tables) {
tables.forEach(function(table) {
var rows = table.match(rowRegex);
if (rows) {
rows.forEach(function(row) {
var cells = row.match(cellRegex);
if (cells) {
// Check if all filter values exist in the row
var matchFound = filterValues.every(function(filterValue) {
return cells.some(function(cell) {
return cell.includes(filterValue);
});
});
if (matchFound) {
// Specify the desired column indexes to import (starting from 0)
var columnIndexes = [0, 1, 2, 3]; // Example: Import first 4 columns
// Extract cell values and remove HTML tags
var values = columnIndexes.map(function(index) {
var cell = cells[index];
return cell ? cell.replace(/<\/?[^\>]+>/g, '') : '';
});
// Append the extracted row to the sheet
sheet.appendRow(values);
}
}
});
}
});
} else {
Logger.log("No table found on the webpage.");
}
}