Automated SEO Meta Tag Shortening Workflow

This n8n workflow is designed to automate the process of optimizing meta tags SEO for blog posts or web content. It starts with a scheduled trigger, fetching existing meta titles and descriptions from a Google Sheet. The workflow then processes each row by utilizing the Google Gemini Chat Model to shorten meta titles to a maximum of 60 characters and descriptions to 160 characters, ensuring they retain core keywords and the original intent. The JSON responses from Gemini are cleaned, flattened, and formatted into a flat table, then updated back into the Google Sheet with the refined meta tags. This automation helps enhance SEO effectiveness effortlessly, especially when managing large content updates or optimizing existing pages.