Editing a Google Sheet in StudioX

I want to create an automation that makes some changes to a Google Sheet, but cannot tell how to get to Google Sheets in Studio X… is there a way to get to this application in StudioX?

Specifically I am looking at deleting rows and columns, adding some conditional formatting, etc.

Hello @Jim_Francis

Before writing the activity install the dependency that is required for accessing the google sheet.

Then you can access the activities for google sheet. Use the Use Google spreadsheet at first inside the activities add the function you want to do.

Venkatesh. R