![\"Jonathan](\"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-content\/uploads\/sites\/73\/2021\/03\/jonathan-gomes-headshot-96px.png\")
<\/p>\n<\/p>\n
Jonathan Gomes\nHead of Product at Sheetgo | LinkedIn<\/a>\nBalne\u00e1rio de Cambori\u00fa, Santa Catarina, Brazil<\/p>\n Sheetgo is a no-code automation tool made with Excel add-ins that enables users to build their own business process management systems \u2014 all from a spreadsheet. It allows users to:<\/span><\/p>\n Sheetgo\u2019s<\/span><\/a> web-based application allows Microsoft users to connect Excel spreadsheets stored in OneDrive and SharePoint to build custom, automated workflows. We wanted to make these functions even m<\/span>ore accessible by bringing them directly to where people\u00a0<\/span>work<\/span>:\u00a0<\/span>inside a spreadsheet. The Office Add-ins platform helped us to integrate<\/span>\u00a0<\/span>Sheetgo<\/span>\u00a0into Excel, enabling Microsoft users to connect and automate without leaving the spreadsheet\u00a0<\/span>they are<\/span>\u00a0working in.<\/span>\u00a0<\/span><\/p>\n Wh<\/span>ile the\u00a0<\/span>Sheetgo<\/span>\u00a0<\/span>web app offers a comprehensive platform for managing entire workflows, the add-in puts no-code automation right at the fingertips of every Excel user, allowing them to add or update connections without affecting productivity or\u00a0<\/span>int<\/span>e<\/span>rrupting the<\/span>\u00a0natural flow of\u00a0<\/span>their work.<\/span>\u00a0<\/span><\/p>\n The\u00a0<\/span>Sheetgo<\/span>\u00a0<\/span>add-in\u00a0<\/span>is\u00a0<\/span>formed of<\/span>\u00a0two\u00a0<\/span>components<\/span>:\u00a0<\/span><\/p>\n The<\/span>\u00a0first\u00a0<\/span>component<\/span>, the<\/span> application that interacts with the add-in task p<\/span>ane<\/span>,<\/span>\u00a0authenticates the user using a\u00a0<\/span>Sheetgo<\/span>\u00a0SSO session\u00a0<\/span>via<\/span> the dialog box and then identifies the spreadsheet<\/span>. It subsequently<\/span>\u00a0<\/span>loads the\u00a0<\/span>Sheetgo<\/span> web app inside it, as seen in the following sample:\u00a0<\/span><\/p>\n The second\u00a0<\/span>component<\/span>\u00a0is the\u00a0<\/span>Sheetgo<\/span>\u00a0web app<\/span>,<\/span>\u00a0<\/span>which<\/span>\u00a0<\/span>adapt<\/span>s<\/span>\u00a0to the add-in context and screen.\u00a0<\/span>When loaded by the add-in, t<\/span>he web app\u00a0<\/span>adjusts its<\/span>\u00a0format to fit the add-in screen and generate<\/span>s<\/span>\u00a0<\/span>a\u00a0<\/span>customized\u00a0<\/span>experience\u00a0<\/span>for<\/span>\u00a0<\/span>the\u00a0<\/span>Excel user.\u00a0<\/span>\u00a0<\/span><\/p>\n In t<\/span>he<\/span>\u00a0<\/span>Sheetgo<\/span>\u00a0web app<\/span>,\u00a0<\/span>the\u00a0<\/span>user can create multiple spreadsheet workflows and\u00a0<\/span>get a bird<\/span>\u2019<\/span>s-eye\u00a0<\/span>view<\/span>\u00a0<\/span>of the entire<\/span>\u00a0spreadsheet system\u00a0<\/span>and\u00a0<\/span>all connections.\u00a0<\/span>A<\/span>lthough a single spreadsheet file\u00a0<\/span>may<\/span>\u00a0belong to\u00a0<\/span>multiple\u00a0<\/span>complex\u00a0<\/span>workflows<\/span>,\u00a0<\/span>the add-in will\u00a0<\/span>only\u00a0<\/span>display<\/span>\u00a0the\u00a0<\/span>connections\u00a0<\/span>to and from th<\/span>e<\/span>\u00a0file the user is currently working in<\/span>.<\/span>\u00a0<\/span><\/p>\n Inside the<\/span>\u00a0add-in, t<\/span>he user sees\u00a0<\/span>the<\/span>\u00a0web app interface<\/span>\u00a0and<\/span>\u00a0<\/span>benefits from<\/span>\u00a0the\u00a0<\/span>web-app’s\u00a0<\/span>entire\u00a0<\/span>backend<\/span>. When the user connects two spreadsheets using the\u00a0<\/span>Sheetgo<\/span>\u00a0add-in,\u00a0<\/span>the\u00a0<\/span>Sheetgo<\/span>\u00a0web app backend communicat<\/span>es<\/span>\u00a0with\u00a0<\/span>the Microsoft <\/span>Graph API<\/a> to process data transportation\u00a0<\/span>f<\/span>rom one f<\/span>ile<\/span>\u00a0to another<\/span>.<\/span>\u00a0<\/span><\/p>\n The\u00a0<\/span>Sheetgo<\/span> web app uses the Microsoft Graph API for authenticatio<\/span>n,\u00a0<\/span>to\u00a0<\/span>list or create files and folders,<\/span>\u00a0and<\/span>\u00a0<\/span>to\u00a0<\/span>read and edit Excel files in OneDrive for Business or SharePoint sites\u00a0<\/span>and<\/span> groups.<\/span><\/p>\n Sheetgo<\/span>\u00a0gives individuals and teams the ability to create their own automated da<\/span>ta management workflows<\/span>\u00a0<\/span>\u2014<\/span>\u00a0<\/span>all from a spreadsheet. By connecting files, users can automate the process of gathering, distributing and sharing data for greater productivity, enhanced security<\/span>,<\/span>\u00a0and better business intelligence.<\/span>\u00a0<\/span><\/p>\n Our customers use\u00a0<\/span>Sheetgo<\/span>\u00a0to crea<\/span>te their own custom solutions for<\/span>:<\/span>\u00a0<\/span><\/p>\n Check out this demo video<\/a> to see Sheetgo in action:<\/p>\n\n
Why we build on the Office Add-ins platform<\/h3>\n
Sheetgo\u00a0Excel add-in anatomy<\/h3>\n
\n
OfficeAddinService.js\u00a0\n\n\/\/ Create an oauth2 flow for the SSO authentication\u00a0\n\nconst authFlow = buildAuthFlow()\u00a0\n\u00a0\n\n\/\/ Init the dialog box and authenticates the session user\u00a0\n\nOfficeService\u00a0\n\n\u00a0\u00a0\u00a0.openDialogBox(authFlow)\u00a0\n\n\u00a0\u00a0\u00a0.then((sessionUser) => {\u00a0\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/ Extract the file path from the browser URL\u00a0\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0const filePath = OfficeService.getFilePath()\u00a0\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/ Get the current file props (id, name, etc) using the Graph API\u00a0\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0const file = GraphAPI.fetchFileId(filePath)\u00a0\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/ Loads the Sheetgo application\u00a0\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0loadSheetgoApplication(sessionUser, file)\u00a0\u00a0\u00a0\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/ ...\u00a0\n\n\u00a0\u00a0 })\u00a0\n\n\u00a0\u00a0\u00a0.catch((e) => {\u00a0\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0console.log('Houston we have a problem :(', e)\u00a0\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/ Handle the auth error\u00a0\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/ ...\u00a0\n\n\u00a0\u00a0 })<\/pre>\nEnabling Excel users to automate their work<\/h3>\n
\n