Hi there! I need my automation to enter in a filter on google sheets so it can copy and paste information only in these lines that have been filtered, and in especific columns for one spreadsheet to another. How can I do this? Thank you sm!
Hi,
It can be done using following steps
Step 1: Install UiPath Packages: You’ll need the “UiPath.GSuite.Activities” package to work with Google Sheets.
Step 2: Use the “Read Range” activity to read the data from the Google Sheet that you want to filter in datatable
Step 3 : USE “Filter Data Table,” To filter the data
Step 4: Use write range to write the data to your desired sheet. Overwrite!
More info about Google spreadsheet activities are found here:
https://docs.uipath.com/activities/other/latest/productivity/google-sheets-application-scope
Hey! the range from the filter keeps changing everyday since is a LEADS track so everyday people are not bying this product anymore or more people are buying so is not an exact range. That’s why we use the filter. Is there any other form?