Sitemap Web Scraper Google Sheets Script (Title, URL, Date, Meta Description)

Unveil the power of automation and data mining with our Sitemap Web Scraper script for Google Sheets. This powerful tool lets you extract key information from any sitemap URL and organize it neatly in your Google Sheets document.

Features:

1. Extract Key Information: The script allows you to extract valuable data such as title, URL, published date, and meta description from all the pages in a sitemap.
2. Character Count: To aid your SEO efforts, the script counts the number of characters in the title and meta description.
3. One-Click Functionality: All it takes is a single click! Input your sitemap URL, click the 'Extract' button, and watch as your spreadsheet populates with data.
4. Clears Previous Data: To ensure your data is always fresh and relevant, the script automatically clears previous results each time it is run.

Who Is This For:

Ideal for digital marketers, SEO professionals, web administrators, and anyone who needs to extract and organize information from website sitemaps.

How To Use:

1. Make a copy of the Google Sheets document after purchase.
2. Paste your sitemap URL into cell A2.
3. Click the 'Extract' button.
4. You'll need to authorize the script to run on the Google sheet for the first time. Click on 'Continue.' Select your Google account, click 'Advanced,' and then 'Go to Extract URL, Title, Meta.'
5. The script requires permission to change the Google sheet and connect to external services to extract data. Don't worry - it's completely safe and won't affect your Google account or any other sheets in your account. Click 'Allow' to continue.
6. After authorization, click on the 'Extract' button once more.

Note: This script may not work for all websites due to varying website structures, security settings, or the presence of a robots.txt file.