Google Sheets + HL Pro Tools
Update locations in HL Pro Tools with every new or updated spreadsheet row in Google Sheets
Keep your team's location information always up to date with this efficient automation! Once set up, each time there's a new or updated row in your Google Sheets spreadsheet located on Team Drive, the corresponding location will be updated in your HL Pro Tools. This ensures your data in both Google Sheets and HL Pro Tools is always current, minimizing room for error and saving valuable time.
Keep your team's location information always up to date with this efficient automation! Once set up, each time there's a new or updated row in your Google Sheets spreadsheet located on Team Drive, the corresponding location will be updated in your HL Pro Tools. This ensures your data in both Google Sheets and HL Pro Tools is always current, minimizing room for error and saving valuable time.
- When this happens...
New or Updated Spreadsheet Row (Team Drive)Triggers when a new row is added or an existing row is updated in a spreadsheet. Optimized for Team Drive.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Update LocationUpdate an existing location in the Agency
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
Use Zapier Catch Webhook
Generates a Webhook URL to send data to Zapier from Highlevel, so that the data can be used for various other available actions in the integration.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Select LocationRequired
Calendar IDRequired
Contact IDRequired
Start TimeRequired
End Time
Title
Appointment Status
Assigned User ID
Address
Ignore Date Range
To Notify?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Business NameRequired
PhoneRequired
AddressRequired
CityRequired
StateRequired
CountryRequired
Postal CodeRequired
Website
Timezone
First NameRequired
Last NameRequired
EmailRequired
Allow Duplicate Contact
Allow Duplicate Opportunity
Allow Facebook Name Merge
Disable Contact Timezone
Facebook Url
Google Plus URL
LinkedIn
Foursquare URL
Twitter
Yelp
Instagram
Youtube
Pinterest
Blog Rss URL
Google Place Id
Twilio sid
Twilio AuthToken
Mailgun API Key
Mailgun Domain
Snapshot id
Custom Values
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Select LocationRequired
Contact IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Select LocationsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Select Existing LocationRequired
Stripe Account IDRequired
NameRequired
EmailRequired
Stripe Customer IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Select Existing LocationRequired
Business Name
Phone
Address
City
State
Country
Postal Code
Website
Timezone
First Name
Last Name
Email
Allow Duplicate Contact
Allow Duplicate Opportunity
Allow Facebook Name Merge
Disable Contact Timezone
Facebook Url
Google Plus URL
LinkedIn
Foursquare URL
Twitter
Yelp
Instagram
Youtube
Pinterest
Blog Rss URL
Google Place Id
Twilio sid
Twilio AuthToken
Mailgun API Key
Mailgun Domain
Snapshot id
Snapshot override
Custom Values
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Select UserRequired
First Name
Last Name
Email Address [ NOT OPERATIONAL ]
Password
Phone
User Type
User Role
Select Locations
Campaigns Enabled?
Campaigns Read Only?
Contacts Enabled?
Workflows Enabled?
Workflows ReadOnly?
Triggers Enabled?
Funnels Enabled?
Websites Enabled?
Opportunities Enabled?
Dashboard Stats Enabled?
Bulk Requests Enabled?
Appointments Enabled?
Reviews Enabled?
Online Listings Enabled?
Call Reporting?
Assigned Data Only?
Adwords Reporting Enabled?
Membership Enabled?
Conversations Enabled?
Facebook Ads Reporting Enabled?
Attributions Reporting Enabled?
Settings Enabled?
Tags Enabled?
Lead Value Enabled?
Marketing Enabled?
Agent Reporting Enabled?
Bot Service?
Social Planner?
Blogging Enabled?
Invoice Enabled?
Affiliate Manager Enabled?
Content AI Enabled?
Refunds Enabled?
Record Payment Enabled?
Cancel Subscription Enabled?
Payments Enabled?
Profile Photo URL
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Select LocationRequired
Calendar IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSelect LocationRequired
Start TimeRequired
End TimeRequired
Calendar ID
Group ID
User ID
ActionThis is an event a Zap performs.SearchFind existing data in your appSelect Existing LocationRequired
Custom Value NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCustomer ID
Subscription ID
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 foundSelect LocationRequired
Campaign IDRequired
Contact IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Select LocationRequired
First Name
Last Name
Full Name
Email Address
Gender
Phone
Date of Birth
Address1
City
State
Postal Code
Website
Tags
Source
Company Name
Country
Contact Timezone
DND?
Contact Notes
Call Status
Call message
Call Code
Email Status
Email Message
Email Code
SMS status
SMS message
SMS Code
WhatsApp Status
WhatsApp Message
WhatsApp Code
GMB Status
GMB Message
GMB Code
FB Status
FB Message
FB Code
All Status
All Message
Custom Fields
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First Name
Last Name
Email AddressRequired
Backup Email Address
Password
Phone
User TypeRequired
User RoleRequired
Select LocationsRequired
Campaigns Enabled?
Campaigns Read Only?
Contacts Enabled?
Workflows Enabled?
Workflows ReadOnly?
Triggers Enabled?
Funnels Enabled?
Websites Enabled?
Opportunities Enabled?
Conversations Enabled?
Dashboard Stats Enabled?
Bulk Requests Enabled?
Appointments Enabled?
Reviews Enabled?
Online Listings Enabled?
Call Reporting?
Assigned Data Only?
Adwords Reporting Enabled?
Membership Enabled?
Facebook Ads Reporting Enabled?
Attributions Reporting Enabled?
Settings Enabled?
Tags Enabled?
Lead Value Enabled?
Marketing Enabled?
Agent Reporting Enabled?
Bot Service?
Social Planner?
Blogging Enabled?
Invoice Enabled?
Affiliate Manager Enabled?
Content AI Enabled?
Refunds Enabled?
Record Payment Enabled?
Cancel Subscription Enabled?
Payments Enabled?
Profile Photo URL
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Select LocationRequired
Event IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Select LocationRequired
Event IDRequired
Calendar ID
Start Time
End Time
Title
Appointment Status
Address
Ignore Date Range
To Notify?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Select LocationRequired
Contact IDRequired
First Name
Last Name
Full Name
Email Address
Phone
Date of Birth
Address1
City
State
Postal Code
Website
Tags
Source
Company Name
Country
Contact Timezone
DND?
Contact Notes
Call Status
Call message
Call Code
Email Status
Email Message
Email Code
SMS status
SMS message
SMS Code
WhatsApp Status
WhatsApp Message
WhatsApp Code
GMB Status
GMB Message
GMB Code
FB Status
FB Message
FB Code
All Status
All Message
Custom Fields
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Select LocationRequired
Customer IDRequired
Subscription IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Select LocationRequired
Contact ID
Contact Email
Workflow NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Select LocationRequired
Group ID
Show Drafted?
ActionThis is an event a Zap performs.SearchFind existing data in your appSelect LocationRequired
Contact ID
Contact Query
ActionThis is an event a Zap performs.SearchFind existing data in your appLocation ID
Location Name
Location Email Address
ActionThis is an event a Zap performs.SearchFind existing data in your appUser ID
Email Address
ActionThis is an event a Zap performs.SearchFind existing data in your app
About Google Sheets
Related categories
About HL Pro Tools
Related categories
Related Zap Templates
- Create Google Sheets rows and add contacts to HL Pro Tools workflows from new Gravity Forms submissions
- Update HL Pro Tools contacts from new Google Sheets rows
- Create new HL Pro Tools contacts from new or updated rows in Google Sheets
- Update locations in HL Pro Tools when new rows are added to Google Sheets team drive
- Update locations in HL Pro Tools when new or updated rows are detected in Google Sheets