Close + Google Sheets + Formatter by Zapier
Create lead in Close from formatted Google Sheet entries
Manually copying leads from spreadsheets into your CRM slows down your sales process and risks introducing errors. This Zap automatically formats new Google Sheets entries, standardizing contact details, and creates a lead in Close for each entry. Now, your sales team can instantly act on accurate, well-organized leads without manual effort or delay.
Manually copying leads from spreadsheets into your CRM slows down your sales process and risks introducing errors. This Zap automatically formats new Google Sheets entries, standardizing contact details, and creates a lead in Close for each entry. Now, your sales team can instantly act on accurate, well-organized leads without manual effort or delay.
- When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this...
TextWork with text data to find & replace, capitalize, remove HTML, and more (with line-item support).
ActionWriteCreate a new record or update an existing record in your app. - then 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
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier 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.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
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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.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.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 foundTransformRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TransformRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Field(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
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
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
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
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 found
No 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 ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
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.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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
Bold
Italic
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
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundTransformRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TransformRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record 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.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
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
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 Google Sheets
Related categories
