Google Sheets + Issuetrak

Google Sheets + Issuetrak integrations

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 RowTriggers when a new row is added or modified in a spreadsheet.
TriggerInstant
automatically do this!
Add Group Memberships to UserAdds Group Memberships to a User.
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with Google Sheets and Issuetrak

Discover other triggers and actions you can use with Google Sheets and Issuetrak

- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Instant
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Column_name
  Required
- Index
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write

- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Source Range
  Required
- Destination Range
  Required
- Paste Type
Action
Write

- Drive
- Title
  Required
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Validation Type
  Required
- Input Message
- Strict Validation
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Columns
  Required
- Row count
  Required
- Output format
- First row
Action
Search
- Spreadsheet ID
  Required
- Include Grid Data
Action
Search
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write
New Group
Triggers when a new group is created.
Trigger
Polling
Try It
New User
Triggers when a new user is created.
Trigger
Polling
Try It
- Should this Group be Agent Only?
- Group ID
- Display Name
  Required
- Phone Number
- Email Address
- SMS Address
- Primary Organization
  Required
Action
Write
- User IID
- Groups to remove from the user
  Required
Action
Write
- Group IID
- Organizations to remove from the user
  Required
Action
Write
- Name
  Required
- Is Internal
  Required
- 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 user
  Required
Action
Write
- IID of User To Update
  Required
- 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 Update
  Required
- 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 on
  Required
Action
Search
- Field to search on
  Required
Action
Search
- Field to search on
  Required
Action
Search
- Field to search on
  Required
Action
Search
- IID exactly matches one of
- Search Name By
  Required
- Match Is Internal On
  Required
- Search Site Title By
  Required
- Search Contact Person By
  Required
- Search Email By
  Required
- Search Phone By
  Required
- Search Address Line One By
  Required
- Search Address Line Two By
  Required
- Search City By
  Required
- Search State By
  Required
- Search Postal Code By
  Required
- Search Web Address By
  Required
- Search Email Domain By
  Required
- Search Reply To Email Name By
  Required
- Search Reply To Email Address By
  Required
- Search Note By
  Required
Action
Search
- Field to search on
  Required
Action
Search
- IID exactly matches one of
- Search Issue Class Name By
  Required
- Created By User IID exactly matches one of
- Modified By User IID exactly matches one of
Action
Search
- IID exactly matches one of
- Match Is Open On
  Required
- Match Should Suppress Email Notifications On
  Required
- Match Is Global Issue On
  Required
- Match Is Child Issue On
  Required
- Match Is First Call Resolution On
  Required
- Severity
- Project
- Configuration Item
- Responsible Department
- Sub Type 1
- Sub Type 2
- Sub Type 3
- Sub Type 4
- Parent Issue
- Closed By
- Reopened By
- Last Activity By
- Issue Type
- Cause
- Class
- Location
- Organization
- Priority
- Substatus
- Assigned To
- Submitted By
- Entered By
- Next Action User
- Search Issue Subject By
  Required
- Search Description By
  Required
- Search Auto Assign Type By
  Required
- Search Submitted Date By
  Required
- Search Entered Date By
  Required
- Search Closed Date By
  Required
- Search Assigned Date By
  Required
- Search Reopened Date By
  Required
- Search Target Date By
  Required
- Search Required By Date By
  Required
- Search Next Action By Date By
  Required
- Search Last Activity Date By
  Required
- Search Escalate Date By
  Required
- Search First Response Time By
  Required
- Search by User Defined Fields?
Action
Search
- IID exactly matches one of
- Search Name By
  Required
- Search Message By
  Required
- Created By User IID exactly matches one of
- Modified By User IID exactly matches one of
Action
Search
- IID exactly matches one of
- Search Name By
  Required
- Search Description By
  Required
- Created By User IID exactly matches one of
- Modified By User IID exactly matches one of
Action
Search
- IID exactly matches one of
- Search Name By
  Required
- Created By User IID exactly matches one of
- Modified By User IID exactly matches one of
Action
Search
- IID exactly matches one of
- ParentIid exactly matches one of
- Search Name By
  Required
- Created By User IID exactly matches one of
- Modified By User IID exactly matches one of
Action
Search
- IID exactly matches one of
- ParentIid exactly matches one of
- Search Name By
  Required
- Created By User IID exactly matches one of
- Modified By User IID exactly matches one of
Action
Search
- Field to search on
  Required
Action
Search
- Field to search on
  Required
Action
Search
- Field to search on
  Required
Action
Search
- Field to search on
  Required
Action
Search

- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Instant
Try It
- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Condition Type
  Required
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to Copy
  Required
- Worksheet to Copy
  Required
- Copy Worksheet Destination
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Confirm Deletion
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Format Type
  Required
Action
Write
- Spreadsheet
  Required
- Worksheet
  Required
- New Sheet Name
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Sort by Column
  Required
- Sort Order
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- A1 Range
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row ID
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write
New Organization
Triggers when a new Organization is created.
Trigger
Polling
Try It
- IID of Group To Update
  Required
- Should the Group only allow agents?
- Name
- Phone Number
- Email Address
- SMS Address
- Primary Organization
Action
Write
- User IID
- Groups to add to the user
  Required
Action
Write
- Group IID
- Organizations to add to the group
  Required
- Allow members of the group, with appropriate permissions, to edit Issues in the selected Organizations
  Required
- Allow members of the group to see (in lists) users in the selected Organizations
  Required
Action
Write
- Issue Type
  Required
Action
Write
- User IID
- Organizations to add to the user
  Required
- Allow the user, with appropriate permissions, to edit Issues in the selected Organizations
  Required
- Allow the user to see (in lists) users in the selected Organizations
  Required
Action
Write
- IID of the Organization to update
  Required
- Name
- Is Internal
- Site Title
- Contact Person
- Contact User
- Secondary Contact User
- Tertiary 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 Name
  Required
- Last Name
  Required
- Display Name
  Required
- Phone Number
- Email Address
- SMS Address
- Time Zone
  Required
- Should times displayed to this user respect Daylight Savings Time?
- Address Line One
- Address Line Two
- City
- State
- Zip/Postal Code
- Country
- Primary Organization
  Required
- Redirect After Issue Submit
  Required
- Home Page
  Required
Action
Write
- Field to search on
  Required
Action
Search
- Field to search on
  Required
Action
Search
- Field to search on
  Required
Action
Search
- Field to search on
  Required
Action
Search
- Field to search on
  Required
Action
Search
- Field to search on
  Required
Action
Search
- IID exactly matches one of
- Search Cause Name By
  Required
- Created By User IID exactly matches one of
- Modified By User IID exactly matches one of
Action
Search
- Iid exactly matches one of
- Search Name By
  Required
Action
Search
- IID exactly matches one of
- Search Name By
  Required
- Match Is Active On
  Required
- Created By User IID exactly matches one of
- Modified By User IID exactly matches one of
Action
Search
- IID exactly matches one of
- Search Project Title By
  Required
- Search Project Code By
  Required
- Manager IID exactly matches one of
- Organization IID exactly matches one of
- Location IID exactly matches one of
- Match Is Open On
  Required
- Category IID exactly matches one of
- Substatus IID exactly matches one of
- Created By User IID exactly matches one of
- Modified By User IID exactly matches one of
Action
Search
- IID exactly matches one of
- Search Name By
  Required
- Created By User IID exactly matches one of
- Modified By User IID exactly matches one of
Action
Search
- IID exactly matches one of
- ParentIid exactly matches one of
- Search Name By
  Required
- Created By User IID exactly matches one of
- Modified By User IID exactly matches one of
Action
Search
- IID exactly matches one of
- ParentIid exactly matches one of
- Search Name By
  Required
- Created By User IID exactly matches one of
- Modified By User IID exactly matches one of
Action
Search
- Field to search on
  Required
Action
Search
- Field to search on
  Required
Action
Search
- Field to search on
  Required
Action
Search
- Field to search on
  Required
Action
Search
- User IID matches one of
- Search User ID By
  Required
- Primary Organization Iid exactly matches one of
- Search Display Name By
  Required
- Match Is agent On
  Required
- Search First Name By
  Required
- Search Last Name By
  Required
- Search Phone Number By
  Required
- Search Email By
  Required
- Search SMS Address By
  Required
- Search Address Line One By
  Required
- Search Address Line Two By
  Required
- Search City By
  Required
- Search State By
  Required
- Search Zip/Postal Code By
  Required
- Search Country By
  Required
- Match Can Login On
  Required
- Match Active On
  Required
Action
Search

About Google Sheets

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

Learn moreLearn moreHelpHelp

Related categories

Google

Spreadsheets

Similar apps

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Quip

Documents

About Issuetrak

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

HelpHelp

Related categories

Customer Support