Google Sheets + Schedule by Zapier + Close
Log weekly opportunity reports from Close.io in Google Sheets
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 Close.io 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.
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 Close.io 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.
- When this happens...
Every WeekTriggers every week, on the day(s) selected.
TriggerInstantThis event starts a Zap instantly. - automatically do this...
Run Opportunity ReportRuns an opportunity report for your organization. This report will return the data that you see at the top of the "Opportunities" page in Close.
ActionWriteCreate a new record or update an existing record in your app. - then do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Frequency TypeRequired
Interval
Start DateRequired
Time of DayRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Time Offset
Trigger on weekends?
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Day of the WeekRequired
Time of DayRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.
New Call Transcript
Triggers when a new call or voicemail transcript is added to Close.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Contact Smart View IDRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCustom Activity V 2 Instructions
Custom Activity TypeRequired
Filled-in fields
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Direction
Template ID
User ID
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Status ID
Old Status ID
Trigger on Lead Creation
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Object TypeRequired
ActionRequired
User ID
Changed Fields
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Status ID
New Status Type
Old Status ID
Old Status Type
Trigger on Opportunity Creation
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Workflow
ActionRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Completed?
Assigned to User
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Lead IDRequired
Address Label
Address 1
Address 2
City
State
Zipcode
Country
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TypeRequired
MetricsRequired
Date RangeRequired
Users
groups
Query
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.MetricsRequired
Date RangeRequired
Users
Groups
Query
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Template IDRequired
Lead Smart View or (deprecated) Search QueryRequired
Exclude leads that already received this email templateRequired
Contact PreferenceRequired
Send Done EmailRequired
Email Acccount
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LeadRequired
Contact ID
Phone Number
Direction
Duration
Text
Recording URL
User ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LeadRequired
Custom Activity TypeRequired
Created By User
StatusRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LeadRequired
Contact
StatusRequired
Date Created
Date Scheduled
To
Cc
Bcc
Subject
Body Text
Body HTML
Template
Follow-Up Date
Email Account ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email AddressRequired
RoleRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Lead IDRequired
Text TypeRequired
Attachments
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Report breakdownRequired
PipelineRequired
Report typeRequired
Report Period (range)
Report Period (dates)
Created Period (range)
Created Period (dates)
Comparison Period (range)
Comparison Period (dates)
Comparison Period (custom dates)
Smart View
Users or Groups
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LeadRequired
StatusRequired
Confidence
Value
Value Period
Close Date
Note
User
Contact ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ContactRequired
WorkflowRequired
Send emails from
Assign calls to
Send SMS from
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LeadRequired
Contact ID
Date Created
StatusRequired
Date Scheduled
Local PhoneRequired
Remote PhoneRequired
Text
Template
SourceRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Assigned To
LeadRequired
Date
TextRequired
Is Complete
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email AddressRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Email AddressRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact IDRequired
Name
Title
Email Addresses
Phone Numbers
Urls
Add to or Replace
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Custom Object IDRequired
Custom Object TypeRequired
Custom Object Name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Note IDRequired
Text TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SubscriptionRequired
ActionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Task IDRequired
Assigned To
Text
Date
Is Complete
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Direction
Note
User ID
Date Range
Find First Call on Lead
Lead ID
Or Search by Call ID
ActionThis is an event a Zap performs.SearchFind existing data in your appResult LimitRequired
Contact Name
Contact Title
Contact Email
Contact Phone
Lead ID
Search by Contact ID
ActionThis is an event a Zap performs.SearchFind existing data in your appResult LimitRequired
Custom Object TypeRequired
Lead ID
Custom Object Name
Search by Custom Object ID
ActionThis is an event a Zap performs.SearchFind existing data in your appCompany Name
Company Name Matching
Company URL
Email
Phone
Or Search by Lead ID
Or Use a Custom Search Query
ActionThis is an event a Zap performs.SearchFind existing data in your appNote Contains Words Starting With...
Lead ID
Or Search by Note ID
ActionThis is an event a Zap performs.SearchFind existing data in your appWorkflow
Contact ID
Lead ID
ActionThis is an event a Zap performs.SearchFind existing data in your appFull Name
Email
Or Search by User ID
ActionThis is an event a Zap performs.SearchFind existing data in your appCustom Activity TypeRequired
Status
LeadRequired
Search by Custom Activity ID
Custom Activity TypeRequired
Created By User
StatusRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundCompany Name
Company Name Matching
Company URL
Email
Phone
Or Search by Lead ID
Or Use a Custom Search Query
Company Name
Description
URL
Status
Contact Name
Contact Title
Contact Office Email
Contact Direct Email
Contact Home Email
Contact Other Email
Contact Office Phone
Contact Direct Phone
Contact Mobile Phone
Contact Home Phone
Contact Fax Phone
Contact Other Phone
Contact URL
Address Label
Address Street 1
Address Street 2
Address City
Address State
Address ZIP Code
Address Country
Note
Text
Note
Task Text
Task Due Date
Task Assignee
Note
Opportunity Status
Opportunity Value
Opportunity Value Period
Opportunity Confidence
Opportunity Date
Opportunity Note
Opportunity User
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundOpportunity Status ID
Opportunity Status Type
Opportunity Value
Opportunity Value Period
Opportunity Confidence
Opportunity Close Date
Opportunity User
Opportunity Note
LeadRequired
Or Search by Opportunity ID
StatusRequired
Confidence
Value
Value Period
Close Date
Note
User
Contact ID
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Time of DayRequired
Trigger on weekends?
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Day of the MonthRequired
Time of DayRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Call Recording
Triggers when a new call recording or voicemail is added to Close.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Contact
Triggers when a new contact is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Trigger ActionsRequired
Custom Object TypeRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Limitations
Lead Smart View
(deprecated) Search Query
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNote Contains Words Starting With...
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planStatus ID
Status Label
Status Type
Value Period
Assigned to User
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Unsubscribed Email
Triggers when a new email address is unsubscribed from Close.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Call IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact IDRequired
Email AddressRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source Lead IDRequired
Destination Lead IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Send Done EmailRequired
TypeRequired
Lead Smart View or (deprecated) Search QueryRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Action TypeRequired
Smart View or (deprecated) Search QueryRequired
Workflow ID
Send Done EmailRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.LeadRequired
Name
Title
Url
Office Phone
Mobile Phone
Home Phone
Direct Phone
Fax Phone
Other Phone
Office Email
Home Email
Direct Email
Other Email
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Lead IDRequired
Custom Object TypeRequired
Custom Object NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Export TypeRequired
FormatRequired
Lead Smart View or (deprecated) Search Query
Fields
Include Activities
Include Smart Fields
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Company Name
Description
URL
Status
Contact Name
Contact Title
Contact Office Email
Contact Direct Email
Contact Home Email
Contact Other Email
Contact Office Phone
Contact Direct Phone
Contact Mobile Phone
Contact Home Phone
Contact Fax Phone
Contact Other Phone
Contact URL
Address Label
Address Street 1
Address Street 2
Address City
Address State
Address ZIP Code
Address Country
Note
Text
Note
Task Text
Task Due Date
Task Assignee
Note
Opportunity Status
Opportunity Value
Opportunity Value Period
Opportunity Confidence
Opportunity Date
Opportunity Note
Opportunity User
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Lead Smart View or (deprecated) Search QueryRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Opportunity Query
Lead Smart View or (deprecated) Search Query
Status Types
Statuses
User IDs
Start Date
End Date
Or Use a Date Range Label
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.User ID
Start Date
End Date
Or Use a Date Range Label
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
QueryRequired
Share With Specific Users
Or Share With Organization
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Report TypeRequired
Lead Smart View or (deprecated) Search Query
Start Date
End Date
Or Use a Date Range Label
User ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Group(s) to Select From
Availability
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Phone NumberRequired
Call Forwarding Enable/DisableRequired
Forward to Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Call IDRequired
Contact
Text
Phone Number
Duration
Recording URL
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Custom Activity IDRequired
Custom Activity TypeRequired
Status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Lead IDRequired
Company Name
Description
Url
Status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Opportunity IDRequired
Assigned to User
Contact ID
Status
Confidence
Value
Value Period
Close Date
Notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Smart View IDRequired
Name
Query
Share With Specific Users
Or Share With Organization
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Copy Text
User ID
From Email Or Domain
From Name
ActionThis is an event a Zap performs.SearchFind existing data in your appCustom Activity TypeRequired
Status
Lead ID
Search by Custom Activity ID
ActionThis is an event a Zap performs.SearchFind existing data in your appGroup Name
Group ID
ActionThis is an event a Zap performs.SearchFind existing data in your appResult LimitRequired
Date
Assigned To
Status
Title
Lead ID
Search by Meeting ID
ActionThis is an event a Zap performs.SearchFind existing data in your appOpportunity Status ID
Opportunity Status Type
Opportunity Value
Opportunity Value Period
Opportunity Confidence
Opportunity Close Date
Opportunity User
Opportunity Note
Opportunity Lead ID
Or Search by Opportunity ID
ActionThis is an event a Zap performs.SearchFind existing data in your appAssigned To
Due Date
Description
Is Complete
Lead ID
Or Search by Task ID
ActionThis is an event a Zap performs.SearchFind existing data in your appResult LimitRequired
Contact Name
Contact Title
Contact Email
Contact Phone
Lead ID
Search by Contact ID
LeadRequired
Name
Title
Url
Office Phone
Mobile Phone
Home Phone
Direct Phone
Fax Phone
Other Phone
Office Email
Home Email
Direct Email
Other Email
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundResult LimitRequired
Custom Object TypeRequired
Lead ID
Custom Object Name
Search by Custom Object ID
Lead IDRequired
Custom Object TypeRequired
Custom Object NameRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNote Contains Words Starting With...
Lead IDRequired
Or Search by Note ID
Text TypeRequired
Attachments
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundAssigned To
Due Date
Description
Is Complete
Lead ID
Or Search by Task ID
Assigned To
LeadRequired
Date
TextRequired
Is Complete
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Text Bold
Text Italic
Text Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Google Sheets
Related categories
About Schedule by Zapier
Related categories
