How to Update Column In Google Sheet

[NISHITHA]

Hello Team,

How can we update a Column from Range A4:A10 with 2024(Current Year)

And Range A11:A18 with 2023 Last Year Date

In Google Sheet

Thanks team in advance

[Saikarthik_Gajwel]

Hi @NISHITHA

Look at below similar solution

How to update cell values of a Column in Google Sheet - Help / Studio - UiPath Community Forum

Or you can also update it through HTTP Put request as per below doc

Method: spreadsheets.values.update | Google Sheets | Google for Developers

[lrtetala (Lakshman Reddy)]

Hi @NISHITHA

Please check this

How to update cell values of a Column in Google Sheet

@anmita Write cell by nature is used to write into one single cell… If you need to write data into multiple cells then you need to use write cell in a loop or use write range a tivity accordingly Hope this helps Cheers

Regards,

[Sai_Chandrika_Kopparapu]

Hi @NISHITHA

Please check the below flow:

Output:

Variable DataTypes:

Regards
Chandrika