Cloze + Google Sheets

Add new Google Sheets rows to create or update people in Cloze

Efficiently manage your contacts by connecting Google Sheets and Cloze with this seamless workflow. When a new row is added to your spreadsheet, a person will be created or updated in the Cloze app, ensuring all information is up-to-date and accessible. This automation streamlines your contact management, allowing you to focus on building stronger relationships.

When this happens...
New Spreadsheet Row
Triggers when a new row is added to the bottom of a spreadsheet.
TriggerInstant
automatically do this!
Create/Update a Person
Creates or updates a person.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

- Dont Change Sheet Structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- Dont Change Sheet Structure
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write

- Drive
- SpreadsheetRequired
- WorksheetRequired
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Source RangeRequired
- Destination RangeRequired
- Paste Type
Action
Write

- Drive
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Validation TypeRequired
- Input Message
- Strict Validation
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
Action
Search
- Spreadsheet IDRequired
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write
- Filters
Trigger
Instant
Try It
- Filters
Trigger
Instant
Try It
- Company NameRequired
- Keyword
- Description
- Keywords
- Industry
- Business Size
- No. Of Employees
- Domains
- Notes
- Share To
- Assign To
- Default Assign To
- Node
- Stage
- Segment
- List
- Remove List
- Facebook
- Twitter
- LinkedIn
- Street Address
- City
- Region
- Postal Code
- Country
- Phone
- Url
- Source App ID
- Source App Link Name
- Source App Link URL
- Source Entity Unique ID
- Additional Fields
Action
Write
- Source App IDRequired
- Source Note IDRequired
- Author Name
- Author Address
- About Name
- About Address
- Subject
- Body
- Body Type
- Source App Name
- Source App URL
- Additional Fields
Action
Write
- Project NameRequired
- Keyword
- Summary
- Keywords
- Notes
- Node
- Project Type
- Project Value
- Stage
- Created (Potential) Date
- Planned Start (Active) Date
- Planned End (Won or Lost) Date
- Source App Name
- Source App URL
- Source App IDRequired
- Source Project Unique IDRequired
- Additional Fields
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write

- Dont Change Sheet Structure
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Dont Change Sheet Structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Condition TypeRequired
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Confirm DeletionRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Format TypeRequired
Action
Write
- SpreadsheetRequired
- WorksheetRequired
- New Sheet NameRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Cell RangeRequired
- Sort by ColumnRequired
- Sort OrderRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- A1 RangeRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write
- Filters
Trigger
Instant
Try It
- StyleRequired
- From Name
- From AddressRequired
- Recipient Name
- Recipient Address
- Subject
- Body
- Body Type
- Skip Inbox
- Thread ID
- Source App Link Name
- Source App Link URL
- Additional Fields
Action
Write
- Author Name
- Author Address
- Subject
- Body
- Body Type
- About Name
- About Address
- Source App Link Name
- Source App Link URL
- Additional Fields
Action
Write
- Full Name
- Birthday
- Gender
- Email
- Phone
- Keywords
- Headline
- Node
- Keyword
- Notes
- Stage
- Segment
- Assign To
- Default Assign To
- Share To
- List
- RemoveList
- Source App ID
- Source Person Unique ID
- Source App Link Name
- Source App Link URL
- Additional Fields
Action
Write
- Assign To
- TopicRequired
- When
- Participants
Action
Write

About Cloze

Cloze is like a personal assistant for your professional relationships that is always prompting you at the right moment, and remembering what you don’t. It’s the no-work way to see everything about your contacts in one place. Email, phone calls, meetings, notes, follow-ups and social.

Learn more