Optimize SEO Meta Tags in Google Sheets with Google Gemini

🔁 Loop & Optimize Meta Tags with Google Gemini This workflow automates the shortening of meta titles and descriptions for SEO—directly from your Google Sheet, row by row, using Google Gemini. ✅ What it does Reads rows from a Google Sheet (metatitle, metadescription, rowindex) Loops through each row and checks if content exists Sends the data to Google Gemini for length-optimized output Cleans and parses the response Updates the original sheet with the shortened results 🛠️ Setup Requirements Google Sheets (OAuth2 credentials connected in n8n) Google Gemini API key (configured in n8n credentials) Sheet must contain: rowindex metatitle metadescription Output will be written into: metatitleFix

Help me set up the n8n workflow "Optimize SEO Meta Tags in Google Sheets with Google Gemini" (https://n8n.io/workflows/5411). It uses: Google Sheets, Code, AI Agent, Google Gemini Chat Model. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.