Google Sheets
When this happens...
Schedule by ZapierEvery Week
do these tasks!
CloseRun Opportunity Report
Google SheetsCreate Spreadsheet Row

Want to know how your sales team is performing week after week? Adding your team's data to a spreadsheet is a great way analyze their weekly performance metrics but manually inputting the information each week can be a time-consuming process. Once activated, a new opportunity report from will be generated on a specified day and time each week. Zapier will then log the report's results as a new row in Google Sheets automatically.

How this Schedule by Sheets integration works

  1. Pick a day and time each week that you want to generate a report
  2. runs an opportunity report
  3. Zapier adds the results to Google Sheets

Apps involved

  • Schedule by Zapier
  • Google Sheets

Why Zapier?


Get started for free—14 day trial of premium features and apps.


No coding required—automate any of 1,500+ apps in minutes.


Enterprise-level security—connect mission-critical apps.

It's easy to connect Google Sheets + Schedule by Zapier and requires absolutely zero coding experience—the only limit is your own imagination.

When this happens...
then do this!
New Spreadsheet Row

Triggered when a new row is added to the bottom of a spreadsheet.

Create Worksheet

Create a blank worksheet with a title. Optionally, provide headers.

New or Updated Spreadsheet Row

Triggered when a new row is added or modified in a spreadsheet.

Create Spreadsheet Row

Create a new row in a specific spreadsheet.

Every Week

Triggers every week, just choose what day of the week.

Update Spreadsheet Row

Update a row in a specific spreadsheet.

Every Day

Triggers daily, just choose at what hour of time.

Create Spreadsheet Row(s)

Create one or more new rows in a specific spreadsheet (with line item support).

Every Month

Triggers every month, just choose what day of the month.

Create Spreadsheet Column

Create a new column in a specific spreadsheet.

Use our free platform to build a single Zapier integration and instantly connect your app with 1,500+ others.

Become a Zapier Integration Partner

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn More

What is Schedule by Zapier?


Schedule is a native Zapier app you can use for recurring tasks. Trigger an action every day of the month, every day of the week or every single day. You can also select the hour of the day. If you're a developer, this is similar to a crontab, cronjob or cron.

See Schedule Integrations