Clubworx + Google Sheets

Add new Clubworx members to Google Sheets as rows

Keep a back-up record of your Clubworx member database in Google Sheets, so you can share, repurpose, and sort it however you'd like. Now you can with this simple Zapier automation. When a new member is added into Clubworx, a row is made in a Google Sheet. You now have a live and up-to-date database in Google Sheets that you can use with other Google products like Adwords to remarket to.

When this happens...
New Member
Triggers when a new member is added.
TriggerInstant
automatically do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
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

Member Archived
Triggers when a member is archived.
Trigger
Instant
Try It
Non-Attending Contact Archived
Triggers when a non-attending contact is archived.
Trigger
Instant
Try It
Prospect Archived
Triggers when a prospect is archived.
Trigger
Instant
Try It
New Task
Triggers when a new task is added.
Trigger
Instant
Try It
- Member Contact KeyRequired
- Membership PlanRequired
- Start Date
Action
Write

- First NameRequired
- Last NameRequired
- EmailRequired
- Phone
- Date of Birth
- Address (line 1)
- Address (line 2)
- City/Suburb
- State
- Postcode
Action
Write
- Member Contact KeyRequired
- First Name
- Last Name
- Email
- Phone
- Date of Birth
- Member Number
- Address (line 1)
- Address (line 2)
- City/Suburb
- State
- Postcode
Action
Write

- Prospect Contact KeyRequired
- First Name
- Last Name
- Email
- Phone
- Date of Birth
- Address (line 1)
- Address (line 2)
- City/Suburb
- State
- Postcode
- Status
Action
Write
- Non-Attending Contact Key
- Non-Attending Contact Email
Action
Search
- 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

New Member
Triggers when a new member is added.
Trigger
Instant
Try It
New Non-Attending Contact
Triggers when a new non-attending contact is added.
Trigger
Instant
Try It
New Prospect
Triggers when a new prospect is added.
Trigger
Instant
Try It
Task Updated
Triggers when a task is updated.
Trigger
Instant
Try It
- First NameRequired
- Last NameRequired
- EmailRequired
- Phone
- Date of Birth
- Member Number
- Address (line 1)
- Address (line 2)
- City/Suburb
- State
- Postcode
- Membership Plan
Action
Write
- First NameRequired
- Last NameRequired
- EmailRequired
- Phone
- Date of Birth
- Address (line 1)
- Address (line 2)
- City/Suburb
- State
- Postcode
- Status
Action
Write
- Non-attending Contact KeyRequired
- First Name
- Last Name
- Email
- Phone
- Date of Birth
- Address (line 1)
- Address (line 2)
- City/Suburb
- State
- Postcode
Action
Write
- Member
- Member Email
Action
Search
- Prospect Contact Key
- Prospect Email
Action
Search
- 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