What if you had a Sheetgo workflow which you want someone to execute - someone like an admin person
But you do not want to give access to that workflow to that admin
Since they do not have access to the workflow, they cannot run it directly - then how do they execute / run it
A possible workaround could be
- Make a simple form in the workflow - the contents of the form don’t really matter
- Put the workflow trigger as an on form submit trigger
- Create the form, publish it and send it to the admin person
- Every time the admin person wants to run the workflow, they simply submit the form
- When they submit, the on form submit trigger fires up and the workflow is executed
Here are the above steps in a bit of detail
Create a simple tab on a sheet within the workflow for the form
Use that tab to create a Sheetgo forms - these forms are built from the spreadsheet, learn more here
Link the form to the specific tab on the sheet which you created
After the form is generated it will look something like this
You will need to publish the form to get an URL, you can then share that URL to the form to your admin person who is going to submit it
Lastly, you will need to adjust the workflow to run on an on form submit trigger - you will need to configure the workflow to run on the submission of the above created form - learn more about this trigger
And that should be it - have your admin person submit the form and the Sheetgo workflow trigger will execute the workflow!
