Google Sheets, StackExchange, Optimy, JIRA Software, Apify, Twitch Integrations

Apify
Google Sheets
JIRA Software
Optimy
StackExchange
Twitch
Try Integromat for FREE
No credit card. You'll love it.

What is Integromat?

GmailWatch emailsGoogle SheetsAdd a rowGmailIterate attachmentsRouterFacebookCreate a postArchiveCreate an archiveDropboxUpload a fileDocuments onlyImages onlyWhen new email arrivesAdd a row to a sheetProcess attachmentsone by one ...Post images to pageZip all documentsUpload archive

Integromat will automate processes that you currently handle manually. It is not only capable of connecting apps but can also transfer and transform data. It works 24 hours a day, seven days a week and does not require your intervention. Simply set Integromat to do what you want and let it work for you. Save your time!

Triggers

Google Sheets

Perform a Function INSTANT

Receives data passed to the function INTEGROMAT used in a sheet. Sheets Add-On required.

Google Sheets

Watch Changes INSTANT

Triggers when a cell is updated. Watches only changes made in Google Sheet app. Sheets Add-On required.

Google Sheets

Watch Rows

Watches for new rows.

StackExchange

Watch answers

Triggers when a new answer is added.

StackExchange

Watch questions

Triggers when a new question is added .

Optimy

Generic event INSTANT

New project, updated project, etc.

JIRA Software

Watch Issues INSTANT

Watch changes to issues and filter them via JQL. Requires JIRA Administrator rights to automatically register webhooks.

JIRA Software

Watch Issues (manual webhook registration) INSTANT

Same as Watch Issues, but you can use this if you don't have Administrator rights in JIRA and ask your Administrator to register a webhook for you.

Apify

Watch Actor Runs INSTANT

Triggers whenever a selected actor is run and finished.

Apify

Watch Task Runs INSTANT

Triggers whenever a selected task is run and finished.

Twitch

Watch Followed Streams

Check if followed stream is live.

Twitch

Watch New Clips

Gets the top clips for the games you follow.

Twitch

Watch New Follows

Checks your channel for new followers.

Twitch

Watch new Subscribers

Check for new Subscribers on your channel.

Twitch

Watch New Videos

Check for new videos from channels you follow.

Actions

Google Sheets

Add a Row

Appends a new row to the bottom of the table.

Google Sheets

Add a Sheet

Adds a new sheet.

Google Sheets

Clear a Cell

Cleares a specific cell.

Google Sheets

Clear a Row

Clears values from a specific row.

Google Sheets

Create a Spreadsheet

Creates a new spreadsheet.

Google Sheets

Delete a Row

Deletes a specific row.

Google Sheets

Get a Cell

Gets a specific cell.

Google Sheets

Perform a Function - Responder

Returns processed data as a result of the INTEGROMAT function. Sheets Add-On required.

Google Sheets

Update a Cell

Updates a specific cell.

Google Sheets

Update a Row

Updates a row.

Optimy

Create a project part version

Creates a new version on a given part.

Optimy

Create a project task

Creates a task in a project.

Optimy

Create budget allocation

Create a budget allocation in a project.

Optimy

Create project internal extra field

Creates an internal extra field in a project.

Optimy

Get form

Gets a form.

Optimy

Get project

Retrieves data about a single project

Optimy

Get project answer

Gets the answer of a given project part version for a given project.

Optimy

Get project file (document manager)

Gets the file uploaded in the "document manager" of a project.

Optimy

Get project file (form)

Gets a file uploaded through the form into a project.

Optimy

Get project internal extra field

Gets an internal extra field of a project.

Optimy

Update project status

Updates the status of a project

Optimy

Update project task

Updates the task of a project (eg: to mark it as completed).

Optimy

Update the project leader

Updates (or removes) the leader (user and/or team) of a project.

Optimy

Upload a project file (document manager)

Uploads a file into the "document manager" of the project.

Optimy

Upload a project file (form)

Uploads a file into the form of the project.

JIRA Software

Add Attachment

Add attachment to issue

JIRA Software

Add Comment

Add new comment to issue

JIRA Software

Assign Issue

Assigns the issue to the user. Use this mdoule to assign issues for the users having “Assign Issue” permission, and not having the “Edit Issue” permission. If User Name parameter is set to “-1” then automatic issue assignee is used. An empty User Name will remove the assignee.

JIRA Software

Create Issue

Creates a new Issue

JIRA Software

Create/Update Issue

Creates an issue when there is no Id provided, otherwise updates the issue with the Id provided.

JIRA Software

Delete Comment

Delete a comment by its Id

JIRA Software

Delete Issue

Delete an issue by its Id

JIRA Software

Get Attachment

Retrieves an attachment based on it's Id

JIRA Software

Get Issue

Retrieves an issue by its Id

JIRA Software

Make an API Call

Performs an arbitrary authorized API call.

JIRA Software

Remove Attachment

Remove an attachment based on it's Id

JIRA Software

Transition Issue

Perform a transition on an issue. You must know the correct transition id in order to transition the issue.

JIRA Software

Update Comment

Update comment by its Id

JIRA Software

Update Issue

Update an issue by it's Id

Apify

Run an Actor

Run a selected actor.

Apify

Run a Task

Runs a selected actor task.

Twitch

Block a User

Blocks a user; that is, adds a specified target user to your blocks list.

Twitch

Delete Video

Deletes a specified video. The video can be any type of VOD (Video on Demand): past broadcasts (videos created from a live Twitch stream), highlights (cut from past broadcasts), or uploads (manually uploaded by broadcasters).

Twitch

Follow Channel

Adds you to the followers of a specified channel.

Twitch

Get Channel Information

Gets informations for specified channel.

Twitch

Get Stream by User

Gets stream information (the stream object) for a specified user.

Twitch

Get Streams Summary

Gets a summary of live streams.

Twitch

Get Video

Gets information about your video.

Twitch

Check Channel Subscription by User

Checks if your channel has a specified user subscribed to it.

Twitch

Unblock User

Unblocks a user; that is, deletes a specified target user from your blocks list.

Twitch

Unfollow Channel

Deletes you from the followers of a specified channel.

Twitch

Update Channel

Updates an existing channel.

Twitch

Update Video

Updates information about your video that was already created.

Searches

Google Sheets

Get Range Values

Gets a range content.

Google Sheets

Search Rows

Returns results matching the given criteria.

Google Sheets

Search Rows (Advanced)

Returns results matching the given criteria. This module doesn't return a row number.

Optimy

List project answers

Lists the answers of a given project part version of a given project.

Optimy

List project files (document manager)

Lists files uploaded in the “document manager" of the project.

Optimy

List project files (form)

Lists files uploaded through the form into a project.

Optimy

List project internal extra fields

Lists internal extra fields of a project.

Optimy

List project part versions

Lists all part versions of a project.

Optimy

List projects

Lists all projects. Optionally filters by form, form part, project owner, project status.

Optimy

List project statuses

Lists all available project statuses

Optimy

List project tasks

Lists all tasks of a project.

JIRA Software

Get Issue Comments

Get comments based on issue id

JIRA Software

Search Issues

Search issues using JQL

Apify

Get Dataset Items

Fetches items from a dataset.

Twitch

List Featured Streams

Gets a list of all featured live streams.

Twitch

List Followed Streams

Gets a list of online streams you follow.

Twitch

List Followed Videos

Gets the videos from channels you follow.

Twitch

List Channel Communities

Gets the communities for a specified channel

Twitch

List Channel Editors

Gets a list of users who are editors for your channel.

Twitch

List Channel Followers

Gets a list of users who follow a specified channel, sorted by the date when they started following the channel.

Twitch

List Channel Subscribers

Gets a list of users subscribed to your channel.

Twitch

List Channel Teams

Gets a list of teams to which a specified channel belongs.

Twitch

List Channel Videos

Gets a list of VODs (Video on Demand) from a specified channel.

Twitch

List Live Streams

Gets a list of live streams.

Twitch

List Top Clips

Gets the top clips which meet a specified set of parameters.

Twitch

List Top Videos

Gets the top videos based on viewcount, optionally filtered by game or time period.

Twitch

List User Block List

Shows your block list. List sorted by recency, newest first.

Twitch

List User Follows

Gets a list of all channels followed by a specified user, sorted by the date when they started following each channel.

Twitch

List Users

Gets the user objects for the specified Twitch login names (up to 100). If a specified user’s Twitch-registered email address is not verified, null is returned for that user.

Twitch

Search Games

Searches for games based on a specified query parameter. A game is returned if the query parameter is matched entirely or partially, in the game name.

Twitch

Search Channels

Searches for channels based on a specified query parameter. A channel is returned if the query parameter is matched entirely or partially, in the channel description or game name.

Twitch

Search Streams

Searches for streams based on a specified query parameter. Returns up to 10 streams if the query parameter is matched entirely or partially, in the channel description or game name.