Google sheets calculator for revenue

Job ID: 37108851

Budget: $250 – $750 USD

I am looking for the following.

1. Taking a snapshot of all the opportunities and Salesforce every day on a new sheet in google sheets.
2. Having a sheet that gives me a dashboard of all the metrics I care about based on the data that is available.
3. One sheet that would be a Calculator or I can input what I want to achieve in revenue next year and what I need to generate and pipeline as well as what I need to hire as far as account executives.