erayalakese

Parsing HTML using Google Apps Script

This is a sample script for parsing HTML using Google Apps Script. When HTML data is converted to Google Document, the HTML data can be parsed and be converted to Google Document. In this case, the paragraphs, lists and tables are included. From this situation, I thought that this situation can be used for parsing HTML using Google Apps Script. So I could came up with this method.

In the Sheet API, the HTML data can be put to the Spreadsheet with the PasteDataRequest. But unfortunately, in this case, I couldn't distinguish between the body and tables.

The flow of this method is as follows. In this sample script, the tables from HTML are retrieved.

	# This blacklist is ready to use in your site's root htaccess file

	# Banned websites and crawlers

	SetEnvIfNoCase Referer "^http://([a-z0-9\-]+\.)*semaltmedia\.com(/\|:\|$)" banned
	SetEnvIfNoCase Referer "^http://([a-z0-9\-]+\.)*100dollars-seo\.com(/\|:\|$)" banned
	SetEnvIfNoCase Referer "^http://([a-z0-9\-]+\.)*12masterov\.com(/\|:\|$)" banned
	SetEnvIfNoCase Referer "^http://([a-z0-9\-]+\.)*4webmasters\.org(/\|:\|$)" banned
	SetEnvIfNoCase Referer "^http://([a-z0-9\-]+\.)*7makemoneyonline\.com(/\|:\|$)" banned
	SetEnvIfNoCase Referer "^http://([a-z0-9\-]+\.)*acads\.net(/\|:\|$)" banned

	<?php

	$iller = array('','Adana', 'Adıyaman', 'Afyon', 'Ağrı', 'Amasya', 'Ankara', 'Antalya', 'Artvin',
	'Aydın', 'Balıkesir', 'Bilecik', 'Bingöl', 'Bitlis', 'Bolu', 'Burdur', 'Bursa', 'Çanakkale',
	'Çankırı', 'Çorum', 'Denizli', 'Diyarbakır', 'Edirne', 'Elazığ', 'Erzincan', 'Erzurum', 'Eskişehir',
	'Gaziantep', 'Giresun', 'Gümüşhane', 'Hakkari', 'Hatay', 'Isparta', 'Mersin', 'İstanbul', 'İzmir',
	'Kars', 'Kastamonu', 'Kayseri', 'Kırklareli', 'Kırşehir', 'Kocaeli', 'Konya', 'Kütahya', 'Malatya',
	'Manisa', 'Kahramanmaraş', 'Mardin', 'Muğla', 'Muş', 'Nevşehir', 'Niğde', 'Ordu', 'Rize', 'Sakarya',
	'Samsun', 'Siirt', 'Sinop', 'Sivas', 'Tekirdağ', 'Tokat', 'Trabzon', 'Tunceli', 'Şanlıurfa', 'Uşak',
	'Van', 'Yozgat', 'Zonguldak', 'Aksaray', 'Bayburt', 'Karaman', 'Kırıkkale', 'Batman', 'Şırnak',

	<?php

	/*
	Plugin Name: R Debug
	Description: Set of dump helpers for debug.
	Author: Andrey "Rarst" Savchenko
	Author URI: https://www.rarst.net/
	License: MIT
	*/

erayalakese

Parsing HTML using Google Apps Script

Flow