Create resources in Tracker for every new or updated row in Google Sheets
Stay on top of your updates in Google Sheets with this efficient workflow. If there are any new or updated rows in Google Sheets, it will instantly create a resource in your Tracker app. This streamlines the process and ensures that your Tracker app is always up-to-date with the latest information. Make your work process smoother and more accurate by reducing manual entry.
Stay on top of your updates in Google Sheets with this efficient workflow. If there are any new or updated rows in Google Sheets, it will instantly create a resource in your Tracker app. This streamlines the process and ensures that your Tracker app is always up-to-date with the latest information. Make your work process smoother and more accurate by reducing manual entry.
- When this happens...New or Updated Spreadsheet Row
Triggers when a new row is added or modified in a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!Create Resource
Adds a new resource
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 foundNew Activity
Triggers when a new activity is added to Tracker.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Contact
Triggers when a new contact is added to Tracker.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Lead
Triggers when a new lead is added to Tracker.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Resource
Triggers when a new resource is added to Tracker.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Activity
Triggers when an existing activity is updated to Tracker.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Contact
Triggers when an existing contact is updated to Tracker.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Lead
Triggers when an existing lead is updated to Tracker.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Resource
Triggers when an existing resource is updated to Tracker.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Contact Name
Client Name
Resource Name
Opportunity Name
Campaign Name
Project Name
User Name
Lead Name
Subject
Priority
Activity Type
Date Due
Time Due
Task Status
Location
Start Date
End Date
Start Time
End Time
Note
Contact Type
Interviewer
Last Updated Date/Time
Last Updated Name
Reminder Date/Time
Interview Type
CV Sent
CV Sent Count
Interview Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Client Name
Preferred Name
First Name
Last Name
Full NameRequired
Job Title
Address Line 1
Address Line 2
Town/City
County/State
Post/Zip Code
Country
Business Phone
Home Phone
Mobile/Cell
Other Phone
Fax
LinkedIn
Email
Website
Department
Office
Manager Name
Assistant Name
Nickname
Spouses Name
Birthday
Anniversary
Note
Is Primary Contact
Source
Marketing
Internal Reference
Contact Role
Last Updated
Last Updated By
Creation Date
Tag text
Contact Owner
Is Private Record
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Client Name
Contact Name
Resource Name
Lead Owner
Product Name
Lead NameRequired
Description
Lead From
Telephone
Email
Lead Date
Award Date
Lead Status Name
Source
Value
Strategy
Contact Type
Creation Date
Internal Reference
Tag Text
Last Updated
Last Updated By
Currency
Department
Close Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Opportunity NameRequired
Opportunity Owner
Department
Status
Client Name
Contact Name
Date Opened
Location
Client Reference
Work Type
Source
Probability
Number of Positions
Estimated Value
Factored Value
Target Margin
Award Date
Invoice Date
Start Date
End Date
Date Filled
Description
Note
Strategy
Published
Publish Reference
Publish Title
Publish Description
Publish Location
Publish Start
Publish Duration
Publish Work Type
Publish Sector
Publish Category
Zip Code Location
Last Update
Last Update By
Pay Rate/Salary
Creation Date
Currency
Publish Salary From
Publish Salary To
Publish Salary Per
Publish Benefits
Publish Skills
Tag Text
Charge Rate/Fee
Start Time
End Time
Business Type
Secondary Owner
Owner Percentage
Secondary Owner Percentage
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Client Name
Company Name
Contact Name
Product Name
Project Name
Ticket Raised Date
Ticket Contact Type
Company
Email
Telephone
Ticket Status
Ticket Priority
Ticket Department
Ticket Type
Product Version
Ticket Resolution Due
Last Updated
Last Updated By
Subject
Description
Resolution
Assigned To
Keywords
Publish
Lifecycle Stage
Assigned To
Category 1 Changes
Category 2 Changes
Product Change
Service Change
Change Date
Creation Date
Assigned To Department
Assigned Team
Tag Text
First Response Made
Ticket Status
First Response Due
Ticket Type
Closed
Other Email To Notify
Creation Contact Name
Creation User Name
Reminder
Feedback Score
Feedback Comments
Feedback Link
Ticket Priority
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TermRequired
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 foundNew Client
Triggers when a new client is added to Tracker.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Invoice
Triggers when a new invoice is added to Tracker.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Opportunity
Triggers when a new opportunity is added to Tracker.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Ticket
Triggers when a new ticket is added to Tracker.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Client
Triggers when an existing client is updated on Tracker.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Invoice
Triggers when an existing invoice is updated to Tracker.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Opportunity
Triggers when an existing opportunity is updated to Tracker.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Updated Ticket
Triggers when an existing ticket is updated to Tracker.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Client NameRequired
Address Line 1
Address Line 2
Town/City
County/State
Post/Zip Code
Country
Telephone
Fax
Email
Website
Note
Background
Source
Internal Reference
Sort Code
Account Number
Bank Name
Bank Reference
Last Updated
Last Updated By
Target Revenue
Turnover
Creation Date
Client Vertical
Tag Text
Client Owner
Tax Exempt
Invoice Contact Name
Invoicing Frequency
Invoicing Date
Invoice Terms
Department
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Invoice Date
Invoice Due Date
Name
Invoice Contact Name
Address Line 1
Address Line 2
Town/City
County/State
Post/Zip Code
Country
Purchase Order No
Invoice Status
Invoice Owner
Invoice Terms
Payment Date
Invoice Sub Total
Invoice Tax Total
Invoice Total
Invoice Note
Creation Date
Currency Code
Client Name
Invoice Item Id
Item Date
Item Code
Item Description
Item Units
Item Unit Value
Item Sub Value
Item Tax Rate
Item Total Value
Item Status
Item Invoice Order Id
Item Tax Amount
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact Name
Client Name
Resource Name
Opportunity Name
Campaign Name
User Name
Project Name
Lead Name
Date
Time
TextRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Preferred Name
First Name
Last Name
Full NameRequired
Job Title
Address Line 1
Address Line 2
Town/City
County/State
Post/Zip Code
Country
Home Phone
Mobile/Cell
Work Phone
Other Phone
Email
Other Email
Date of Birth
Nationality
Ethnic Origin
Languages
Education
Notice Period
Interview Date
Interview Result
Interview Note
Summary
Date Resume Sent
Date Applied
Date Registered
Interviewed By
Source
Sort Code
Account No
Bank Name
Bank Reference
Last Update
Last Update By
Status
Creation Date
Employment History
Achievements
Associations
NI-SS Number
Marketing
Tag Text
Current Salary
Desired Salary
Current Pay Rate
Desired Pay Rate
Owner
Payroll Number
Agency Name
Available From Date
IBAN
Swift
Current Employer
Is Private Record
Department
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TermRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appTermRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app