Google Sheets + Issuetrak

Add Issuetrak users to groups from new or updated Google Sheets rows

Keeping track of group arrangements in Google Sheets? With this integration, updating a row in your Google Sheets spreadsheet will add an existing Issuetrak user to a group.

When this happens...
New or Updated Spreadsheet Row
Triggered when a new row is added or modified in a spreadsheet.
TriggerInstant
automatically do this!
Add Group Memberships to User
Adds Group Memberships to a User.
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

What does this mean?

- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write

- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write

- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
Action
Search or write
New Organization
Triggers when a new Organization is created.
Trigger
Scheduled
Try It
- IID of Group To UpdateRequired
- Should the Group only allow agents?
- Name
- Phone Number
- Email Address
- SMS Address
- Primary Organization
Action
Write
- User IID
- Groups to add to the userRequired
Action
Write
- Group IID
- Organizations to add to the groupRequired
- Allow members of the group, with appropriate permissions, to edit Issues in the selected OrganizationsRequired
- Allow members of the group to see (in lists) users in the selected OrganizationsRequired
Action
Write
- NameRequired
- Is InternalRequired
- Site Title
- Contact Person
- Email
- Phone
- Address Line One
- Address Line Two
- City
- State
- Zip/Postal Code
- Web Address
- Email Domain
- Reply To Email Name
- Reply To Email Address
- Note
Action
Write
- User IID
- Organizations to remove from the userRequired
Action
Write
- IID of User To UpdateRequired
- Can Login
- Active
- Should the User be an agent?
- First Name
- Last Name
- Display Name
- Phone Number
- Email Address
- SMS Address
- Time Zone
- Should times displayed to this user respect Daylight Savings Time?
- Address Line One
- Address Line Two
- City
- State
- Zip/Postal Code
- Country
- Primary Organization
- Redirect After Issue Submit
- Home Page
Action
Write
- IID of User To UpdateRequired
- Can Login
- Active
- Should the User be an agent?
- First Name
- Last Name
- Display Name
- Phone Number
- Email Address
- SMS Address
- Time Zone
- Should times displayed to this user respect Daylight Savings Time?
- Address Line One
- Address Line Two
- City
- State
- Zip/Postal Code
- Country
- Primary Organization
- Redirect After Issue Submit
- Home Page
Action
Write
- Field to search onRequired
Action
Search
- Field to search onRequired
Action
Search
- Field to search onRequired
Action
Search

- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy To
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Text Bold
- Text Italic
- Text Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Bottom-Up
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite?
Action
Search or write
New Group
Triggers when a new group is created.
Trigger
Scheduled
Try It
New User
Triggers when a new user is created.
Trigger
Scheduled
Try It
- Should this Group be Agent Only?
- Group ID
- Display NameRequired
- Phone Number
- Email Address
- SMS Address
- Primary OrganizationRequired
Action
Write
- User IID
- Groups to remove from the userRequired
Action
Write
- Group IID
- Organizations to remove from the userRequired
Action
Write
- User IID
- Organizations to add to the userRequired
- Allow the user, with appropriate permissions, to edit Issues in the selected OrganizationsRequired
- Allow the user to see (in lists) users in the selected OrganizationsRequired
Action
Write
- IID of the Organization to updateRequired
- Name
- Is Internal
- Site Title
- Contact Person
- Contact User
- Email
- Phone
- Address Line One
- Address Line Two
- City
- State
- Zip/Postal Code
- Web Address
- Email Domain
- Reply To Email Name
- Reply To Email Address
- Note
Action
Write
- Can Login
- Should the User be an agent?
- User ID
- First NameRequired
- Last NameRequired
- Display NameRequired
- Phone Number
- Email Address
- SMS Address
- Time ZoneRequired
- Should times displayed to this user respect Daylight Savings Time?
- Address Line One
- Address Line Two
- City
- State
- Zip/Postal Code
- Country
- Primary OrganizationRequired
- Redirect After Issue SubmitRequired
- Home PageRequired
Action
Write
- Field to search onRequired
Action
Search
- Field to search onRequired
Action
Search
- Iid exactly matches one of
- Search Name ByRequired
- Match Is Internal OnRequired
- Search Site Title ByRequired
- Search Contact Person ByRequired
- Search Email ByRequired
- Search Phone ByRequired
- Search Address Line One ByRequired
- Search Address Line Two ByRequired
- Search City ByRequired
- Search State ByRequired
- Search Postal Code ByRequired
- Search Web Address ByRequired
- Search Email Domain ByRequired
- Search Reply To Email Name ByRequired
- Search Reply To Email Address ByRequired
- Search Note ByRequired
Action
Search
- User IID matches one of
- Search User ID ByRequired
- Primary Organization Iid exactly matches one of
- Search Display Name ByRequired
- Match Is agent OnRequired
- Search First Name ByRequired
- Search Last Name ByRequired
- Search Phone Number ByRequired
- Search Email ByRequired
- Search SMS Address ByRequired
- Search Address Line One ByRequired
- Search Address Line Two ByRequired
- Search City ByRequired
- Search State ByRequired
- Search Zip/Postal Code ByRequired
- Search Country ByRequired
- Match Can Login OnRequired
- Match Active OnRequired
Action
Search

About Google Sheets

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

Learn more Help

Related categories

Similar apps

Zapier Tables

Databases, Spreadsheets, Zapier

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

About Issuetrak

Issuetrak is an operational management platform to help you solve problems, control chaos, and experience less stress.

Help

Related categories

Customer Support

PRODUCTS

CAPABILITIES

By team

Google Sheets + Issuetrak

Add Issuetrak users to groups from new or updated Google Sheets rows

New Spreadsheet Row (Team Drive)

Drive

WorksheetRequired

New Spreadsheet

Drive

New or Updated Spreadsheet Row

No Team Drive

SpreadsheetRequired

WorksheetRequired

Trigger Column

Create Spreadsheet Column

Drive

SpreadsheetRequired

WorksheetRequired

Column NameRequired

Index

Create Multiple Spreadsheet Rows

Drive

SpreadsheetRequired

WorksheetRequired

Create Spreadsheet

TitleRequired

Spreadsheet to Copy

Headers

Delete Spreadsheet Row

Drive

SpreadsheetRequired

WorksheetRequired

RowRequired

Update Spreadsheet Row

Drive

SpreadsheetRequired

WorksheetRequired

RowRequired

API Request (Beta)

Api Docs Info

HTTP MethodRequired

URLRequired

Query String Parameters

Headers

Additional Request Headers

Body

Find Worksheet

Drive

SpreadsheetRequired

TitleRequired

Lookup Spreadsheet Row

Drive

SpreadsheetRequired

WorksheetRequired

Lookup ColumnRequired

Lookup ValueRequired

Supporting Lookup Column

Supporting Lookup Value

Bottom-Up

Find or Create Row

Drive

SpreadsheetRequired

WorksheetRequired

Lookup ColumnRequired

Lookup ValueRequired

Supporting Lookup Column

Supporting Lookup Value

Bottom-Up

New Organization

Update Group

IID of Group To UpdateRequired

Should the Group only allow agents?

Name

Phone Number

Email Address

SMS Address

Primary Organization

Add Group Memberships to User

User IID