Activity to check whether the sheet is present google spreadsheet

Help Activities
, ,
1

Hi Team,

I need to check whether the sheet is present in google sheet.
Please let me know which activity to be used to check whether the sheet exists.

Regards.

2

Hi @sowjanya.s

Check the below thread.

Regards

3

@sowjanya.s
GSuite Application Scope
JSONPath: “path/to/credentials.json”
Scopes: “https://www.googleapis.com/auth/spreadsheets.readonly”

Try Catch
    Try
        Read Range
            SpreadsheetId: "your_spreadsheet_id"
            SheetName: "SheetNameToCheck"
            Range: "A1:A1"
            Output: dt (DataTable)
    Catch
        Exception: System.Exception
        Sequence
            // Handle the exception (Sheet does not exist)
            Log Message
                Level: Error
                Message: "Sheet does not exist."
4

@sowjanya.s,

  1. Create an array of string variable.
  2. Use For Each Sheet in Spreadsheet.
  3. Add currenSheet name to array of the string variable.

This will give you all sheet names available in the spreadsheet. You can add further logic as per your requirement.

Thanks,
Ashok :slight_smile:

6

Hi @sowjanya.s

Please check the below image:

image
image853×673 26.6 KB

Regards

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.