How Dynamic Forms work with Google Sheets

Dynamic Forms make it easier to work with actions that expect data for custom fields. In this tutorial, we will understand how to use 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:

Step 1: Add and configure Evernote - New Note trigger.

Step 2: Drag Google Sheets connector on canvas and connect it to Evernote trigger (Start icon) and Stop icon.

Step 3: 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.

1-dynamic-forms.png



Step 4: Once you have specified the account, click Next. You will see the configuration window similar to the one given below:

Google_sheets_action_configure.PNG


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, webMethods.io Integration will automatically fetch the headers of all columns of the specified sheet in the configuration window.

action_configure_data.PNG

You can then add/enter the relevant values for each of these columns. You can keep a column blank if you don’t want to provide 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 on Next, test the action, and click on Done to return to the canvas.

Note: As of now, the Dynamic Forms feature has been enabled only for the actions of the Google Sheets application.