Google Sheets + TidyHQ
Create new TidyHQ contacts from new Google Sheets rows
Streamline your contact management process with this automation workflow connecting Google Sheets and TidyHQ. Whenever a new row is added in Google Sheets, the data is instantly processed, resulting in a new contact creation in your TidyHQ account. This real-time data transfer eliminates manual data entry, ensuring your contact details in TidyHQ always stay up-to-date with your Google Sheets information.
Streamline your contact management process with this automation workflow connecting Google Sheets and TidyHQ. Whenever a new row is added in Google Sheets, the data is instantly processed, resulting in a new contact creation in your TidyHQ account. This real-time data transfer eliminates manual data entry, ensuring your contact details in TidyHQ always stay up-to-date with your Google Sheets information.
- When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create ContactCreates a new contact.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier 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.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
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.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
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
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
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
Contact Activated
Triggers when a contact has been created manually or automatically.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Contact Added to Group
Triggers when a contact has been added to a group.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Contact Merged
Triggers when two contacts have been merged.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Event Deleted
Triggers when an event is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Event Ticket Pack Cancelled
Triggers when a group of event tickets has been cancelled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Event Ticket Pack Reserved
Triggers when a group of event tickets has been reserved for sale.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Event Ticket Deleted
Triggers when an event ticket is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Event Updated
Triggers when an event is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Finance Order Awaiting Payment
Triggers when a finance order requires manual intervention to have its payment processed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Finance Order Expired
Triggers when a finance order has exceeded time it can be in a pending state.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Finance Order Rejected
Triggers when a finance order has failed to process.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Membership Cancelled
Triggers when a membership has been cancelled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Membership Partiated
Triggers when a membership has been partially paid for.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Subscription Continued
Triggers when a subscription has continued.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Subscription Started
Triggers when a subscription has started.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Tidy-Assigned Identifier for ContactRequired
Text of NoteRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Tidy-Assigned Identifier for MembershipRequired
Text of NoteRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Tidy-Assigned Identifier for ContactRequired
Tidy-Assigned Identifier for NoteRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Tidy-Assigned Identifier for MembershipRequired
Tidy-Assigned Identifier for NoteRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact Kind is
Contact ID Number is
First Name is
Last Name is
Contact Email is
Company is
Phone is
ActionThis is an event a Zap performs.SearchFind existing data in your app
No 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 ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
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
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
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
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
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
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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
Row count
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
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundContact Deactivated
Triggers when a contact has been deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Contact Removed From Group
Triggers when a contact has been removed from a group.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Event Activated
Triggers when an event is published.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Event Ticket Pack Activated
Triggers when a group of event tickets has been paid.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Event Ticket Pack Expired
Triggers when a group of event tickets has exceeded time they can be reserved.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Event Ticket Created
Triggers when an event ticket is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Event Ticket Updated
Triggers when an event ticket is updated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Finance Order Activated
Triggers when a finance order has been paid.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Finance Order Cancelled
Triggers when a finance order has been cancelled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Finance Order Pending
Triggers when a finance order is waiting to be processed.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Membership Activated
Triggers when a membership has been activated.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Membership Expired
Triggers when a membership has expired.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Subscription Cancelled
Triggers when a subscription has been cancelled.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Subscription Expired
Triggers when a subscription has expired.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Tidy-Assigned Identifier for InvoiceRequired
Text of NoteRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Tidy-Assigned Identifier for ContactRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Tidy-Assigned Identifier for InvoiceRequired
Tidy-Assigned Identifier for NoteRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
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
About Google Sheets
Related categories
About TidyHQ
Related categories
Related Zap Templates
- Create spreadsheet rows in Google Sheets for newly reserved ticket packs in TidyHQ
- Create Google Sheets rows for new activated contacts in TidyHQ
- Create Google Sheets rows when new TidyHQ event ticket packs are activated
- Add a new row to Google Sheets when event ticket packs expire in TidyHQ
- Add new TidyHQ event attendees to Google Sheets rows