Gagnez en rigueur grâce à l’automatisation des contrôles : saisie des résultats, détection des écarts, génération automatique des rapports qualité. Découvrez comment intégrer ces solutions dans vos process industriels.
Gagnez en rigueur grâce à l’automatisation des contrôles : saisie des résultats, détection des écarts, génération automatique des rapports qualité. Découvrez comment intégrer ces solutions dans vos process industriels.
{
"name": "Monitor Google Drive folder for new files and extract text with Google Cloud Vision to add to Google Sheets",
"flow": [
{
"id": 1,
"module": "google-drive:watchFilesInAFolder",
"version": 4,
"parameters": {
"limit": 2,
"select": "create",
"folderId": "/1XQUD03t52wyls-ZdQgbCMTuACXUltj65",
"mimeType": "all",
"destination": "drive"
},
"mapper": {},
"metadata": {
"designer": {
"x": 300,
"y": 0
},
"restore": {
"parameters": {
"select": {
"label": "By Created Time"
},
"folderId": {
"path": [
"stories"
]
},
"mimeType": {
"label": "All"
},
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "google-restricted"
},
"label": "My Google Restricted connection (l.govender@make.com)"
},
"destination": {
"label": "My Drive"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:google-restricted",
"label": "Connection",
"required": true
},
{
"type": "hidden"
},
{
"name": "select",
"type": "select",
"label": "Watch Files",
"required": true,
"validate": {
"enum": [
"create",
"modify"
]
}
},
{
"name": "destination",
"type": "select",
"label": "Choose a Drive",
"required": true,
"validate": {
"enum": [
"drive",
"share",
"team"
]
}
},
{
"name": "mimeType",
"type": "select",
"label": "File Types to Watch",
"required": true,
"validate": {
"enum": [
"all",
"document",
"spreadsheet",
"slide",
"drawing"
]
}
},
{
"name": "limit",
"type": "uinteger",
"label": "Limit",
"required": true
},
{
"name": "folderId",
"type": "folder",
"label": "Select the Folder to be Watched",
"required": true
}
]
}
},
{
"id": 2,
"module": "google-drive:getAFile",
"version": 4,
"parameters": {},
"mapper": {
"file": "{{1.id}}",
"select": "map",
"formatDrawings": "image/jpeg",
"formatDocuments": "application/vnd.openxmlformats-officedocument.wordprocessingml.document",
"formatSpreadsheets": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"formatPresentations": "application/vnd.openxmlformats-officedocument.presentationml.presentation"
},
"metadata": {
"designer": {
"x": 600,
"y": 0
},
"restore": {
"expect": {
"select": {
"label": "Enter manually"
},
"formatDrawings": {
"label": "JPEG"
},
"formatDocuments": {
"label": "MS Word Document"
},
"formatSpreadsheets": {
"label": "MS Excel"
},
"formatPresentations": {
"label": "MS PowerPoint"
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "google-restricted"
},
"label": "My Google Restricted connection (l.govender@make.com)"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:google-restricted",
"label": "Connection",
"required": true
}
],
"expect": [
{
"type": "hidden"
},
{
"name": "select",
"type": "select",
"label": "Enter a File ID",
"required": true,
"validate": {
"enum": [
"map",
"value"
]
}
},
{
"name": "formatDocuments",
"type": "select",
"label": "Convert Google Documents Files to Format",
"required": true,
"validate": {
"enum": [
"application/vnd.openxmlformats-officedocument.wordprocessingml.document",
"application/pdf",
"application/vnd.oasis.opendocument.text",
"text/html",
"text/plain",
"application/rtf"
]
}
},
{
"name": "formatSpreadsheets",
"type": "select",
"label": "Convert Google Spreadsheets Files to Format",
"required": true,
"validate": {
"enum": [
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"application/x-vnd.oasis.opendocument.spreadsheet",
"application/pdf"
]
}
},
{
"name": "formatPresentations",
"type": "select",
"label": "Convert Google Slides Files to Format",
"required": true,
"validate": {
"enum": [
"application/vnd.openxmlformats-officedocument.presentationml.presentation",
"application/pdf"
]
}
},
{
"name": "formatDrawings",
"type": "select",
"label": "Convert Google Drawings Files to Format",
"required": true,
"validate": {
"enum": [
"image/jpeg",
"image/png",
"image/svg+xml",
"application/pdf"
]
}
},
{
"name": "file",
"type": "text",
"label": "File ID",
"required": true
}
]
}
},
{
"id": 3,
"module": "googlecloudvision:DetectText",
"version": 1,
"parameters": {},
"mapper": {
"data": "{{2.data}}",
"imageSendMethod": "send_type_data",
"isToOptimizeDetection": false,
"isToIncludeFullTextAnnotation": false
},
"metadata": {
"designer": {
"x": 900,
"y": 0
},
"restore": {
"expect": {
"imageSendMethod": {
"label": "Data"
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "googlecloudvision"
},
"label": "My Google Cloud Vision connection"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:googlecloudvision",
"label": "Connection",
"required": true
}
],
"expect": [
{
"name": "imageSendMethod",
"type": "select",
"label": "Data/URL",
"required": true,
"validate": {
"enum": [
"send_type_data",
"send_type_url"
]
}
},
{
"name": "isToOptimizeDetection",
"type": "boolean",
"label": "Optimize the Detection for Dense Text and Documents",
"required": true
},
{
"name": "isToIncludeFullTextAnnotation",
"type": "boolean",
"label": "Include Full Text Annotation",
"required": true
},
{
"name": "data",
"type": "buffer",
"label": "Data",
"required": true
}
]
}
},
{
"id": 4,
"module": "google-sheets:addRow",
"version": 2,
"parameters": {},
"mapper": {
"from": "drive",
"mode": "select",
"values": {},
"sheetId": "Sheet1",
"spreadsheetId": "/1OBN2px7hcLH4AEaw2p08dU5g3Ti_prtpzSLfLgpa3XQ",
"includesHeaders": true,
"insertDataOption": "INSERT_ROWS",
"valueInputOption": "USER_ENTERED",
"insertUnformatted": false
},
"metadata": {
"designer": {
"x": 1200,
"y": 0
},
"restore": {
"expect": {
"from": {
"label": "My Drive"
},
"mode": {
"label": "Search by path"
},
"sheetId": {
"label": "Sheet1"
},
"spreadsheetId": {
"path": [
"App partner templates (last template reviewed)"
]
},
"includesHeaders": {
"label": "Yes",
"nested": [
{
"name": "values",
"spec": [
{
"name": "0",
"type": "text",
"label": "Date (A)"
},
{
"name": "1",
"type": "text",
"label": "Zone EU1 (B)"
},
{
"name": "2",
"type": "text",
"label": "Zone US1 (C)"
},
{
"name": "3",
"type": "text",
"label": "Zone Celonis ent EU1 (D)"
},
{
"name": "4",
"type": "text",
"label": "Zone Celonis ent US1 (E)"
},
{
"name": "5",
"type": "text",
"label": "Zone makerunsmake (F)"
},
{
"name": "6",
"type": "text",
"label": "Zone EU2 (G)"
},
{
"name": "7",
"type": "text",
"label": "Zone US2 (H)"
},
{
"name": "8",
"type": "text",
"label": "Monday board (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)"
}
],
"type": "collection",
"label": "Values"
}
]
},
"insertDataOption": {
"mode": "chose",
"label": "Insert rows"
},
"valueInputOption": {
"mode": "chose",
"label": "User entered"
},
"insertUnformatted": {
"mode": "chose"
}
},
"parameters": {
"__IMTCONN__": {
"data": {
"scoped": "true",
"connection": "google"
},
"label": "My Google connection (l.govender@make.com)"
}
}
},
"parameters": [
{
"name": "__IMTCONN__",
"type": "account:google",
"label": "Connection",
"required": true
}
],
"expect": [
{
"name": "mode",
"type": "select",
"label": "Search Method",
"required": true,
"validate": {
"enum": [
"select",
"fromAll",
"map"
]
}
},
{
"name": "insertUnformatted",
"type": "boolean",
"label": "Unformatted",
"required": true
},
{
"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": "from",
"type": "select",
"label": "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": "includesHeaders",
"type": "select",
"label": "Table contains headers",
"required": true,
"validate": {
"enum": [
true,
false
]
}
},
{
"name": "values",
"spec": [
{
"name": "0",
"type": "text",
"label": "Date (A)"
},
{
"name": "1",
"type": "text",
"label": "Zone EU1 (B)"
},
{
"name": "2",
"type": "text",
"label": "Zone US1 (C)"
},
{
"name": "3",
"type": "text",
"label": "Zone Celonis ent EU1 (D)"
},
{
"name": "4",
"type": "text",
"label": "Zone Celonis ent US1 (E)"
},
{
"name": "5",
"type": "text",
"label": "Zone makerunsmake (F)"
},
{
"name": "6",
"type": "text",
"label": "Zone EU2 (G)"
},
{
"name": "7",
"type": "text",
"label": "Zone US2 (H)"
},
{
"name": "8",
"type": "text",
"label": "Monday board (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)"
}
],
"type": "collection",
"label": "Values"
}
]
}
}
],
"metadata": {
"instant": false,
"version": 1,
"scenario": {
"roundtrips": 1,
"maxErrors": 3,
"autoCommit": true,
"autoCommitTriggerLast": true,
"sequential": false,
"slots": null,
"confidential": false,
"dataloss": false,
"dlq": false,
"freshVariables": false
},
"designer": {
"orphans": []
},
"zone": "eu2.make.com",
"notes": []
}
}