Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- PASTE EVERYTHING BELOW INTO A NEW TEXT FILE AND SAVE
- {
- "name": "GoogleSheets example",
- "flow": [
- {
- "id": 3,
- "module": "google-sheets:createSpreadsheet",
- "version": 2,
- "parameters": {
- "__IMTCONN__": 1072928
- },
- "mapper": {
- "sheets": [
- {
- "properties": {
- "title": "Hello"
- }
- },
- {
- "properties": {
- "title": "Tab 2"
- }
- }
- ],
- "properties": {
- "title": "Hello",
- "timeZone": "America/Adak",
- "defaultFormat": {}
- }
- },
- "metadata": {
- "designer": {
- "x": 0,
- "y": 0,
- "name": "Set Up"
- },
- "restore": {
- "sheets": {
- "mode": "chose",
- "items": [
- "undefined",
- "undefined"
- ]
- },
- "properties": {
- "nested": {
- "timeZone": {
- "mode": "chose",
- "label": "(GMT-10:00) America/Adak"
- },
- "autoRecalc": {
- "mode": "chose",
- "label": ""
- },
- "defaultFormat": {
- "nested": {
- "numberFormat": {
- "mode": "chose",
- "label": ""
- }
- }
- }
- }
- },
- "__IMTCONN__": {
- "label": "My Google connection (redacted@invalid.org)"
- }
- },
- "parameters": [
- {
- "name": "__IMTCONN__",
- "type": "account",
- "label": "Connection",
- "required": true
- }
- ],
- "expect": [
- {
- "name": "properties",
- "spec": [
- {
- "name": "defaultFormat",
- "spec": [
- {
- "name": "numberFormat",
- "type": "select",
- "label": "Number format",
- "validate": {
- "enum": [
- "TEXT",
- "NUMBER",
- "PERCENT",
- "CURRENCY",
- "DATE",
- "TIME",
- "DATE_TIME",
- "SCIENTIFIC"
- ]
- }
- }
- ],
- "type": "collection",
- "label": "Default format"
- },
- {
- "name": "title",
- "type": "text",
- "label": "Title",
- "required": true
- },
- {
- "name": "locale",
- "type": "text",
- "label": "Locale"
- },
- {
- "name": "autoRecalc",
- "type": "select",
- "label": "Recalculation interval",
- "validate": {
- "enum": [
- "ON_CHANGE",
- "MINUTE",
- "HOUR"
- ]
- }
- },
- {
- "name": "timeZone",
- "type": "select",
- "label": "Time zone"
- }
- ],
- "type": "collection",
- "label": "Properties"
- },
- {
- "name": "sheets",
- "spec": [
- {
- "name": "properties",
- "spec": [
- {
- "name": "title",
- "type": "text",
- "label": "Title"
- },
- {
- "help": "The index of the sheet within the spreadsheet.",
- "name": "index",
- "type": "number",
- "label": "Index",
- "advanced": true
- }
- ],
- "type": "collection",
- "label": "Properties"
- }
- ],
- "type": "array",
- "label": "Sheets"
- }
- ]
- }
- },
- {
- "id": 5,
- "module": "google-sheets:listSheets",
- "version": 2,
- "parameters": {
- "__IMTCONN__": 1072928
- },
- "mapper": {
- "spreadsheetId": "{{3.spreadsheetId}}"
- },
- "metadata": {
- "designer": {
- "x": 300,
- "y": 0,
- "name": "Get sheets within spreadsheet"
- },
- "restore": {
- "__IMTCONN__": {
- "label": "My Google connection (redacted@invalid.org)"
- },
- "spreadsheetId": {
- "mode": "edit"
- }
- },
- "parameters": [
- {
- "name": "__IMTCONN__",
- "type": "account",
- "label": "Connection",
- "required": true
- }
- ],
- "expect": [
- {
- "name": "spreadsheetId",
- "type": "select",
- "label": "Spreadsheet",
- "required": true
- }
- ]
- }
- },
- {
- "id": 6,
- "module": "builtin:BasicRepeater",
- "version": 1,
- "parameters": {},
- "mapper": {
- "step": "1",
- "start": "1",
- "repeats": "24"
- },
- "metadata": {
- "designer": {
- "x": 600,
- "y": 0,
- "name": "Repeater: iterates i number of times"
- },
- "expect": [
- {
- "name": "start",
- "type": "number",
- "label": "Initial value",
- "required": true
- },
- {
- "name": "repeats",
- "type": "number",
- "label": "Repeats",
- "required": true,
- "validate": {
- "max": 10000,
- "min": 0
- }
- },
- {
- "name": "step",
- "type": "number",
- "label": "Step",
- "required": true
- }
- ],
- "advanced": true
- }
- },
- {
- "id": 12,
- "module": "units:Convert",
- "version": 1,
- "parameters": {},
- "mapper": {
- "input": "{{6.i}} meters",
- "output": "feet"
- },
- "metadata": {
- "designer": {
- "x": 900,
- "y": 0,
- "name": "Placeholder for your 14 API calls"
- },
- "expect": [
- {
- "name": "input",
- "type": "text",
- "label": "Phrase",
- "required": true
- },
- {
- "name": "output",
- "type": "text",
- "label": "Target unit",
- "required": true
- }
- ]
- }
- },
- {
- "id": 10,
- "module": "builtin:BasicAggregator",
- "version": 1,
- "parameters": {
- "feeder": 6
- },
- "mapper": {
- "value": "{{12.value}}"
- },
- "metadata": {
- "designer": {
- "x": 1200,
- "y": 0
- },
- "restore": {
- "feeder": {
- "label": "Repeater [6]"
- },
- "mapper": {
- "label": [
- null
- ]
- },
- "target": {
- "label": "Custom"
- }
- }
- }
- },
- {
- "id": 4,
- "module": "google-sheets:addRow",
- "version": 2,
- "parameters": {
- "__IMTCONN__": 1072928
- },
- "mapper": {
- "mode": "map",
- "values": {
- "0": "{{10.array[].value}}",
- "1": "{{10.array[2].value}}",
- "2": "{{10.array[3].value}}",
- "3": "{{10.array[4].value}}",
- "4": "{{10.array[5].value}}",
- "5": "{{10.array[6].value}}",
- "6": "{{10.array[7].value}}",
- "7": "{{10.array[8].value}}",
- "8": "{{10.array[9].value}}",
- "9": "{{10.array[10].value}}",
- "10": "{{10.array[11].value}}",
- "11": "{{10.array[12].value}}",
- "12": "{{10.array[13].value}}",
- "13": "{{10.array[14].value}}",
- "14": "{{10.array[15].value}}",
- "15": "{{10.array[16].value}}"
- },
- "sheetId": "{{5.title}}",
- "spreadsheetId": "{{3.spreadsheetId}}",
- "tableFirstRow": "A1:Z1",
- "insertDataOption": "INSERT_ROWS",
- "valueInputOption": "RAW"
- },
- "metadata": {
- "designer": {
- "x": 1500,
- "y": 0
- },
- "restore": {
- "mode": {
- "label": "Map spreadsheet and sheet manually"
- },
- "__IMTCONN__": {
- "label": "My Google connection (redacted@invalid.org)"
- },
- "tableFirstRow": {
- "label": "A-Z"
- },
- "insertDataOption": {
- "mode": "chose",
- "label": "Insert rows"
- },
- "valueInputOption": {
- "mode": "chose",
- "label": "Raw"
- }
- },
- "parameters": [
- {
- "name": "__IMTCONN__",
- "type": "account",
- "label": "Connection",
- "required": true
- }
- ],
- "expect": [
- {
- "name": "mode",
- "type": "select",
- "label": "Mode",
- "required": true,
- "validate": {
- "enum": [
- "select",
- "map"
- ]
- }
- },
- {
- "name": "valueInputOption",
- "type": "select",
- "label": "Value input option",
- "validate": {
- "enum": [
- "USER_ENTERED",
- "RAW"
- ]
- }
- },
- {
- "name": "insertDataOption",
- "type": "select",
- "label": "Insert data option",
- "validate": {
- "enum": [
- "INSERT_ROWS",
- "OVERWRITE"
- ]
- }
- },
- {
- "name": "spreadsheetId",
- "type": "text",
- "label": "Spreadsheet",
- "required": true
- },
- {
- "name": "sheetId",
- "type": "text",
- "label": "Sheet",
- "required": true
- },
- {
- "name": "tableFirstRow",
- "type": "select",
- "label": "Column range",
- "required": true,
- "validate": {
- "enum": [
- "A1:Z1",
- "A1:BZ1",
- "A1:CZ1",
- "A1:DZ1",
- "A1:MZ1",
- "A1:ZZ1"
- ]
- }
- },
- {
- "name": "values",
- "spec": [
- {
- "name": "0",
- "type": "text",
- "label": "A"
- },
- {
- "name": "1",
- "type": "text",
- "label": "B"
- },
- {
- "name": "2",
- "type": "text",
- "label": "C"
- },
- {
- "name": "3",
- "type": "text",
- "label": "D"
- },
- {
- "name": "4",
- "type": "text",
- "label": "E"
- },
- {
- "name": "5",
- "type": "text",
- "label": "F"
- },
- {
- "name": "6",
- "type": "text",
- "label": "G"
- },
- {
- "name": "7",
- "type": "text",
- "label": "H"
- },
- {
- "name": "8",
- "type": "text",
- "label": "I"
- },
- {
- "name": "9",
- "type": "text",
- "label": "J"
- },
- {
- "name": "10",
- "type": "text",
- "label": "K"
- },
- {
- "name": "11",
- "type": "text",
- "label": "L"
- },
- {
- "name": "12",
- "type": "text",
- "label": "M"
- },
- {
- "name": "13",
- "type": "text",
- "label": "N"
- },
- {
- "name": "14",
- "type": "text",
- "label": "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"
- }
- ],
- "type": "collection",
- "label": "Values"
- }
- ],
- "advanced": true
- }
- }
- ],
- "metadata": {
- "version": 1,
- "scenario": {
- "roundtrips": 1,
- "maxErrors": 3,
- "autoCommit": false,
- "sequential": false,
- "confidential": false,
- "dataloss": false,
- "dlq": false
- },
- "designer": {
- "orphans": []
- },
- "zone": "eu1.integromat.com"
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement