¶ GSheet Get Data Task
This task fetches data from a google sheet to local (EAConnect) file. Usually, an updated instance of a GSheet transformation will have been produced as a prior step in the flow (Refresh GSheet Instance Task). This task can update individual cell values in this Gsheet instance and fetch tabular data from specified cell range of specified sheet.
¶ Configuration Parameters
¶ Configuration Details:
- Transformation: This is the transformation (Transformation→GSheet). Data will be fetched from latest GSheet instance of this transformation.
- Update individual cell values in the sheet: for example Range = ‘Tab1!C3’, Value = ‘2023’ - these might be driver or filter values used in calculations.
- Use + Sign to add additional cell id and value pairs (same as 2 above)
- Specify sheet and row/column range to read data from - for example ‘OutputTab!A1:F’
- 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.
- File to extract data to. This local (to EAConnect) file can be used in subsequent steps of the flow.