Close + Formcrafts + Google Sheets Integrations
How to connect Close + Formcrafts + Google Sheets
Zapier lets you send info between Close and Formcrafts and Google Sheets automatically—no code required. With 7,000+ supported apps, the possibilities are endless.
Choose a Trigger
Start here
Start here
Choose an Action
Choose an Action
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Close + Formcrafts + Google Sheets
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Close, Formcrafts, and Google Sheets. And don’t forget that you can add more apps and actions to create complex workflows.
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 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
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 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
Top companies trust Zapier to automate work and free up time
Join millions worldwide who automate their work using Zapier
How Close + Formcrafts + Google Sheets Integrations Work
- Step 1: Authenticate Close, Formcrafts, and Google Sheets.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.
About Close
Close is a sales productivity platform built to help you close more deals. With built-in calling, SMS, and email—your team can communicate with prospects and customers all in one place. It’s an "all-in-one" platform which you can use standalone without needing any other sales emails tools or calling products.
Related categories
Related categories
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
