How to color any cell of Google Sheet using UiPath

Help Studio
, ,
1

I’m using GSuite package and there is a requirement to setting color as per the business needs to a particular cell of a google sheet. Which activity to use for achieving this?

2

Try This

To set the color of a particular cell in a Google Sheet using the UiPath GSuite package, you can use the “Set Range Color” activity. Here are the steps to achieve this:

  1. Open your UiPath project and add the “Set Range Color” activity to your workflow.
  2. In the “Properties” panel, configure the following properties:
  • Range: Enter the range of cells you want to apply the background color to, in A1 notation (e.g., “A1:C5”).
  • Color: Choose the background color you want to apply to the cells.
3

I’m not seeing 'Set Range Color" activity in the GSuite activities list. Could you please let me what could be the reason of that? FYI GSuite package is already installed.

Also, I’m able to see this activity for Excel application Scope and not for GSuite

4

My bad. Let me double check. I was expecting the same in GSuite as well