Last active
October 31, 2022 03:58
-
-
Save Kushal6070/4fdbe8f6fbd1da1ff0c91b2123631bb2 to your computer and use it in GitHub Desktop.
Make(Integromat) + Shotstack + Google Sheets automotive video generator blueprint
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "name": "Automotive slideshow generator", | |
| "flow": [ | |
| { | |
| "id": 14, | |
| "module": "google-sheets:filterRows", | |
| "version": 2, | |
| "parameters": { | |
| "__IMTCONN__": 306021 | |
| }, | |
| "mapper": { | |
| "spreadsheetId": "1u3m0MZsHTDi94IswhU14q_fMMFY4ZfjXH3fTk4Wsrew", | |
| "valueRenderOption": "FORMATTED_VALUE", | |
| "dateTimeRenderOption": "FORMATTED_STRING", | |
| "sheetId": "Sheet1", | |
| "includesHeaders": true, | |
| "tableFirstRow": "A1:CZ1", | |
| "filter": [ | |
| [ | |
| { | |
| "a": "C", | |
| "o": "text:equal:ci", | |
| "b": "captur" | |
| } | |
| ] | |
| ], | |
| "sortOrder": "asc" | |
| }, | |
| "metadata": { | |
| "designer": { | |
| "x": -44, | |
| "y": -7 | |
| }, | |
| "restore": { | |
| "parameters": { | |
| "__IMTCONN__": { | |
| "label": "Kushal@shotstack.io Google connection (kushal@shotstack.io)", | |
| "data": { | |
| "scoped": "true", | |
| "connection": "google" | |
| } | |
| } | |
| }, | |
| "expect": { | |
| "spreadsheetId": { | |
| "mode": "chose", | |
| "label": "automotive-slideshow" | |
| }, | |
| "valueRenderOption": { | |
| "mode": "chose", | |
| "label": "Formatted value" | |
| }, | |
| "dateTimeRenderOption": { | |
| "mode": "chose", | |
| "label": "Formatted string" | |
| }, | |
| "sheetId": { | |
| "mode": "chose", | |
| "label": "Sheet1" | |
| }, | |
| "includesHeaders": { | |
| "mode": "chose", | |
| "label": "Yes" | |
| }, | |
| "tableFirstRow": { | |
| "label": "A-CZ" | |
| }, | |
| "sortOrder": { | |
| "mode": "chose", | |
| "label": "Ascending" | |
| }, | |
| "orderBy": { | |
| "mode": "chose" | |
| } | |
| } | |
| }, | |
| "parameters": [ | |
| { | |
| "name": "__IMTCONN__", | |
| "type": "account:google", | |
| "label": "Connection", | |
| "required": true | |
| } | |
| ], | |
| "expect": [ | |
| { | |
| "name": "spreadsheetId", | |
| "type": "select", | |
| "label": "Spreadsheet", | |
| "required": true | |
| }, | |
| { | |
| "name": "valueRenderOption", | |
| "type": "select", | |
| "label": "Value render option", | |
| "validate": { | |
| "enum": [ | |
| "FORMATTED_VALUE", | |
| "UNFORMATTED_VALUE", | |
| "FORMULA" | |
| ] | |
| } | |
| }, | |
| { | |
| "name": "dateTimeRenderOption", | |
| "type": "select", | |
| "label": "Date and time render option", | |
| "validate": { | |
| "enum": [ | |
| "SERIAL_NUMBER", | |
| "FORMATTED_STRING" | |
| ] | |
| } | |
| }, | |
| { | |
| "name": "limit", | |
| "type": "number", | |
| "label": "Maximum number of returned rows" | |
| }, | |
| { | |
| "name": "sheetId", | |
| "type": "select", | |
| "label": "Sheet", | |
| "required": true | |
| }, | |
| { | |
| "name": "includesHeaders", | |
| "type": "select", | |
| "label": "Table contains headers", | |
| "required": true, | |
| "validate": { | |
| "enum": [ | |
| true, | |
| false | |
| ] | |
| } | |
| }, | |
| { | |
| "name": "tableFirstRow", | |
| "type": "select", | |
| "label": "Column range", | |
| "required": true, | |
| "validate": { | |
| "enum": [ | |
| "A1:Z1", | |
| "A1:BZ1", | |
| "A1:CZ1", | |
| "A1:DZ1", | |
| "A1:MZ1", | |
| "A1:ZZ1", | |
| "A1:AZZ1", | |
| "A1:BZZ1", | |
| "A1:CZZ1", | |
| "A1:DZZ1", | |
| "A1:MZZ1", | |
| "A1:ZZZ1" | |
| ] | |
| } | |
| }, | |
| { | |
| "name": "filter", | |
| "type": "filter", | |
| "label": "Filter", | |
| "options": "rpc://google-sheets/2/rpcGetFilterKeys?includesHeaders=true" | |
| }, | |
| { | |
| "name": "sortOrder", | |
| "type": "select", | |
| "label": "Sort order", | |
| "validate": { | |
| "enum": [ | |
| "asc", | |
| "desc" | |
| ] | |
| } | |
| }, | |
| { | |
| "name": "orderBy", | |
| "type": "select", | |
| "label": "Order by" | |
| } | |
| ], | |
| "interface": [ | |
| { | |
| "name": "__IMTLENGTH__", | |
| "label": "Total number of bundles", | |
| "type": "uinteger" | |
| }, | |
| { | |
| "name": "__IMTINDEX__", | |
| "label": "Bundle order position", | |
| "type": "uinteger" | |
| }, | |
| { | |
| "name": "__ROW_NUMBER__", | |
| "label": "Row number", | |
| "type": "number" | |
| }, | |
| { | |
| "name": "__SPREADSHEET_ID__", | |
| "label": "Spreadsheet ID", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "__SHEET__", | |
| "label": "Sheet", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "0", | |
| "label": "Year (A)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "1", | |
| "label": "Make (B)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "2", | |
| "label": "Model (C)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "3", | |
| "label": "Decription (D)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "4", | |
| "label": "Engine (E)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "5", | |
| "label": "Kms (F)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "6", | |
| "label": "First_Image (G)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "7", | |
| "label": "Second_Image (H)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "8", | |
| "label": "Third_Image (I)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "9", | |
| "label": "Price (J)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "10", | |
| "label": "Price_Disclaimer (K)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "11", | |
| "label": "Price_Method (L)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "12", | |
| "label": "Dealer_Logo (M)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "13", | |
| "label": "Website (N)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "14", | |
| "label": "Video_URL (O)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "15", | |
| "label": "(P)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "16", | |
| "label": "(Q)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "17", | |
| "label": "(R)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "18", | |
| "label": "(S)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "19", | |
| "label": "(T)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "20", | |
| "label": "(U)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "21", | |
| "label": "(V)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "22", | |
| "label": "(W)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "23", | |
| "label": "(X)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "24", | |
| "label": "(Y)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "25", | |
| "label": "(Z)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "26", | |
| "label": "(AA)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "27", | |
| "label": "(AB)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "28", | |
| "label": "(AC)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "29", | |
| "label": "(AD)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "30", | |
| "label": "(AE)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "31", | |
| "label": "(AF)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "32", | |
| "label": "(AG)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "33", | |
| "label": "(AH)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "34", | |
| "label": "(AI)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "35", | |
| "label": "(AJ)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "36", | |
| "label": "(AK)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "37", | |
| "label": "(AL)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "38", | |
| "label": "(AM)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "39", | |
| "label": "(AN)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "40", | |
| "label": "(AO)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "41", | |
| "label": "(AP)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "42", | |
| "label": "(AQ)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "43", | |
| "label": "(AR)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "44", | |
| "label": "(AS)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "45", | |
| "label": "(AT)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "46", | |
| "label": "(AU)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "47", | |
| "label": "(AV)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "48", | |
| "label": "(AW)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "49", | |
| "label": "(AX)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "50", | |
| "label": "(AY)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "51", | |
| "label": "(AZ)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "52", | |
| "label": "(BA)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "53", | |
| "label": "(BB)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "54", | |
| "label": "(BC)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "55", | |
| "label": "(BD)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "56", | |
| "label": "(BE)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "57", | |
| "label": "(BF)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "58", | |
| "label": "(BG)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "59", | |
| "label": "(BH)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "60", | |
| "label": "(BI)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "61", | |
| "label": "(BJ)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "62", | |
| "label": "(BK)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "63", | |
| "label": "(BL)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "64", | |
| "label": "(BM)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "65", | |
| "label": "(BN)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "66", | |
| "label": "(BO)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "67", | |
| "label": "(BP)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "68", | |
| "label": "(BQ)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "69", | |
| "label": "(BR)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "70", | |
| "label": "(BS)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "71", | |
| "label": "(BT)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "72", | |
| "label": "(BU)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "73", | |
| "label": "(BV)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "74", | |
| "label": "(BW)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "75", | |
| "label": "(BX)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "76", | |
| "label": "(BY)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "77", | |
| "label": "(BZ)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "78", | |
| "label": "(CA)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "79", | |
| "label": "(CB)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "80", | |
| "label": "(CC)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "81", | |
| "label": "(CD)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "82", | |
| "label": "(CE)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "83", | |
| "label": "(CF)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "84", | |
| "label": "(CG)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "85", | |
| "label": "(CH)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "86", | |
| "label": "(CI)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "87", | |
| "label": "(CJ)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "88", | |
| "label": "(CK)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "89", | |
| "label": "(CL)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "90", | |
| "label": "(CM)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "91", | |
| "label": "(CN)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "92", | |
| "label": "(CO)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "93", | |
| "label": "(CP)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "94", | |
| "label": "(CQ)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "95", | |
| "label": "(CR)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "96", | |
| "label": "(CS)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "97", | |
| "label": "(CT)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "98", | |
| "label": "(CU)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "99", | |
| "label": "(CV)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "100", | |
| "label": "(CW)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "101", | |
| "label": "(CX)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "102", | |
| "label": "(CY)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "103", | |
| "label": "(CZ)", | |
| "type": "text" | |
| } | |
| ] | |
| } | |
| }, | |
| { | |
| "id": 15, | |
| "module": "shotstack:dynamicTemplate", | |
| "version": 2, | |
| "parameters": { | |
| "__IMTCONN__": 416186 | |
| }, | |
| "filter": { | |
| "name": "If bundle > 1", | |
| "conditions": [ | |
| [ | |
| { | |
| "a": "{{14.`__IMTLENGTH__`}}", | |
| "o": "number:greater", | |
| "b": "0" | |
| } | |
| ] | |
| ] | |
| }, | |
| "mapper": { | |
| "templateId": "2ad5e264-de76-413d-9999-63282fde491e", | |
| "variables": { | |
| "Vehicle_Year": "{{14.`0`}}", | |
| "Vehicle_Make": "{{14.`1`}}", | |
| "Vehicle_Model": "{{14.`2`}}", | |
| "Vehicle_Description": "{{14.`3`}}", | |
| "First_image": "{{14.`6`}}", | |
| "Vehicle_Engine_Type": "{{14.`4`}}", | |
| "Vehicle_kms": "{{14.`5`}}", | |
| "Second_image": "{{14.`7`}}", | |
| "Third_image": "{{14.`8`}}", | |
| "First_Image": "{{14.`6`}}", | |
| "Second_Image": "{{14.`7`}}", | |
| "Third_Image": "{{14.`8`}}", | |
| "Vehicle_Price": "{{14.`9`}}", | |
| "Vehicle_Price_Disclaimer": "{{14.`10`}}", | |
| "Vehicle_Price_Method": "{{14.`11`}}", | |
| "dealer_logo": "{{14.`12`}}", | |
| "Dealer_website": "{{14.`13`}}" | |
| } | |
| }, | |
| "metadata": { | |
| "designer": { | |
| "x": 256, | |
| "y": -7 | |
| }, | |
| "restore": { | |
| "parameters": { | |
| "__IMTCONN__": { | |
| "label": "Kushal - sandbox", | |
| "data": { | |
| "scoped": "true", | |
| "connection": "shotstack2" | |
| } | |
| } | |
| }, | |
| "expect": { | |
| "templateId": { | |
| "mode": "chose", | |
| "nested": [ | |
| { | |
| "name": "variables", | |
| "type": "collection", | |
| "label": "Merge Fields", | |
| "spec": [ | |
| { | |
| "name": "Vehicle_Year", | |
| "label": "Vehicle_year", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "Vehicle_Make", | |
| "label": "Vehicle_make", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "Vehicle_Model", | |
| "label": "Vehicle_model", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "Vehicle_Description", | |
| "label": "Vehicle_description", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "First_image", | |
| "label": "First_image", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "Vehicle_Engine_Type", | |
| "label": "Vehicle_engine_type", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "Vehicle_kms", | |
| "label": "Vehicle_kms", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "Second_image", | |
| "label": "Second_image", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "Third_image", | |
| "label": "Third_image", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "First_Image", | |
| "label": "First_image", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "Second_Image", | |
| "label": "Second_image", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "Third_Image", | |
| "label": "Third_image", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "Vehicle_Price", | |
| "label": "Vehicle_price", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "Vehicle_Price_Disclaimer", | |
| "label": "Vehicle_price_disclaimer", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "Vehicle_Price_Method", | |
| "label": "Vehicle_price_method", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "dealer_logo", | |
| "label": "Dealer_logo", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "Dealer_website", | |
| "label": "Dealer_website", | |
| "type": "text" | |
| } | |
| ] | |
| } | |
| ], | |
| "label": "Test" | |
| } | |
| } | |
| }, | |
| "parameters": [ | |
| { | |
| "name": "__IMTCONN__", | |
| "type": "account:shotstack2", | |
| "label": "Connection", | |
| "required": true | |
| } | |
| ], | |
| "expect": [ | |
| { | |
| "name": "templateId", | |
| "type": "select", | |
| "label": "Template", | |
| "required": true | |
| }, | |
| { | |
| "name": "variables", | |
| "type": "collection", | |
| "label": "Merge Fields", | |
| "spec": [ | |
| { | |
| "name": "Vehicle_Year", | |
| "type": "text", | |
| "label": "Vehicle_year" | |
| }, | |
| { | |
| "name": "Vehicle_Make", | |
| "type": "text", | |
| "label": "Vehicle_make" | |
| }, | |
| { | |
| "name": "Vehicle_Model", | |
| "type": "text", | |
| "label": "Vehicle_model" | |
| }, | |
| { | |
| "name": "Vehicle_Description", | |
| "type": "text", | |
| "label": "Vehicle_description" | |
| }, | |
| { | |
| "name": "First_image", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "Vehicle_Engine_Type", | |
| "type": "text", | |
| "label": "Vehicle_engine_type" | |
| }, | |
| { | |
| "name": "Vehicle_kms", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "Second_image", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "Third_image", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "First_Image", | |
| "type": "text", | |
| "label": "First_image" | |
| }, | |
| { | |
| "name": "Second_Image", | |
| "type": "text", | |
| "label": "Second_image" | |
| }, | |
| { | |
| "name": "Third_Image", | |
| "type": "text", | |
| "label": "Third_image" | |
| }, | |
| { | |
| "name": "Vehicle_Price", | |
| "type": "text", | |
| "label": "Vehicle_price" | |
| }, | |
| { | |
| "name": "Vehicle_Price_Disclaimer", | |
| "type": "text", | |
| "label": "Vehicle_price_disclaimer" | |
| }, | |
| { | |
| "name": "Vehicle_Price_Method", | |
| "type": "text", | |
| "label": "Vehicle_price_method" | |
| }, | |
| { | |
| "name": "dealer_logo", | |
| "type": "text", | |
| "label": "Dealer_logo" | |
| }, | |
| { | |
| "name": "Dealer_website", | |
| "type": "text" | |
| } | |
| ] | |
| } | |
| ] | |
| } | |
| }, | |
| { | |
| "id": 16, | |
| "module": "util:FunctionSleep", | |
| "version": 1, | |
| "parameters": {}, | |
| "mapper": { | |
| "duration": "60" | |
| }, | |
| "metadata": { | |
| "designer": { | |
| "x": 565, | |
| "y": 0 | |
| }, | |
| "restore": {}, | |
| "expect": [ | |
| { | |
| "name": "duration", | |
| "type": "uinteger", | |
| "label": "Delay", | |
| "required": true, | |
| "validate": { | |
| "max": 300, | |
| "min": 1 | |
| } | |
| } | |
| ] | |
| } | |
| }, | |
| { | |
| "id": 17, | |
| "module": "shotstack:renderStatus", | |
| "version": 2, | |
| "parameters": { | |
| "__IMTCONN__": 416186 | |
| }, | |
| "mapper": { | |
| "uuid": "{{15.id}}" | |
| }, | |
| "metadata": { | |
| "designer": { | |
| "x": 865, | |
| "y": 0 | |
| }, | |
| "restore": { | |
| "parameters": { | |
| "__IMTCONN__": { | |
| "data": { | |
| "scoped": "true", | |
| "connection": "shotstack2" | |
| }, | |
| "label": "Kushal - sandbox" | |
| } | |
| } | |
| }, | |
| "parameters": [ | |
| { | |
| "name": "__IMTCONN__", | |
| "type": "account:shotstack2", | |
| "label": "Connection", | |
| "required": true | |
| } | |
| ], | |
| "expect": [ | |
| { | |
| "name": "uuid", | |
| "type": "uuid", | |
| "label": "Render ID", | |
| "required": true | |
| } | |
| ] | |
| } | |
| }, | |
| { | |
| "id": 18, | |
| "module": "google-sheets:updateRow", | |
| "version": 2, | |
| "parameters": { | |
| "__IMTCONN__": 306021 | |
| }, | |
| "mapper": { | |
| "mode": "select", | |
| "valueInputOption": "USER_ENTERED", | |
| "from": "drive", | |
| "spreadsheetId": "/1u3m0MZsHTDi94IswhU14q_fMMFY4ZfjXH3fTk4Wsrew", | |
| "sheetId": "Sheet1", | |
| "rowNumber": "{{14.`__ROW_NUMBER__`}}", | |
| "includesHeaders": true, | |
| "values": { | |
| "14": "{{17.url}}" | |
| } | |
| }, | |
| "metadata": { | |
| "designer": { | |
| "x": 1165, | |
| "y": 0 | |
| }, | |
| "restore": { | |
| "parameters": { | |
| "__IMTCONN__": { | |
| "label": "Kushal@shotstack.io Google connection (kushal@shotstack.io)", | |
| "data": { | |
| "scoped": "true", | |
| "connection": "google" | |
| } | |
| } | |
| }, | |
| "expect": { | |
| "mode": { | |
| "label": "Select from the list" | |
| }, | |
| "valueInputOption": { | |
| "mode": "chose", | |
| "label": "User entered" | |
| }, | |
| "from": { | |
| "label": "My Drive" | |
| }, | |
| "spreadsheetId": { | |
| "path": [ | |
| "automotive-slideshow" | |
| ] | |
| }, | |
| "sheetId": { | |
| "label": "Sheet1" | |
| }, | |
| "includesHeaders": { | |
| "nested": [ | |
| { | |
| "name": "values", | |
| "label": "Values", | |
| "type": "collection", | |
| "spec": [ | |
| { | |
| "name": "0", | |
| "label": "Year (A)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "1", | |
| "label": "Make (B)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "2", | |
| "label": "Model (C)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "3", | |
| "label": "Decription (D)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "4", | |
| "label": "Engine (E)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "5", | |
| "label": "Kms (F)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "6", | |
| "label": "First_Image (G)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "7", | |
| "label": "Second_Image (H)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "8", | |
| "label": "Third_Image (I)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "9", | |
| "label": "Price (J)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "10", | |
| "label": "Price_Disclaimer (K)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "11", | |
| "label": "Price_Method (L)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "12", | |
| "label": "Dealer_Logo (M)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "13", | |
| "label": "Website (N)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "14", | |
| "label": "Video_URL (O)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "15", | |
| "label": "(P)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "16", | |
| "label": "(Q)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "17", | |
| "label": "(R)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "18", | |
| "label": "(S)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "19", | |
| "label": "(T)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "20", | |
| "label": "(U)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "21", | |
| "label": "(V)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "22", | |
| "label": "(W)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "23", | |
| "label": "(X)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "24", | |
| "label": "(Y)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "25", | |
| "label": "(Z)", | |
| "type": "text" | |
| }, | |
| { | |
| "name": "26", | |
| "label": "(AA)", | |
| "type": "text" | |
| } | |
| ] | |
| } | |
| ], | |
| "label": "Yes" | |
| } | |
| } | |
| }, | |
| "parameters": [ | |
| { | |
| "name": "__IMTCONN__", | |
| "type": "account:google", | |
| "label": "Connection", | |
| "required": true | |
| } | |
| ], | |
| "expect": [ | |
| { | |
| "name": "mode", | |
| "type": "select", | |
| "label": "Choose a Method", | |
| "required": true, | |
| "validate": { | |
| "enum": [ | |
| "select", | |
| "map" | |
| ] | |
| } | |
| }, | |
| { | |
| "name": "valueInputOption", | |
| "type": "select", | |
| "label": "Value input option", | |
| "validate": { | |
| "enum": [ | |
| "USER_ENTERED", | |
| "RAW" | |
| ] | |
| } | |
| }, | |
| { | |
| "name": "from", | |
| "type": "select", | |
| "label": "Choose a Drive", | |
| "required": true, | |
| "validate": { | |
| "enum": [ | |
| "drive", | |
| "share", | |
| "team" | |
| ] | |
| } | |
| }, | |
| { | |
| "name": "spreadsheetId", | |
| "type": "file", | |
| "label": "Spreadsheet ID", | |
| "required": true | |
| }, | |
| { | |
| "name": "sheetId", | |
| "type": "select", | |
| "label": "Sheet Name", | |
| "required": true | |
| }, | |
| { | |
| "name": "rowNumber", | |
| "type": "uinteger", | |
| "label": "Row number", | |
| "required": true | |
| }, | |
| { | |
| "name": "includesHeaders", | |
| "type": "select", | |
| "label": "Table contains headers", | |
| "required": true, | |
| "validate": { | |
| "enum": [ | |
| true, | |
| false | |
| ] | |
| } | |
| }, | |
| { | |
| "name": "values", | |
| "type": "collection", | |
| "label": "Values", | |
| "spec": [ | |
| { | |
| "name": "0", | |
| "type": "text", | |
| "label": "Year (A)" | |
| }, | |
| { | |
| "name": "1", | |
| "type": "text", | |
| "label": "Make (B)" | |
| }, | |
| { | |
| "name": "2", | |
| "type": "text", | |
| "label": "Model (C)" | |
| }, | |
| { | |
| "name": "3", | |
| "type": "text", | |
| "label": "Decription (D)" | |
| }, | |
| { | |
| "name": "4", | |
| "type": "text", | |
| "label": "Engine (E)" | |
| }, | |
| { | |
| "name": "5", | |
| "type": "text", | |
| "label": "Kms (F)" | |
| }, | |
| { | |
| "name": "6", | |
| "type": "text", | |
| "label": "First_Image (G)" | |
| }, | |
| { | |
| "name": "7", | |
| "type": "text", | |
| "label": "Second_Image (H)" | |
| }, | |
| { | |
| "name": "8", | |
| "type": "text", | |
| "label": "Third_Image (I)" | |
| }, | |
| { | |
| "name": "9", | |
| "type": "text", | |
| "label": "Price (J)" | |
| }, | |
| { | |
| "name": "10", | |
| "type": "text", | |
| "label": "Price_Disclaimer (K)" | |
| }, | |
| { | |
| "name": "11", | |
| "type": "text", | |
| "label": "Price_Method (L)" | |
| }, | |
| { | |
| "name": "12", | |
| "type": "text", | |
| "label": "Dealer_Logo (M)" | |
| }, | |
| { | |
| "name": "13", | |
| "type": "text", | |
| "label": "Website (N)" | |
| }, | |
| { | |
| "name": "14", | |
| "type": "text", | |
| "label": "Video_URL (O)" | |
| }, | |
| { | |
| "name": "15", | |
| "type": "text", | |
| "label": "(P)" | |
| }, | |
| { | |
| "name": "16", | |
| "type": "text", | |
| "label": "(Q)" | |
| }, | |
| { | |
| "name": "17", | |
| "type": "text", | |
| "label": "(R)" | |
| }, | |
| { | |
| "name": "18", | |
| "type": "text", | |
| "label": "(S)" | |
| }, | |
| { | |
| "name": "19", | |
| "type": "text", | |
| "label": "(T)" | |
| }, | |
| { | |
| "name": "20", | |
| "type": "text", | |
| "label": "(U)" | |
| }, | |
| { | |
| "name": "21", | |
| "type": "text", | |
| "label": "(V)" | |
| }, | |
| { | |
| "name": "22", | |
| "type": "text", | |
| "label": "(W)" | |
| }, | |
| { | |
| "name": "23", | |
| "type": "text", | |
| "label": "(X)" | |
| }, | |
| { | |
| "name": "24", | |
| "type": "text", | |
| "label": "(Y)" | |
| }, | |
| { | |
| "name": "25", | |
| "type": "text", | |
| "label": "(Z)" | |
| }, | |
| { | |
| "name": "26", | |
| "type": "text", | |
| "label": "(AA)" | |
| } | |
| ] | |
| } | |
| ] | |
| } | |
| } | |
| ], | |
| "metadata": { | |
| "instant": false, | |
| "version": 1, | |
| "scenario": { | |
| "roundtrips": 1, | |
| "maxErrors": 3, | |
| "autoCommit": true, | |
| "autoCommitTriggerLast": true, | |
| "sequential": false, | |
| "confidential": false, | |
| "dataloss": false, | |
| "dlq": false, | |
| "freshVariables": false | |
| }, | |
| "designer": { | |
| "orphans": [] | |
| }, | |
| "zone": "us1.make.com" | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment