¶ Refresh Gsheet Instance Task
Google sheets are used for data transformation. This task uses an already configured google sheet to create a new instance of it with updated data.
¶ Prerequisite:
- A GSheet transformation is already configured (See Transformation→Gsheet)
Task configuration screen is as below:
¶ Configuration Details
- Transformation: This points to the google sheet template which has all the data transformation defined.
- Individual cells of google sheet to be updated with data (optional) : Example : Range = ‘Sheet1!A2’ Value = ‘12 / 31 / 2022’
- + sign is to add multiple entries of individual cell values to be populated.
- Sheet name, and file to be read into the sheet at specified row and column position
- + sign to add additional sheet names and files to be read into these sheets
- Cell position (e.g. Sheet1!A3) - optional : This cell identifies the last piece of calculation in the sheet template. Sometimes calculations can take significant amount of time and if the task should wait to finish till all calculations are done and sheet is completely refreshed then user can specify a cell location here. Task will wait till value in this cell has changed.
Once this task runs in a flow, a new GSheet instance (workbook) is created from the template sheet - with new data filled in as configured. This refreshed Gsheet workbook can be read in subsequent 'GSheet Get' task to get updated and transformed values.