Automate sales & marketing forecast calculations with this add-on. Get weekly, monthly, quarterly forecasts and pacing for business KPIs and marketing spend.
Listing updated:December 8, 2022
Works with:

Are you tired of using outdated forecasting templates, creating pivot tables and doing multiple calculations using a mix of Excel formulas to manually forecast next month’s business KPIs every month and having to re-do these calculations when the trend changes?

What about trying to forecast your marketing spend on Google or Facebook/Instagram or Tik Tok at the beginning, middle, last week of the month to ensure you’re pacing at or below budget?

Or perhaps your forecasts in the past haven’t been very accurate and you’re looking for other methods to do your forecasting?

If any of the aforementioned scenarios describe your situation, Forecast Method may very well be the add-on you’ve been looking for.

Forecast Method is an add-on for Google Sheets™ that enables businesses to automate their forecasting process with a click of a button and provides their users with several forecasting methods so you can choose the method that most accurately forecasts your business results. 

This tool was created by a marketer and can be used for sales and marketing forecasting.

How it works

Input your raw daily data in a worksheet and click “Run Forecast” and you’ll generate a new worksheet that forecasts your KPIs for the next week/month/quarter from the last data point inputted.

You can turn historical raw data into a more insightful view with multiple forecast methods so you can choose the technique that most accurately forecasts your business KPIs.

Benefits & Features

- Save time by automating the analytical process of weekly, monthly, quarterly forecasting to help you plan sales quota, marketing KPI performance, budget, etc.
- See how you’re pacing for the month with month-to-date totals and in-month pacing based on daily KPI trends
- Track total marketing spend and how you’re pacing budget-wise on the various ad platforms such as Google AdWords™, Meta (Facebook/Instagram), or Microsoft (Bing) so you know if you’re pacing under or over budget
- Choose from multiple forecasting methods to better forecast your business KPI performance
- Each forecasting technique will adjust its forecast as more data comes in
- A new worksheet will be generated for each additional business KPI you want to forecast (just simply add another column)


Google Sheets™ and Google AdWords™ are trademarks of Google LLC
Additional information
PricingFree of charge with paid features
Privacy policy
Terms of service
Forecast Method will ask for the permissions shown below. Learn more
Forecast Method will need access to your Google account
This will allow Forecast Method to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Clear search
Close search
Google apps
Main menu