Step by Step Guide
Go to Google Spreadsheet, click on “Add-ons” in the menu then “Get add-ons” in the submenu.
A popup will appear and click on search bar and write “Simple Workflow Manager”. Press enter key.
Click on the link to open "Simple Workflow Manager" directly.
Your search has finished with Simple Workflow Manager option. Just click on “Free” button.
A popup will appear for the confirmation, click on “Continue” button to continue the installing process.
Another window will open with your Gmail accounts lists. You have to select any one account to proceed with.
Then, another screen will appear with grant permissions – there you have to click on “Allow” button.
Go to the Google Spreadsheet, click the Add-ons menu and you’ll see a new menu called Simple Workflow Manager. Click on Configure Workflow.
A popup will appear on the right side of the sheet. Prepare the source data, refer to “How to prepare data” mentioned below these steps.
Create datasheet according to your requirements.
You can view three horizontal tabs on the top i.e. "plus" icon represents add workflow attributes, "timer" icon represents workflow history and "user" icon represents user settings.
You can add workflow attributes by entering workflow related details like Workflow Name, Workflow Process, when to Trigger, Capture Trigger's Input, Trigger Participant.
In Workflow Name you have to enter the name which you want to give to your workflow.
In Workflow Process you can add steps of the workflow and their respective details.
There are again two horizontal tabs i.e. trigger and workflow routing icon. In trigger, you can fill the trigger related details (explained below) and in next tab, you can find new route condition.
In trigger, you can choose trigger condition between "Initiate on Form Submission" and "Initiate Using this Google Sheet".
In "Generate Trigger from using Doc Template", you can select doc template for creating form dynamically.
Form is created on the basis of variables present in the doc file.
In "Trigger Participant" you can select the column from your sheet which contains the email id of first participant.
Click on Generate button to generate the form.
You can click on plus icon to add new step in the workflow.
Then, you have to add its details like Step Name, Step Participant, Capture Step's Input, Email to Notify Step Participant, Attach Dynamic Document in Email, Action Buttons.
In Step Name, mention the name which you want to give to step.
In Step Participant, select the column name from your sheet which contains the email id of step participants.
In Capture Step's Input, select the form which will sent to step participant .
In Action Buttons, you can select buttons in the form for step participant.
Click on Save, to save to details.
Click on Run to run the workflow.
When you click on Run, it automatically sends email to first participant and creates 3 sheets.
Check the email account of whose email ID is given in the first participant column. Click on the form link present in the email.
A blank form opens with the input fields that are present in the doc file as variables in double curly braces whose reference you have given in the "Generate Trigger from using Doc Template".
Fill the following details and click on Submit button.
Then email has been sent to step participant and then click on form link and fill the following details.
Three sheets created are as follows:
1. "Workflow_Master_Sheet" which gives you all the information in one sheet.
2. "Workflow_History_Sheet" which provides you the history of the workflow like Workflow Name, Work Item ID, Participant, Action, Time Stamp.
3. "Completed_Workflow_Sheet" is the sheet where all the completed work items are stored.