💰 Finance & Accounting

Build a simple 12-month forecast in Google Sheets

💰 Finance & AccountingGeminiIntermediate

Task · Forecasting
Time saved · 1-2 hrs per forecast (estimate, not measured)

Steps

1. Open the sheet in Google Sheets
2. Open the Gemini side panel
3. Enter the prompt
4. Verify results against a pivot table or manual check

Prompt / template

Using the monthly revenue history in columns A-B, create a 12-month forecast with a 3-month moving average and a growth-rate scenario, in a new table.

Source · https://support.google.com/docs/answer/14218565
Last checked · 2026-10-16

More Finance & Accounting workflows →