In an Adobe Workfront Fusion scenario, you can automate workflows that use Google Sheets, as well as connect it to multiple third-party applications and services.
For instructions about connecting your Google Sheets account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions
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** | Workfront Fusion for Work Automation and Integration |
Product | 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 Sheets modules, you must have a Google account.
Retrieves values from every newly added row in the spreadsheet.
The module retrieves only new rows that have not been filled in before. The trigger will not process an overwritten row.
If the worksheet contains a blank row, no rows after the blank row will be processed.
Connection | For instructions about connecting your Google Sheets 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 watch. |
Sheet | Select the sheet you want to watch for a new row. |
Table contains headers | Select whether the spreadsheet contains the header row.
|
Row with headers | Enter the range of the header row. For example, |
First table row | Enter the range of the first row of the table. For example, |
Value render option |
Formatted value The values will be calculated and formatted in the reply according to the cell's formatting. Formatting is based on the spreadsheet's locale, not the requesting user's locale. For example, if Unformatted value The values will be calculated, but not formatted in the reply. For example, if Formula The values will not be calculated. The reply will include the formulas. For example, if |
Date and time render option |
Serial number Instructs date, time, datetime, and duration fields to be outputted as doubles in "serial number" format, as popularized by Lotus 1-2-3. The whole number portion of the value (left of the decimal) counts the days since December 30th 1899. The fractional portion (right of the decimal) counts the time as a fraction of the day. For example, January 1st 1900 at noon would be 2.5, 2 because it's 2 days after December 30th 1899, and .5 because noon is half a day. February 1st 1900 at 3pm would be 33.625. This correctly treats the year 1900 as not a leap year. Formatted string Instructs date, time, datetime, and duration fields to be outputted as strings in their given number format (which is dependent on the spreadsheet's locale). |
Limit | Set the maximum number of results that Workfront Fusion will work with during one execution cycle. |
This module appends adds a row to a sheet.
When you configure Google Sheets modules, Workfront Fusion displays the fields listed below. Along with these, additional Google Sheets 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.
Connection | For instructions about connecting your Google Sheets 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. |
Mode | Select whether you want to select the spreadsheet and sheet manually or by mapping. Note: Manual mapping is useful, for example, when a new spreadsheet is created in an Workfront Fusion scenario and you want to add data in the newly created spreadsheet directly in the scenario. |
Spreadsheet | Select the Google spreadsheet. |
Sheet | Select the sheet you want to add a row to. |
Column Range | Select the column range you want to work with. |
Table contains headers | Select whether the spreadsheet contains the header row.
|
Values | Enter or map the desired cells of the row you want to add. |
Value input option |
|
Insert data option | Specify how existing data is changed when new data is input.
|
This module allows you to change the cell content in a selected row.
Connection | For instructions about connecting your Google Sheets 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. |
Mode | Select whether you want to select the spreadsheet and sheet manually or by mapping. Note: Manual mapping is useful, for example, when a new spreadsheet is created in the Workfront Fusion scenario and you want to add data to the newly created spreadsheet directly in the scenario. |
Spreadsheet | Select the Google spreadsheet. |
Sheet | Select the sheet you want to update a row in. |
Row number | Enter the number of the row you want to update. |
Table contains headers | Select whether the spreadsheet contains the header row.
|
Values | Enter or map the values to the desired cells of the row you want to change (update). |
Value input option |
|
Deletes values from a specified row.
Connection | For instructions about connecting your Google Sheets 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 Google spreadsheet that contains the sheet you want to clear a row from. |
Sheet | Select the sheet you want to clear data from. |
Row number | Enter the number of the row you want to clear data from. For example, |
Deletes a specified row.
Connection | For instructions about connecting your Google Sheets 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 Google spreadsheet that contains the sheet you want to delete a row from. |
Sheet | Select the sheet you want to delete a row from. |
Row number | Enter the number of the row you want to delete. Example: |
Retrieves a value from a selected cell.
Connection | For instructions about connecting your Google Sheets 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 Google spreadsheet. |
Sheet | Select the sheet that contains the cell you want to retrieve data from. |
Cell | Enter the ID of the cell you want to retrieve data from. Example: |
Value render option | Formatted value The values will be calculated and formatted in the reply according to the cell's formatting. Formatting is based on the spreadsheet's locale, not the requesting user's locale. For example, if Unformatted value The values will be calculated, but not formatted in the reply. For example, if Formula The values will not be calculated. The reply will include the formulas. For example, if |
Date and time render option | Serial number Instructs date, time, datetime, and duration fields to be outputted as doubles in "serial number" format, as popularized by Lotus 1-2-3. The whole number portion of the value (left of the decimal) counts the days since December 30th 1899. The fractional portion (right of the decimal) counts the time as a fraction of the day. For example, January 1st 1900 at noon would be 2.5, 2 because it's 2 days after December 30th 1899, and .5 because noon is half a day. February 1st 1900 at 3pm would be 33.625. This correctly treats the year 1900 as not a leap year. Formatted string Instructs date, time, datetime, and duration fields to be outputted as strings in their given number format (which is dependent on the spreadsheet's locale). |
Connection | For instructions about connecting your Google Sheets 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 Google spreadsheet. |
Cell | Enter the ID of the cell you want to update. Example: |
Value | Enter the new value for the cell. |
Value input option |
|
Deletes a value from a specified cell.
Connection | For instructions about connecting your Google Sheets 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 Google spreadsheet that contains the sheet that you want to clear a cell from. |
Sheet | Select the sheet you want to clear a cell from. |
Cell | Enter the ID of the cell you want to clear. Example: |
Creates a new sheet in a selected spreadsheet.
Connection | For instructions about connecting your Google Sheets 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 Google spreadsheet where you want to add a sheet. |
Properties |
|
Connection | For instructions about connecting your Google Sheets 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. |
Title | Enter the name of a new spreadsheet. |
Locale | Enter the locale of the spreadsheet in one of the following formats:
|
Recalculation interval | The amount of time to wait before volatile functions are recalculated: On change Volatile functions are updated upon every change. On change and every minute Volatile functions are updated upon every change and every minute. On change and hourly Volatile functions are updated upon every change and hourly. |
Time zone | Select the time zone of the spreadsheet. |
Number format | Select the default format of all cells in the spreadsheet. Text: Text formatting. Example: Number: Number formatting. Example: Percent: Percent formatting. Example: Currency: Currency formatting. Example: Date: Date formatting. Example: Time: Time formatting. Example: Date time: Date and Time formatting. Example: ScientificScientific number formatting. Example: |
Sheets | Click Add to add a sheet to the spreadsheet. For each sheet, enter or map a title for the sheet and the sheet's index. An index of 0 represents the first sheet. |
Deletes a specific sheet.
Connection | For instructions about connecting your Google Sheets 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 Google spreadsheet. |
Sheet | Select the sheet you want to delete. |
This action module allows you to perform a custom API call.
Connection | For instructions about connecting your [Fusion App] account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
URL |
Enter a path relative to https://sheets.googleapis.com/v4/ . |
Method |
Select the HTTP request method you need to configure the API call. For more information, see HTTP request methods in Adobe Workfront Fusion. |
Headers | Add the headers of the request in the form of a standard JSON object.For example, |
Query String | Add the query for the API call in the form of a standard JSON object. |
Body | Add the body content for the API call in the form of a standard JSON object. Note: When using conditional statements such as |
Searches rows using the filter options.
Connection | For instructions about connecting your [Fusion App] account to Workfront Fusion, see Create a connection to Adobe Workfront Fusion - Basic instructions |
Spreadsheet | Select the Google spreadsheet. |
Sheet | Select the sheet you want to search the rows in. |
Table contains headers | Select whether the spreadsheet contains the header row. If the Yes option is selected, the module doesn't retrieve the header row as output data and variable names in the output are then called by the headers. If the No option is selected, then the module also retrieves the first table row and variable names in the output are then called just A, B, C, D, and so on. |
Column range | Select the column range to work with. Example: A-F |
Filter | Set the filter for the row to be searched by. For more information about filters, see Add a filter to a scenario in Adobe Workfront Fusion. |
Sort order | Select whether you want to sort ascending or descending. |
Order by | Choose the column that you want to sort by. |
Value render option | Formatted value The values will be calculated and formatted in the reply according to the cell's formatting. Formatting is based on the spreadsheet's locale, not the requesting user's locale. For example, if Unformatted value The values will be calculated, but not formatted in the reply. For example, if Formula The values will not be calculated. The reply will include the formulas. For example, if |
Date and time render option | Serial number Instructs date, time, datetime, and duration fields to be output as doubles in "serial number" format, as popularized by Lotus 1-2-3. The whole number portion of the value (left of the decimal) counts the days since December 30th 1899. The fractional portion (right of the decimal) counts the time as a fraction of the day. For example, January 1st 1900 at noon would be 2.5, 2 because it's 2 days after December 30th 1899, and .5 because noon is half a day. February 1st 1900 at 3pm would be 33.625. This correctly treats the year 1900 as not a leap year. Formatted string Instructs date, time, datetime, and duration fields to be outputted as strings in their given number format (which is dependent on the spreadsheet's locale). |
Maximum number of returned rows | Set the maximum number of rows that Workfront Fusion will return during one execution cycle. |
Returns results matching the given criteria.
Connection | For instructions about connecting your Google Sheets 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 Google spreadsheet that contains the sheet you want to search.. |
Sheet | Select the sheet that contains the rows you want to search. |
Query | Use the Google Charts Query Language. Example: For more information on Google Charts Query Language, see Query Language Reference in the Google documentation. |
Connection | For instructions about connecting your Google Sheets 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 Google spreadsheet. |
Sheet | Select the sheet you want to get the range content from. |
Range | Enter the range you want to get. Example: |
Table contains headers | Check this box if the sheet has a header row |
Row with headers | Enter the range of the table headers. Example A1:F1 . If you leave the field empty, Workfront Fusion will suppose that the header is in the first row of the specified range. |
Value render option | Formatted value The values will be calculated and formatted in the reply according to the cell's formatting. Formatting is based on the spreadsheet's locale, not the requesting user's locale. For example, if Unformatted value The values will be calculated, but not formatted in the reply. For example, if Formula The values will not be calculated. The reply will include the formulas. For example, if |
Date and time render option | Serial number Instructs date, time, datetime, and duration fields to be output as doubles in "serial number" format, as popularized by Lotus 1-2-3. The whole number portion of the value (left of the decimal) counts the days since December 30th 1899. The fractional portion (right of the decimal) counts the time as a fraction of the day. For example, January 1st 1900 at noon would be 2.5, 2 because it's 2 days after December 30th 1899, and .5 because noon is half a day. February 1st 1900 at 3pm would be 33.625. This correctly treats the year 1900 as not a leap year. Formatted string Instructs date, time, datetime, and duration fields to be outputted as strings in their given number format (which is dependent on the spreadsheet's locale). |
This module returns a list of all sheets in a spreadsheet.
Connection | For instructions about connecting your Google Sheets 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 Google spreadsheet that contains the sheets you want to list. |
If the error 429: RESOURCE_EXHAUSTED
occurs, you have exceeded the API rate limit.
The Google Sheets API has a limit of 500 requests per 100 seconds per project, and 100 requests per 100 seconds per user. Limits for reads and writes are tracked separately. There is no daily usage limit.
See more details at developers.google.com/sheets/api/limits.
Use the Search Rows (Advanced) module & use this formula to get the columns which are empty.
select * where E is nullHere "E" is the column & "is null" is the condition. You can create a more advanced query using [Google Query Lang.](https://developers.google.com/chart/interactive/docs/querylanguage)
In Workfront Fusion, insert the Webhook > Custom webhooks module/trigger in the scenario and configure it (see Webhooks).
Copy the webhook’s URL.
Execute the scenario.
In Google Sheets, choose Insert > Drawing… from the main menu bar.
In the Drawing window, Click the Text box icon near the top of the window.
Design a button and click the Save and Close button in the top-right corner:
The button will be placed in your worksheet. Click the three vertical dots in the button’s top-right corner:
Choose Assign script… from the menu.
Enter the name of your script (function), e.g. runScenario
and click OK:
Choose Tools > Script editor from the main menu bar.
Insert the following code:
The name of the function must correspond to the name you specified in step 9.
Replace the URL with the webhook’s URL you copied in step 2.
function runScenario() {
UrlFetchApp.fetch("");
}
Press Ctrl+S to save the script file, enter a project name and click OK.
Switch back to Google Sheets and click your new button.
Grant the required authorization to the script:
In Workfront Fusion, verify that the scenario has successfully executed.
If you store a Date value in a spreadsheet without any formatting, it will appear in the spreadsheet as text in ISO 8601 format. However, Google Sheets formulas or functions that work with dates that do not understand this text (Example: formula =A1+10
) will display the following error:
To help allow Google Sheets to understand the date, format it with the formatDate (date; format; [timezone]) function. The correct format passed to the function as the second argument depends on the spreadsheet’s locale settings.
To determine the correct format:
Choose File > Spreadsheet settings from the main menu to verify/set the locale.
Once you have verified/set the proper locale, determine the corresponding date and time format by choosing Format > Number from the main menu. The format is displayed next to the Date time menu item:
To compose the correct format that should be passed to the formatDate() function, refer to the list of Tokens for date and time formatting in Adobe Workfront Fusion.
Example: The use of MM/DD/YYYY HH:mm:ss
format for the United States locale:
If you miss a built-in function, but it is featured by Google Sheets, you may exploit it. For more information, see Use Google Sheets functions in Map items using functions in Adobe Workfront Fusion .
You might find that a string of numbers that you are using as text is being interpreted as a date in a Google worksheet. For example, you type 1-2019, intending it as text, but Google interprets it as a date. You can pre-format the number as plain text to prevent this.
Another workaround in Workfront Fusion is to type an apostrophe (') before a number, for example, '1-2019 or '1/47. The apostrophe does not display in the cell after the data is sent from Workfront Fusion.