Baresquare + Google Sheets
Assign new Baresquare tickets from rules in Google Sheets rows
Use a set of rules in a Google Sheets (e.g. tickets referring to paid search get assigned to user xyz@company.com) to assign new Baresquare tickets. For every new ticket, the Zap will look up the ticket details in the Google Sheets rule set to identify the correct assignee's email address. Then, this template will look up the user ID in Baresquare and finally assign the Baresquare ticket to that user.
Use a set of rules in a Google Sheets (e.g. tickets referring to paid search get assigned to user xyz@company.com) to assign new Baresquare tickets. For every new ticket, the Zap will look up the ticket details in the Google Sheets rule set to identify the correct assignee's email address. Then, this template will look up the user ID in Baresquare and finally assign the Baresquare ticket to that user.
- When this happens...New Ticket
Triggers when a new ticket is created in Baresquare.
- automatically do this...Lookup Spreadsheet Row
Finds a row by a column and value. Returns the entire row if one is found.
- then do this...Find Organization User
Find user by email address. Returns only a single user.
- then do this!Update Ticket Assignee
Updates a ticket's assignee by the ticket ID
- Free forever for core features
- 14 day trial for premium features & apps
