Component Details
appmixer.google.spreadsheets.CreateRows
1.0.2
Public
Dynamic fields loaded from /component/appmixer/google/spreadsheets/CreateRows?outPort=out
{ "name": "appmixer.google.spreadsheets.CreateRows", "author": "Harsha Surisetty <harsha@client.io>", "description": "Add rows to Google Spreadsheet from a file. This allows you to add millions of rows in the Spreadsheet.", "icon": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAIAAAACACAYAAADDPmHLAAAAIGNIUk0AAHomAACAhAAA+gAAAIDo AAB1MAAA6mAAADqYAAAXcJy6UTwAAAAGYktHRAD/AP8A/6C9p5MAAAAHdElNRQfgBg4OKBjxoChH AAAAanRFWHRSYXcgcHJvZmlsZSB0eXBlIGFwcDEACmFwcDEKICAgICAgMzQKNDk0OTJhMDAwODAw MDAwMDAxMDAzMTAxMDIwMDA3MDAwMDAwMWEwMDAwMDAwMDAwMDAwMDUwNjk2MzYxNzM2MTAwMDAK 3JU+DAAAC9VJREFUeNrtnVuMXVUZx//ft/beZ1/OOZ3pbdrSaW2pgogaqHL3EkiEqCEC0Rh8UGMC Lz4x7Vx4NCaAkPgARiWgDeKNRBBjYhMVSkLlphSQWm4p2tTIlLbTdm7nnH32+nw4M9MOhaZz9j57 r5mzfslh0gf2Wevs317r29+31t6AxWKxWCyWboQ6cdDKj2+CNBNi3+sjps0CrACgiu5sWgSgVaXq xI39V/zN90qT37/85qKblBony4NF91yPyd/+E3B4o/Kcm0G4EaBzCVKGgIvubFoEQmXXr5Vc9+7G xNTdw7t2TN75+W8V3axUZDYCVH/6VWC6SSi71xLT9wBsXQon/VS0CLZU1+DLGy+blkTfU5uYuEM5 7vRdV3+n6Ka1TSYnqOcXX8f6Wx4Byu4NxHQ/BJ9eaid/Fmn9CVipbX65fHsSJ+HIUzuKblbbZHKS dF3j4ANfu4iI7oKgv+hO5URLgko41GzE0fCunxXdnrZILUD1JzdBpuplIhoGYUvRHcoZn5XaXoqC wWY9Dob++mDR7VkwqQVwPr4O5DqfAdF1s+NjlxGwUtv9Sms6GH5yR9HtWRCpBHC/sRVHr7wXAH0W QLXozhRIwIoH/Go0lCTNaHjXz4tuz1mTSoDKwOcQfPeqMhRfWHRHDCBgxdtLYTCYNJJw6InFIUEq AUoXnQfyHY8UdfPVfyotCcrBSFyvB0NPmB8YphJAoQIZrzFEluQtX5sErHggXFYe1lpHw7t2FN2e M5LqxGmMA7GmLg3+zkTASm0vhf5gkjTDIYNjgpRXrgbEnv0PoCVBEIzEU41g8EkzJbBDd2dpTQc9 5RGtdTRk4HRgBeg8ASve5gf+oCRJaNotohUgHwJWPOiF/khci8Mhg6YDK0B++Mw8EFSjEUmSaMSQ kcAKkC8BKx7wwmCw2UyMGAmsAPkTsOLBUhiMJHESFp0nsAIUg8+KB/xKMNKM46jIPIEVoDgCZh7w o2BQJ0k4VNB6AitAsQSs1GAp9EeSOA6HduW/nsAKUDw+sxrwo2gkiXU09GS+I4EVwAwCVmrAj8Ih iOSaLLICmEPAire7vj/cjOMwr5HACmAWPive5pfD25NmkosEVgDzCJjVbX4UjuhER51ecm4FMJOZ 5WX+UBzHUSdvEa0A5lJipbb5UTicNJodmw6sAGbTShaVoxHREg53YDqwAphPwIq3eaE/HDeamaeN rQCLA5+ZtwdRMJw04jDL1cZWgMVDq4BUDm9vxkk48tRDmRzUCrBACAQmBjO3/ub5YQ4c1x2o9FSH V5V7yj98bWfq/mT6gIilDhEwVhvHc2/sgcS6qDb4idaDx8aPH9hy/RUPpD2eFWABEAhH40k8PTUG /e4EZKox84iNjjxp5wMQAFQipo0vbEp9/q0AC4UAqMiDcpdBH56EPlEroAUApNUUAEmao9kYoB0E gKvAfRXwyjLAeY4A80j9xVaANDCBV4RQa6ogV2ExbpGzAmQAVUrgdctAkVd0UxaMFSAjKHCg1lbB PUG+MWFKrABZIQAcBq8ug1eVAcWLYkqwAmQNEbg3hFpbBZXMv8myAnQIKnvgdVXj4wIrQKcQgEoz cUFv2EojGogVoNMoBq8qg1eXAce8n9u8Fi1FCOCeoBUX+GbFBVaAHKHIa+ULKqWimzKHFSBPBCBX Qa2pgldERaaQ57ACFAETeGUE1VcBCk4hWwEKhKp+Ky4I3cLaYEREIhAkUswCi6JQxCAQKHSh1laR HJ6E5F5aNkAALRqbK324cdPloMWURE+BQPDo289g//goGAy4CqqvAu050EcnAZ3fnGCAAIINlZW4 9WNfAhuaLOlEn/9++E28deKdk3HgTGmZPAV9eAJST3IpKhUuANB62GgiyVJ9y8xpaNEf+IBVqpTA rjq55KzDGCHA+6GIU6ZPBVoL5JQQm4lAVIBksrAYh/xWClkfmYQ+Xuvo43iNFKCRxHj1yNtoJM22 j6GI8JHefvSUKhAICISD4+/iwPgo8i7Ye8rBhSs2wVMLiPZnSsvwFPSRKSDpTJBsnABMhKONSQw+ /xAOTR0DtTEKiACBcnDflbfisrUXIBEBE+HPB/6Be179AzjHUUBEsDrswcPXbMO6sBd6IVfzTGmZ PAf60ASk3szcXeMEAFo/Wi2JUUsabQ7ZAszeWhLmEi2xaEwnDSjK7yWmIhq1JIakGMYp8sDnVFtx wUS2cYGRApzS9baEF9DJ8OG03z3fm03J6Nuo5ECtqUIfmYI+Pp3ZlGC4AJY5BHOlZXgKcmw6k8Na ARYbM6VllLOpKHbHjfdSg5DZ4pIlKoAsihW5JmDkFEAEuKzgMreVHhYAHqvT/l9FBI955i4gH0O0 CFxWpi4JNE8ALYLlXgX3XPptNJK47fteBcL5vf1z991aBNdu+BTO792Q+2ZeT7lY7lUWlgPICeME AFqZs0v6zkt9HC0nU8ECwfrKKvRXVhfSJ1PL3UYKAHTmB2tdgeZdhUVirACKuK008BzSkui9xaA8 08BzTVlgMShPjBOAQJiIp/H7/bsxGdfaytsJAJcY127YivXV1dAiICLsGX0Tzx16PddcoEAQuT6+ svlKlN1gnpAmYJ4ABJyIp3Hfvp0YnTrW9l1AwA4+unwD+pf1ASJgEF449AbueOWxVqk5J7QI+sIe XN1/MSpeYNyLVo0TYBZFDIfavw1UzCf/MQsRHOJ8BYDk+n0LxdyWdQjDLsDC6ToBLPOxAnQ5VoAu x9ggcJb25mw5Q7Qtp/zXYqQARASPHXjstLcmEIDPzml3EA4xSuzmviaw3X7kgXECtIpBEe6+5Jto 6BjtVm4YhPPeUwz6woatOK9nfc5P6xB47GK5F9li0NniKReXrDk/1VUjALTWpxWDNlT7cu+PTQW3 QSI684lai0BLqkfrLjmMFaC1e7Z9BPPLwcBMMaiADagCWw4+a2aLQY/t343JZq3NZeGASwrXbdiK 9ZVWMYiJsOfQm3h29LVcAzIBEDk+brDFoLNjthj0o31/wujUWGv79AIRCALl4oLefvRX1wCSgEB4 fvR13Pnyo7luDNHQ6At7cY0tBi0MRQoOOSmKQQoAzdtYScRw2Mm5Gsi5CrdQui4TaNgFWDhdJ4Bl PlaALscK0OUYGwRqCDQ0IO3dBcylXU/ZHg4RaNHQOeYCNDS0wZGHkQI4zNgYrkTEbtsLOH12EChv XtTX40U4t7waTJzbKREIVvrL4LCZg61xAmgRrChVcO9Vt6QqnhCAZaXyXAYuEY0vbroUnz3nE7m/ 0oWJsLxkdwadNUyMVWFv6lTwe5/KEbkByl6Qe3/ery2mYJAA80+3SPZJUznjQpHi+lokRgggEDR1 s5BdO0Wg37NjqUgKF0ARY9/YQdy2+36YdGV0FsG+sYNG7BcoXAAiwuH6OHYefMmQayKHPqO1ccWE ZWKFCwC0SsAOm1swWcoUPwZZCsUK0OVYAbocK0CXYwXocqwAXY4VoMuxAnQ5VoAuxwrQ5VgBupyU AlDOW60tWZNKgAQ1yHQMEUN3Pi5VBJA4yeTKSyXA5A/+gvrO15sy0RjtmlK+IejjtQlksIAilQAT Q3+EjE3V5fj0XmOWuHQBkujjyf4jbyGDnW5ZBIHN+KX/Piv15kE7CuQAATJefzl++u29AFJPvZkI UH9877+S/Uceh5b2X/VpOSskTo7HLx58pLn3nf8hAwGyWIYjAJp6dHxMfXjlJq74H0L3LO7LFy31 5muHflX75Yu/RpyMAkj9vJus1mElMjY9qY9MvqPW96zlSqm/a5b45gERJNFTyb5Dv6vteP5BOVF/ E0AmLw7MSgABUNejE8eabx1+m3sCzVV/DbkqBFHrNZ72095HpKnHpvfHu//9UO03ex6WE7V9AMaR 0aMOsh6qHQC95KnNzifXXexcdM6lau2yLVT2eot5b/siJtFNOV47lBwY29d49j/PJG8dfgXAAbRO fmZ5l07M1QwgALACwCry3ZUUuaEVYGFIopsy0RhHnBwG8C6AMQB1ZPyQk04GawzAm/k4Hf6upYgG EANozPy1eRaLxWKxZMn/AXY881R32b5qAAAAJXRFWHRkYXRlOmNyZWF0ZQAyMDE2LTA1LTE2VDE2 OjExOjE4KzAyOjAwpN8mdQAAACV0RVh0ZGF0ZTptb2RpZnkAMjAxNi0wNS0xNlQxNjoxMToxOCsw MjowMNWCnskAAAAASUVORK5CYII=", "auth": { "service": "appmixer:google", "scope": [ "https://www.googleapis.com/auth/spreadsheets", "https://www.googleapis.com/auth/spreadsheets.readonly", "https://www.googleapis.com/auth/drive.readonly" ] }, "quota": { "manager": "appmixer:google:spreadsheets", "maxWait": 10000, "resources": "write", "scope": { "userId": "{{userId}}" } }, "dependencies": { "service": "1.2.1" }, "version": "1.0.2", "properties": { "schema": { "properties": { "generateInspector": { "type": "boolean" }, "sheetId": { "type": "string" }, "worksheetId": { "type": "string" }, "fileId": { "type": "string" }, "fileUrl": { "type": "string" }, "delimiter": { "type": "string" }, "append": { "type": "boolean" } } } }, "inPorts": [ { "name": "in", "source": { "url": "/component/appmixer/google/spreadsheets/CreateRows?outPort=out", "data": { "properties": { "generateInspector": true, "sheetId": "inputs/in/sheetId", "worksheetId": "inputs/in/worksheetId", "fileId": "inputs/in/fileId", "append": "inputs/in/append", "autoMatch": "inputs/in/autoMatch" } } } } ], "outPorts": [ { "name": "out", "options": [ { "label": "Spreadsheet Id", "value": "spreadsheetId" }, { "label": "New rows count", "value": "newRows" } ] } ] }