Google Sheets + TidyHQ

Create new TidyHQ contacts from new or updated rows in Google Sheets

Optimize your contact management process by integrating Google Sheets with TidyHQ. With this workflow, whenever a new or updated row is detected in Google Sheets, it prompts the creation of a new contact in TidyHQ, keeping your contact database accurate and up-to-date. Whether you're managing customer data, tracking stakeholders, or updating your mailing list, this seamless integration cuts down on manual data entry, saving you valuable time and reducing the risk of errors.

When this happens...
New or Updated Spreadsheet Row
Triggers when a new row is added or modified in a spreadsheet.
TriggerInstant
automatically do this!
Create Contact
Creates a new contact.
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
Contact Activated
Triggers when a contact has been created manually or automatically.
Trigger
Instant
Try It
Contact Added to Group
Triggers when a contact has been added to a group.
Trigger
Instant
Try It
Contact Merged
Triggers when two contacts have been merged.
Trigger
Instant
Try It
Event Deleted
Triggers when an event is deleted.
Trigger
Instant
Try It
Event Ticket Pack Cancelled
Triggers when a group of event tickets has been cancelled.
Trigger
Instant
Try It
Event Ticket Pack Reserved
Triggers when a group of event tickets has been reserved for sale.
Trigger
Instant
Try It
Event Ticket Deleted
Triggers when an event ticket is deleted.
Trigger
Instant
Try It
Event Updated
Triggers when an event is updated.
Trigger
Instant
Try It
Finance Order Awaiting Payment
Triggers when a finance order requires manual intervention to have its payment processed.
Trigger
Instant
Try It
Finance Order Expired
Triggers when a finance order has exceeded time it can be in a pending state.
Trigger
Instant
Try It
Finance Order Rejected
Triggers when a finance order has failed to process.
Trigger
Instant
Try It
Membership Cancelled
Triggers when a membership has been cancelled.
Trigger
Instant
Try It
Membership Partiated
Triggers when a membership has been partially paid for.
Trigger
Instant
Try It
Subscription Continued
Triggers when a subscription has continued.
Trigger
Instant
Try It
Subscription Started
Triggers when a subscription has started.
Trigger
Instant
Try It
- Tidy-Assigned Identifier for ContactRequired
- Text of NoteRequired
Action
Write
- Tidy-Assigned Identifier for MembershipRequired
- Text of NoteRequired
Action
Write
- Tidy-Assigned Identifier for ContactRequired
- Tidy-Assigned Identifier for NoteRequired
Action
Write
- Tidy-Assigned Identifier for MembershipRequired
- Tidy-Assigned Identifier for NoteRequired
Action
Write
- Contact Kind is
- Contact ID Number is
- First Name is
- Last Name is
- Contact Email is
- Company is
- Phone is
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
Contact Deactivated
Triggers when a contact has been deleted.
Trigger
Instant
Try It
Contact Removed From Group
Triggers when a contact has been removed from a group.
Trigger
Instant
Try It
Event Activated
Triggers when an event is published.
Trigger
Instant
Try It
Event Ticket Pack Activated
Triggers when a group of event tickets has been paid.
Trigger
Instant
Try It
Event Ticket Pack Expired
Triggers when a group of event tickets has exceeded time they can be reserved.
Trigger
Instant
Try It
Event Ticket Created
Triggers when an event ticket is created.
Trigger
Instant
Try It
Event Ticket Updated
Triggers when an event ticket is updated.
Trigger
Instant
Try It
Finance Order Activated
Triggers when a finance order has been paid.
Trigger
Instant
Try It
Finance Order Cancelled
Triggers when a finance order has been cancelled.
Trigger
Instant
Try It
Finance Order Pending
Triggers when a finance order is waiting to be processed.
Trigger
Instant
Try It
Membership Activated
Triggers when a membership has been activated.
Trigger
Instant
Try It
Membership Expired
Triggers when a membership has expired.
Trigger
Instant
Try It
Subscription Cancelled
Triggers when a subscription has been cancelled.
Trigger
Instant
Try It
Subscription Expired
Triggers when a subscription has expired.
Trigger
Instant
Try It
- Contact Kind
- Contact ID Number
- First Name
- Last Name
- Contact Email
- Nick Name
- Company
- Date of Birth
- Gender
- Subscribed for messages
- Phone
- Street
- City
- State
- Postcode
- Country
- Facebook
- Twitter
- LinkedIn
- Instagram
- Website Address
- Emergency Contact Person
- Emergency Contact Number
- Occupation
- Additional Info
Action
Write
- Tidy-Assigned Identifier for InvoiceRequired
- Text of NoteRequired
Action
Write
- Tidy-Assigned Identifier for ContactRequired
Action
Write
- Tidy-Assigned Identifier for InvoiceRequired
- Tidy-Assigned Identifier for NoteRequired
Action
Write
- Tidy-Assigned Identifier for ContactRequired
- Contact Kind
- Contact ID Number
- First Name
- Last Name
- Contact Email
- Nick Name
- Company
- Date of Birth
- Gender
- Subscribed for messages
- Phone
- Street
- City
- State
- Postcode
- Country
- Facebook
- Twitter
- LinkedIn
- Instagram
- Website Address
- Emergency Contact Person
- Emergency Contact Number
- Occupation
- Additional Info
Action
Write
- Contact Kind
- Contact ID Number
- First Name
- Last Name
- Contact Email
- Company
- Phone
- Nick Name
- Date of Birth
- Gender
- Subscribed for messages
- Street
- City
- State
- Postcode
- Country
- Facebook
- Twitter
- LinkedIn
- Instagram
- Website Address
- Emergency Contact Person
- Emergency Contact Number
- Occupation
- Additional Info
Action
Search or write

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more

Related categories

Similar apps

About TidyHQ

When your group needs to collect membership dues, communicate with everyone and keep track of your finances and more, TidyHQ has you covered.

Related categories

CRM (Customer Relationship Management)

Google Sheets + TidyHQ

Create new TidyHQ contacts from new or updated rows in Google Sheets

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Change Sheet Properties

Copy Range

Create Spreadsheet

Clear Spreadsheet Row(s)

Delete Spreadsheet Row(s)

Format Spreadsheet Row

Set Data Validation

Update Spreadsheet Row

API Request (Beta)

Find Worksheet

Get Many Spreadsheet Rows (Advanced)

Get Spreadsheet by ID

Find or Create Worksheet

Contact Activated

Contact Added to Group

Contact Merged

Event Deleted

Event Ticket Pack Cancelled

Event Ticket Pack Reserved

Event Ticket Deleted

Event Updated

Finance Order Awaiting Payment

Finance Order Expired

Finance Order Rejected

Membership Cancelled

Membership Partiated

Subscription Continued

Subscription Started

Add Contact Note

Add Membership Note

Delete Contact Note

Delete Membership Note

Find Contact

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Create Spreadsheet Row at Top

Create Conditional Formatting Rule

Copy Worksheet

Create Worksheet

Delete Sheet

Format Cell Range

Rename Sheet

Sort Range

Update Spreadsheet Row(s)

Lookup Spreadsheet Rows (Advanced)

Get Data Range

Get Row by ID

Lookup Spreadsheet Row

Find or Create Row

Contact Deactivated

Contact Removed From Group

Event Activated

Event Ticket Pack Activated

Event Ticket Pack Expired

Event Ticket Created

Event Ticket Updated

Finance Order Activated

Finance Order Cancelled

Finance Order Pending

Membership Activated

Membership Expired

Subscription Cancelled

Subscription Expired

Create Contact

Add Invoice Note

Delete Contact

Delete Invoice Note

Update Contact

Find or Create Contact

About Google Sheets

Related categories