Sitemap.xml metadata export to Google Sheets (Title, Meta Description, and URLs)

This workflow automates the extraction of SEO metadata (URL, page title, and meta description) from every page listed in your website's sitemap and exports it to Google Sheets. Ideal for SEO audits, content inventories, and tracking on-page elements.

Prerequisites

Before using this workflow: - A publicly accessible sitemap.xml URL - Google Sheets spreadsheet with columns: URL, Title, and meta description - Google Sheets API access via OAuth2

Setup Instructions

1. Configure Sitemap Source - In the "Get Sitemap XML" node, replace the default URL with your actual sitemap URL

2. Connect Google Sheets - Open the "Append or update row in sheet" node - Configure Google Sheets credentials - Set Document ID and Sheet Name - Verify column mappings match your spreadsheet

3. Adjust Rate Limiting (Optional) - Modify Wait nodes if encountering 429 errors - Increase delay between requests if needed

How It Works