How to connect Close + Google Sheets
Zapier lets you send info between Close and Google Sheets automatically—no code required.
Top companies trust Zapier to automate work and free up time
Popular Close + Google Sheets workflows
- Send newly-updated Google Sheets rows to Close as leads
Send newly-updated Google Sheets rows to Close as leads
- Log weekly opportunity reports from Close.io in Google Sheets
Log weekly opportunity reports from Close.io in Google Sheets
- Create Google Sheets rows for new opportunity statuses in Close
Create Google Sheets rows for new opportunity statuses in Close
- Track lead status changes in Close in Google Sheets
Track lead status changes in Close in Google Sheets
Connect your apps and automate workflows
Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.


Do Even More with Close + Google Sheets
With Zapier, you can do more than just connect 2 apps—you can automate entire processes from beginning to end! Here are some popular ways users make their Close + Google Sheets workflows do more for them.
Zapier users love adding Schedule by Zapier to their workflows
Log weekly opportunity reports from Close.io in Google Sheets
Log weekly opportunity reports from Close.io in Google SheetsPremium
- New Call RecordingTriggers when a new call recording or voicemail is added to Close.Trigger
- New CallTriggers when a new Call is created or completed.Trigger
- New Contact in Contact Smart ViewTriggers when a new Contact is added to a Contact Smart View.Trigger
- New ContactTriggers when a new contact is created.Trigger
- New or Updated Custom ActivityTriggers when a Custom Activity is created or updated.Trigger
- New EmailTriggers when a new incoming Email is created or an outgoing Email is sent.Trigger
- New ExportTriggers when a new Export is created or completed.Trigger
- New Inbox ItemTriggers when a new item appears in your Close inbox.Trigger
- Close
Triggers when a new lead is created.
Instant
Trigger
- Close
Triggers when a lead enters a new status. Optionally trigger when a lead is created in a status.
Instant
Trigger
- Close
Triggers when a new lead is added to a search query or Smart View.
Scheduled
Trigger
- Close
Triggers when a Meeting is scheduled, started, completed, or canceled.
Instant
Trigger
- Close
Triggers when a new membership is added to or removed from your Close organization.
Instant
Trigger
- Close
Triggers when a new event is created.
Instant
Trigger
- Close
Triggers when a new Note is created.
Scheduled
Trigger
- Close
Triggers when an opportunity enters a new status. Optionally trigger when an opportunity is created in a status.
Instant
Trigger
- Close
Triggers when a new opportunity is added.
Instant
Trigger
- Close
Triggers when a contact is subscribed to a sequence, when a sequence subscription is paused, resumed, finished, has reached its goal, or has encountered an error.
Instant
Trigger
- Close
Triggers when a new inbound SMS is created or an outbound SMS is sent.
Instant
Trigger
- Close
Triggers when a new task is created or completed.
Instant
Trigger
- Close
Adds an address to a lead.
Scheduled
Action
- Close
Delete logged call.
Scheduled
Action
- Close
Delete an email on a lead.
Scheduled
Action
- Close
Deletes a single email address from an existing contact.
Scheduled
Action
- Close
Exports an activity overview or an activity comparison report to a CSV file.
Scheduled
Action
- Close
Merges one lead into another lead.
Scheduled
Action
- Close
Runs an activity overview report for your organization.
Scheduled
Action
- Close
Creates a new bulk action. You can choose from "Update the Lead Status," "Update a Custom Field," and "Clear a Custom Field".
Scheduled
Action
- Close
Creates a new bulk email.
Scheduled
Action
- Close
Creates a new bulk sequence subscription action.
Scheduled
Action
- Close
Creates a new call.
Scheduled
Action
- Close
Creates a new Contact.
Scheduled
Action
- Close
Creates a new Custom Activity.
Scheduled
Action
- Close
Creates a new email.
Scheduled
Action
- Close
Creates a new export of leads, opportunities, or contacts, based on a lead search query, that will be emailed to your email address.
Scheduled
Action
- Close
Invites a user to join your Close organization.
Scheduled
Action
- Close
Creates a New Lead
Scheduled
Action
- Close
Creates a new note.
Scheduled
Action
- Close
Find the total number of leads in a given query.
Scheduled
Action
- Close
Runs an Opportunity Funnel report for your organization.
Scheduled
Action
- Close
Runs an opportunity report for your organization. This report will return the data that you see at the top of the "Opportunities" page in Close.
Scheduled
Action
- Close
Creates a new opportunity.
Scheduled
Action
- Close
Runs a sent email report for your organization.
Scheduled
Action
- Close
Subscribes a contact to a sequence.
Scheduled
Action
- Close
Creates a new Lead Smart View.
Scheduled
Action
- Close
Creates a new SMS.
Scheduled
Action
- Close
Runs a status change report for your organization.
Scheduled
Action
- Close
Creates a new Task.
Scheduled
Action
- Close
Select a random user from your organization.
Scheduled
Action
- Close
Turn on and off call forwarding for a specific number.
Scheduled
Action
- Close
Updates an existing Call.
Scheduled
Action
- Close
Updates an existing Contact.
Scheduled
Action
- Close
Updates an exisiting Custom Activity.
Scheduled
Action
- Close
Updates an existing Lead.
Scheduled
Action
- Close
Updates an existing Note.
Scheduled
Action
- Close
Updates an existing Opportunity.
Scheduled
Action
- Close
Updates an existing Sequence Subscription.
Scheduled
Action
- Close
Updates an existing Lead Smart View.
Scheduled
Action
- Close
Updates an existing Task.
Scheduled
Action
- Close
Find an existing call.
Scheduled
Action
- Close
Find a Connected Account you can use to send emails.
Scheduled
Action
- Close
Finds an existing contact.
Scheduled
Action
- Close
Finds an existing Custom Activity.
Scheduled
Action
- Close
Find an existing lead.
Scheduled
Action
- Close
Find an existing note.
Scheduled
Action
- Close
Find an existing Opportunity.
Scheduled
Action
- Close
Find an existing sequence subscription.
Scheduled
Action
- Close
Find an existing task.
Scheduled
Action
- Close
Find an existing Close user.
Scheduled
Action
- Close
Find or Create Contact
Scheduled
Action
- Close
Find or Create Custom Activity
Scheduled
Action
- Close
Find or Create Lead
Scheduled
Action
- Close
Find or Create Note
Scheduled
Action
- Close
Find or Create Opportunity
Scheduled
Action
- Close
Find or Create Task
Scheduled
Action
- Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
Scheduled
Trigger
- Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet.
Instant
Trigger
- Google Sheets
Triggered when you create a new spreadsheet.
Scheduled
Trigger
- Google Sheets
Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
Scheduled
Trigger
- Google Sheets
Triggered when a new row is added or modified in a spreadsheet.
Instant
Trigger
- Google Sheets
Triggered when you create a new worksheet in a spreadsheet.
Scheduled
Trigger
- Google Sheets
Create a new column in a specific spreadsheet.
Scheduled
Action
- Google Sheets
Create a new row in a specific spreadsheet.
Scheduled
Action
- Google Sheets
Create one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
- Google Sheets
Create a new worksheet by copying an existing worksheet.
Scheduled
Action
- Google Sheets
Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
Scheduled
Action
- Google Sheets
Create a blank worksheet with a title. Optionally, provide headers.
Scheduled
Action
- Google Sheets
Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.
Scheduled
Action
- Google Sheets
Format a row in a specific spreadsheet.
Scheduled
Action
- Google Sheets
Update a row in a specific spreadsheet.
Scheduled
Action
- Google Sheets
Update one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
- Google Sheets
Finds many matched rows (500 max.) by a column and value.
Scheduled
Action
- Google Sheets
Finds a worksheet by title.
Scheduled
Action
- Google Sheets
Returns many rows (500 max.) as a single JSON value and flat rows (line items).
Scheduled
Action
- Google Sheets
Finds a row by a column and value. Returns the entire row if one is found.
Scheduled
Action
- Google Sheets
Finds or creates a specific find worksheet.
Scheduled
Action
- Google Sheets
Finds or creates a specific lookup row.
Scheduled
Action
How Close + Google Sheets Integrations Work
- Step 1: Authenticate Close 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.
Google Sheets Tutorials
Related categories
Related categories
Get started for free
You can't add more hours to the day. Zapier is the next best thing.