How to use Dynamic Forms in a Google Sheets action
Dynamic Forms make it easier to work with actions that expect data for custom fields. In this tutorial, we will understand how to use the Dynamic Forms feature in a Google Sheets action, with the help of an example.
How it works
Let's say, you want to create a workflow that adds a new row to Google Sheets each time a note is created in Evernote. To do this, follow the steps given below:
-
Add and configure Evernote - New Note trigger.
-
Drag Google Sheets connector on canvas and connect it to Evernote trigger (Start icon) and Stop icon.
-
Double-click the Google Sheets connector, and select Add Row action from the Select Action drop-down list. Select/add the account for Google Sheets that you want to use to execute this action. Read more about Creating accounts.
Once you have specified the account, click Next. You will see the configuration window.
-
Spreadsheet ID: Select/specify the ID of the spreadsheet in which you want to add a row.
-
Sheet ID: Select/specify the ID of the sheet in which you want to add a row.
As soon as you specify the Sheet ID, IBM® webMethods Integration will automatically fetch the headers of all columns of the specified sheet in the configuration window.
You can then add/enter the relevant values for each of these columns. You can keep a column blank if you do not want to provide a value for it. This makes it easy for you to add rows to your Google Sheets spreadsheets.
Once you have entered all the required details, click Next, test the action, and click Done to return to the canvas.
-