For Insurance Underwriters ·
What you'll accomplish
Build and maintain a renewal tracking spreadsheet that uses Google Sheets' built-in AI to calculate loss ratios, sort by priority, and answer questions about your book of business — without a Microsoft 365 subscription. Identical outcome to Copilot in Excel, built on free tools.
What you'll need
Open a new Google Sheet. Click "Help me create" or the Gemini icon (sparkle symbol) in the toolbar.
Ask: "Create a renewal tracking table for an insurance underwriter with columns for: Account Name, Line of Business, Effective Date, Current Premium, Renewal Premium, 5-Year Incurred Losses, 5-Year Loss Ratio, Renewal Status (options: Pending, Quoted, Bound, Non-Renew), and Notes."
Gemini creates the table with headers. You now have a template ready for data entry.
Type your account data into the rows — or export from your policy system and paste. Even 15–20 accounts in the spreadsheet is enough to make the AI features useful.
Click the Gemini icon or use the sidebar. Ask:
"Calculate the 5-year loss ratio for each account (Column G ÷ Column D). Then create a formula to highlight any accounts with a loss ratio above 80% in red."
Gemini writes the formula and the conditional formatting rule for you. Apply them with one click.
Ask: "Sort this table by loss ratio from highest to lowest. Then add a column that categorizes each account as Green (loss ratio under 60%), Yellow (60–80%), or Red (over 80%)."
You now have a color-coded priority list for your renewal review — accounts needing the most attention are at the top.
With data in the sheet, ask: "Which line of business has the highest average loss ratio? What percentage of my book is commercial property vs. general liability?"
Gemini calculates and answers directly in the chat panel.