The Adobe Workfront Fusion Google Forms modules allow you to monitor, select, add, update or delete responses on your Google Forms.
In order to use Google Docs with Adobe Workfront Fusion, it is necessary to have a Google account. If you don’t have a Google account yet, you can create one at the Google Account help page.
If you need instructions on creating a scenario, see Create a scenario in Adobe Workfront Fusion.
For information about modules, see Modules in Adobe Workfront Fusion.
You must have the following access to use the functionality in this article:
Adobe Workfront plan* | Pro or higher |
Adobe Workfront license* | Plan, Work |
Adobe Workfront Fusion license** |
Current license requirement: No Workfront Fusion license requirement. Or Legacy license requirement: Workfront Fusion for Work Automation and Integration |
Product |
Current product requirement: If you have the Select or Prime Adobe Workfront Plan, your organization must purchase Adobe Workfront Fusion as well as Adobe Workfront to use functionality described in this article. Workfront Fusion is included in the Ultimate Workfront plan. Or Legacy product requirement: Your organization must purchase Adobe Workfront Fusion as well as Adobe Workfront to use functionality described in this article. |
To find out what plan, license type, or access you have, contact your Workfront administrator.
For information on Adobe Workfront Fusion licenses, see Adobe Workfront Fusion licenses.
To use Google Forms modules, you must have a Google account.
In order to work with your form responses, the spreadsheet from your responses must be created.
Open your form.
Go to the Responses tab.
Click the Create Spreadsheet icon .
Select whether you want to create a new spreadsheet or an existing spreadsheet
Click Create.
When you configure Google Forms modules, Workfront Fusion displays the fields listed below. Along with these, additional Google Forms fields might display, depending on factors such as your access level in the app or service. A bolded title in a module indicates a required field.
If you see the map button above a field or function, you can use it to set variables and functions for that field. For more information, see Map information from one module to another in Adobe Workfront Fusion.
Watches the form for new responses.
Connection | For instructions about connecting your Google account to Workfront Fusion, see Connect the module's app or web service to Workfront Fusion in the article Create a scenario in Adobe Workfront Fusion. |
Spreadsheet | Select the spreadsheet that contains the responses from the form that you want to watch for new responses. |
Sheet | Select the sheet that contains the form responses. |
Row with headers | Specify the header row of the table. The default row is A1:Z1 . |
Value Render Option | Specify how you want the values to be rendered in the output.
|
Date and time render option | Select how you want dates, times, and duration to be represented in the output. This field is ignored if Value Render Option is set to Formatted Value. |
Limit | Set the maximum number of responses that Workfront Fusion works with during one cycle. |
This module appends a new response to the bottom of the form’s spreadsheet.
When you are configuring this module, the following fields display.
Connection | For instructions about connecting your Google account to Workfront Fusion, see Connect the module's app or web service to Workfront Fusion in the article Create a scenario in Adobe Workfront Fusion. |
Spreadsheet | Select the spreadsheet that contains the sheet where you want to add a response. |
Sheet | Select the sheet that contains the form responses. |
Values |
Enter the desired values to the sheet columns. For the Timestamp column in the correct format, use the following value: formatDate(now;DD/MM/YYYY HH:mm;UTC) |
Value input option |
|
Insert data option | Specify how existing data is changed when new data is input.
|
This module updates the selected response.
When you are configuring this module, the following fields display.
Connection | For instructions about connecting your Google account to Workfront Fusion, see Connect the module's app or web service to Workfront Fusion in the article Create a scenario in Adobe Workfront Fusion. |
Spreadsheet | Select the spreadsheet that contains the sheet where you want to update a response. |
Sheet | Select the sheet that contains the form responses. |
Row number |
Enter or map the number of the row you want to update. |
Values |
Enter the new values to the desired columns. |
Value input option |
|
This module deletes a selected response.
Connection | For instructions about connecting your Google account to Workfront Fusion, see Connect the module's app or web service to Workfront Fusion in the article Create a scenario in Adobe Workfront Fusion. |
Spreadsheet | Select the spreadsheet that contains the sheet where you want to delete a response. |
Sheet | Select the sheet that contains the form responses. |
Row number |
Enter or map the number of the row you want to delete. |
This module returns responses matching the given criteria.
Connection | For instructions about connecting your Google account to Workfront Fusion, see Connect the module's app or web service to Workfront Fusion in the article Create a scenario in Adobe Workfront Fusion. |
Spreadsheet | Select the form you want to search in. |
Sheet | Select the sheet that contains the form responses. |
Column range | Select the column range you want to search. |
Filter | Define the filter you want to search responses responses by. |
Sort Order | Select whether to sort returned responses in ascending or descending order. |
Order By | Select the column you want to order returned responses by. |
Value Render Option | Specify how you want the values to be rendered in the output.
|
Date and time render option | Select how you want dates, times, and duration to be represented in the output. This field is ignored if Value Render Option is set to Formatted Value. |
Maximum number of returned responses | Set the maximum number of responses that Workfront Fusion returns during one cycle. |
This module performs a search using the Google Charts Query Language. This module does not return a row number.
Connection | For instructions about connecting your Google account to Workfront Fusion, see Connect the module's app or web service to Workfront Fusion in the article Create a scenario in Adobe Workfront Fusion. |
Spreadsheet | Select the spreadsheet that contains the sheet you want to search. |
Sheet | Select the sheet that contains the form responses. |
Filter | Define the search query using the Google Charts Query Language. Example: |
Maximum number of returned rows | Set the maximum number of responses that Workfront Fusion returns during one cycle. |