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.

Example

Let’s say, you want to create a workflow that adds a new row to Google Sheets each time a note in 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 - Add Rows’ action to canvas and connect it to ‘Evernote’ trigger (Start icon) and Stop icon.

Step 3: Double click on the ‘Google Sheets - Add Rows’ action. A configuration window will appear on screen.

1-add-rows.png

Authorize Google Sheet: Select/add relevant authorization for your Google Sheets account.

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

2-dynamic-fetch.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’ service.