Google Sheets, Microsoft SQL Server, JIRA Software, Teamwork Projects, Etsy, Flickr Integrations

Etsy
Flickr
Google Sheets
Microsoft SQL Server
Teamwork Projects
JIRA Software
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.

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.

Teamwork Projects

New event INSTANT

Triggers when a new event occurs (for example, when a new task is added or completed).

Teamwork Projects

Watch companies

Triggers when a new company is added.

Teamwork Projects

Watch files

Triggers when a new file is uploaded.

Teamwork Projects

Watch milestones

Triggers when a new milestone is added.

Teamwork Projects

Watch people

Triggers when a new person (user or contact) is added.

Teamwork Projects

Watch projects

Triggers when a new project is created.

Teamwork Projects

Watch task lists

Triggers when a new task list is added.

Teamwork Projects

Watch tasks

Triggers when a new task is added.

Teamwork Projects

Watch time entries

Triggers when a new time entry is added.

Etsy

Watch Shop Receipts

Triggers when a new show receipts is added.

Flickr

Watch photos

Triggers when a new photo is added to an account being watched.

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.

Microsoft SQL Server

Delete row(s) from a table

Microsoft SQL Server

Execute a query (advanced)

Microsoft SQL Server

Execute stored procedure

Microsoft SQL Server

Insert row into a table

Microsoft SQL Server

Update row(s) in a table

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

Teamwork Projects

Add a person to a project

Adds a selected person to a project.

Teamwork Projects

Complete a task

Markes the specified task as complete.

Teamwork Projects

Create a calendar event

Creates a new calendar event.

Teamwork Projects

Create a company

Creates a new company.

Teamwork Projects

Create a link

Adds a new link to a selected project.

Teamwork Projects

Create a milestone

Creates a new milestone.

Teamwork Projects

Create a person

Creates a new person.

Teamwork Projects

Create a project

Creates a new project.

Teamwork Projects

Create a subtask

Adds a new subtask to a selected task.

Teamwork Projects

Create a task

Adds a new task to a specified task list.

Teamwork Projects

Create a task list

Creates a new task list in a specified project.

Teamwork Projects

Create a time entry

Adds a new time entry to a given project or task.

Teamwork Projects

Delete a calendar event

Deletes a calendar event.

Teamwork Projects

Delete a company

Deletes a company with a given ID.

Teamwork Projects

Delete a file

Deletes a file with a given ID.

Teamwork Projects

Delete a link

Deletes the link specified by link ID.

Teamwork Projects

Delete a milestone

Deletes a milestone with a given ID.

Teamwork Projects

Delete a person

Deletes a person with a given ID.

Teamwork Projects

Delete a project

Deletes a project with a given ID.

Teamwork Projects

Delete a task

Deletes a task with a given ID.

Teamwork Projects

Delete a task list

Deletes a task with a given ID.

Teamwork Projects

Download a file

Downloads a file with a given ID.

Teamwork Projects

Get a company

Retrieves information about a company with a given ID.

Teamwork Projects

Get a milestone

Retrieves information about a milestone with a given ID.

Teamwork Projects

Get a person

Retrieves information about a person with a given ID.

Teamwork Projects

Get a project

Retrieve information about a project with a given ID.

Teamwork Projects

Get a task

Retrieves information about a task with a given ID.

Teamwork Projects

Get a task list

Retrieves information about a task list with a given ID.

Teamwork Projects

Get a time entry

Returns a time entry by ID.

Teamwork Projects

Remove a person from a project

Removes a selected person from a project.

Teamwork Projects

Set project owner

Sets a selected person as a project owner.

Teamwork Projects

Update a person

Updates a person with a given ID.

Teamwork Projects

Update a project

Updates a project with a given ID.

Teamwork Projects

Update a task

Modifies information about a task with a specified ID.

Teamwork Projects

Upload a file

Uploads a file into a specific project.

Etsy

Create Listing

Creates a new listing

Etsy

Create User Address

Creates a new UserAddress. Note: state is required when the country is US, Canada, or Australia. See section above about valid codes.

Etsy

Delete Listing

Deletes a listing.

Etsy

Delete User Address

Deletes the an account user address with the given id.

Etsy

Get Inventory

Gets the inventory for a listing.

Etsy

Get Ledger

Gets a shop payment account ledger.

Etsy

Get Listing

Retrieves a listing by ID.

Etsy

Get Offering

Get a specific offering for a listing.

Etsy

Get Product

Gets a specific offering for a listing.

Etsy

Get Shop Receipt

Retrieves a shop receipt by ID.

Etsy

Get Transaction

Retrieves a shop transaction by ID.

Etsy

Get User Address

Retrieves a an account user address by id.

Etsy

Get User Profile

Returns the user profile object associated with an account user.

Etsy

Make an API Call

Performs an arbitrary authorized API call.

Etsy

Submit Tracking

Submits tracking information and sends a shipping notification email to the buyer.

Etsy

Update Listing

Updates a listing. Note that the Etsy API will attempt to activate a Listing after every edit operation. This may result in charges to the user's Etsy bill. To edit an inactive Listing without activating it, pass the optional parameter State = Inactive.

Etsy

Update Shop Receipt

Updates a shop receipt.

Etsy

Update User Profile

Updates the user profile object associated with an account user.

Flickr

Upload a photo

Flickr

Delete a photo

Flickr

Remove a photo from a photoset

Flickr

Add a photo to a photoset

Flickr

Create a photoset

Flickr

Delete a photoset

Iterators

Microsoft SQL Server

Iterate recordset

Iterates through received recordset.

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.

Microsoft SQL Server

Select row(s) from a table

JIRA Software

Get Issue Comments

Get comments based on issue id

JIRA Software

Search Issues

Search issues using JQL

Etsy

Find All Listings

Retrieves a list of all listings which are active, interesting, trending or featured treasuries.

Etsy

Find Ledger Entries

Gets a shop payment account ledger's entries

Etsy

Find Shop Listings

Finds all listings associated with a shop.

Etsy

Find Shop Receipts

Retrieves a set of receipt objects assciated to a shop.

Etsy

Find Transactions

Retrieves a set of Transaction objects associated to a shop, listing or receipt.

Etsy

Find User Addresses

Retrieves a set of user address objects associated to an account user.

Etsy

Find Users

Finds users who circled or are circled by an account user or gets the details of an account user.