Built a custom integration between

Built a custom integration between Google Sheets and Gemini API using Google Apps Script. The system processes unstructured email content from body and attachments, sends it to the AI model, and converts it into clean, structured data directly inside Google Sheets. Extracted fields are automatically mapped into predefined columns, enabling further automation, reporting, and analysis. The solution includes custom prompt handling, API optimization, error handling.