Read data from google sheets


i am looking to extract some data from a cell in google sheet that contains multiple data, however i need to capture the data, manipulate it before entering the data elsewhere. please see below.

the main data i need to capture is the WR number, there will be times when there will be a space between the WR and number e.g. wr 5748365 but other times it will be wr5648493

can anyone help me with this?

Has anyone got any suggestions?

Hi @nick.v

How to manipulate data on Google Sheets?
You can use UiPath.Gsuite.Activities, that package allows you to perform a variety of actions on Google services, including Google sheets

How to get the WR number?
You can extract that value from the cell value using Regular expressions. Here is a webpage where you can build your owns