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!
This scenario helps you iterate over a ParseHub dataset. At specific intervals, Integromat will automatically extract and convert the latest data to a JSON file. Then, we use an iterator to parse the data line by line and the result is saved in Google Sheets. This template follows the starting tutorial from ParseHub and will output this example Spreadsheet.
Receives data passed to the function INTEGROMAT used in a sheet. Sheets Add-On required.
Triggers when a cell is updated. Watches only changes made in Google Sheet app. Sheets Add-On required.
Watches for new rows.
Compress binary data with Deflate algorithm.
Decompress a gzip binary data.
Compress binary data using gzip.
Decompress binary data with Inflate algorithm.
Extracts files from a ZIP archive.
Appends a new row to the bottom of the table.
Adds a new sheet.
Cleares a specific cell.
Clears values from a specific row.
Copies a sheet to another spreadsheet.
Creates a new spreadsheet.
Creates a new spreadsheet from a template sheet.
Deletes a specific row.
Deletes a specific sheet.
Gets a specific cell.
Performs an arbitrary authorized API call.
Returns processed data as a result of the INTEGROMAT function. Sheets Add-On required.
Updates a specific cell.
Updates a row.
Creates a ZIP or TAR archive from received files.
Gets a range content.
Gets a list of all sheets in a spreadsheet.
Returns results matching the given criteria.
Returns results matching the given criteria. This module doesn't return a row number.