Close + Smartsheet
Create leads in Close for each new row in Smartsheet
Streamline your lead generation process with this workflow. When a new row is added in Smartsheet, this automation instantly creates a lead in Close. Save time, eliminate manual data entry and ensure all valuable leads from Smartsheet are promptly captured in your Close pipeline.
Streamline your lead generation process with this workflow. When a new row is added in Smartsheet, this automation instantly creates a lead in Close. Save time, eliminate manual data entry and ensure all valuable leads from Smartsheet are promptly captured in your Close pipeline.
- When this happens...
New RowTriggers when a new row is added.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create LeadCreates a New Lead
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Get Reports
[PRIVATE] Generates report list for dropdown.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planWorkspace NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose a SheetRequired
RowRequired
TitleRequired
CommentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Source FolderRequired
Destination FolderRequired
New Folder NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.WorkspaceRequired
New NameRequired
What to Include?
Skip Remap
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose Source SheetRequired
Choose a Destination SheetRequired
Choose RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DestinationRequired
TemplateRequired
Copy Cells?Required
Copy Attachments?Required
Copy Discussions?Required
Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose a SheetRequired
Email Address(es)Required
Choose RowRequired
Email Subject
Message
CC Me?
Include Attachments ?
Include Discussions ?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose a SheetRequired
Email Address(es) to Share ToRequired
Access LevelRequired
Notify via Email?Required
Email Subject
Message
CC Me?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Sheet IDRequired
Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
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 ZapPollingZapier checks for new data every 15 min on the Free planNote Contains Words Starting With...
Try ItTriggerThis is the start of your ZapPollingZapier 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.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.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.Lead
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
Outcome
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
Attachments
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.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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
Lead ID
User ID
Direction
Message Text
External WhatsApp Message ID
Local Phone
Remote Phone
Search by WhatsApp Message 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
Lead
Or Search by Opportunity ID
StatusRequired
Confidence
Value
Value Period
Close Date
Note
User
Contact ID
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 foundResult LimitRequired
Lead ID
User ID
Direction
Message Text
External WhatsApp Message ID
Local Phone
Remote Phone
Search by WhatsApp Message ID
Lead IDRequired
Contact IDRequired
DirectionRequired
Message TextRequired
Local PhoneRequired
Remote PhoneRequired
External WhatsApp Message IDRequired
Integration Link
Response To Activity ID
Activity At
Attachments
Send to Inbox
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
Updated Row
Triggers when cells in a row are updated or created (based on your settings).
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.SheetRequired
RowRequired
File AttachmentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose a SheetRequired
Add Row to Top or Bottom
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose Source SheetRequired
Choose a Destination SheetRequired
Choose RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SheetRequired
ColumnRequired
Parent Row
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DestinationRequired
Sheet to CopyRequired
Copy Cells?Required
Copy Attachments?Required
Copy Discussions?Required
Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose a SheetRequired
Row IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose a SheetRequired
Email Address(es)Required
FormatRequired
Email Subject
Message
CC Me?
Paper Size
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Choose a WorkspaceRequired
Email Address(es) to Share ToRequired
Access LevelRequired
Notify via Email?Required
Email Subject
Message
CC Me?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Find sheet Row (Legacy)
Find a row in a specified sheet using a query.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Sheet IDRequired
QueryRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appField(s) Required to Trigger
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Contact Smart View IDRequired
Try ItTriggerThis is the start of your ZapPollingZapier 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
Contact IDRequired
DirectionRequired
Message TextRequired
Local PhoneRequired
Remote PhoneRequired
External WhatsApp Message IDRequired
Integration Link
Response To Activity ID
Activity At
Attachments
Send to Inbox
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
Outcome
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
Attachments
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.Lead
StatusRequired
Confidence
Value
Value Period
Close Date
Note
User
Contact ID
Attachments
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
Attachments
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
Outcome
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 appResult LimitRequired
Contact Name
Contact Title
Contact Email
Contact Phone
Lead ID
Search by Contact ID
Lead
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 found
About Close
Related categories
About Smartsheet
Related categories
Related Zap Templates
- Add new Close leads to Smartsheet rows for seamless tracking and organization
- Create Smartsheet rows for new Close leads
- Create Smartsheet discussions for new Close leads in rows
- Add new Close contacts to Smartsheet rows for seamless organization
- Update Smartsheet rows with new Close leads for efficient tracking