Arbor Workflows: Adding a Spreadsheet

Arbor Workflows lets Advanced-Tier MATs integrate Google Sheets or Excel into workflows. Create a spreadsheet first in your chosen platform, select it, use “Workflow ID” as the first column, add headings and dynamic data, then sync changes to complete the integration.

 

As you delve into the world of workflows, you'll discover one of Arbor Workflows powerful features – its  integration with cloud services such as Google Sheets and Excel Spreadsheets. This integration streamlines the process of updating records within workflow steps, effectively saving time while upholding the accuracy of record keeping. 

This feature is currently only available to MATs on the Advanced Tier. The schools within the MAT will not have this feature but can benefit from MAT workflows that are rolled out to them.

Let's take a look at how to add a spreadsheet as a step in your workflow.

 

Begin by clicking Add Step within the workflow builder and selecting Spreadsheet. 

 

After choosing "Spreadsheet," you'll need to decide whether to integrate with Google Sheets or Excel Spreadsheets, dependent on which platform you use. Prior to linking, make sure you've already set up your spreadsheet template on one of these platforms.

 

If you have not set up your integration you will be directed to the settings area to do so.

For instance, if you want to input data about a new starter into a spreadsheet, ensure that you've already created a new spreadsheet named "New Starter Information" on Google Sheets or Excel. Note that we can't populate a sheet with information until you've created it.

Once your spreadsheet is all set and good to go, select your platform. For this example, we'll go with Google Sheets, but if you're using Excel, the steps are the same.

You’ll then need to select the spreadsheet that you would like to integrate with, using the drop-down menu in settings, as pictured below.

The first column of your spreadsheet will always need be entitled Workflow ID. This is where we allocate a unique ID number to each workflow, ensuring easy identification for future reference.

You can begin to populate other columns with headings which are relevant to the data you are collecting by selecting the '+' button. 

Once you've set up your column headings, the next step involves adding Dynamic data into the cells. This feature enables Arbor Workflows to fetch data from other parts of the workflow and automatically populate these cells with the corresponding information.

Accessing Dynamic Data is simple → click on the cell where you want the data to be displayed, and any relevant data collected in the workflow will become visible. You can then select and use it as Dynamic Data. 

To learn more about Dynamic data and how to add it, take a look at our guide Adding Dynamic Data

Once you've tagged your spreadsheet, click the 'Sync changes to sheets' button to finalise this step. A confirmation pop-up, similar to the one shown below, will appear when the integration is successful! 

 

Was this article helpful?
0 out of 0 found this helpful
I'm still stuck!

Comments

0 comments

Article is closed for comments.